cancel
Showing results for 
Search instead for 
Did you mean: 

Best DBMS for PowerDesigner Repository

former_member217396
Participant
0 Kudos
279

Hi all,

since we are struggle with heavy performance issues using MS SQL Server as PD Repository DB, did someone compared repositories on different DBMS?

Which one is the fastest one? But let's forget HANA, as SAPs answer to any issue related to a DB other that HANA is "we recommend you to upgrade to HANA".

I can't find such comparison anywhere in the Internet.

What are you guys using in most of the cases? We have often used MS SQL Server, but since few PD Releases it getting slower and slower.... so maybe it's time to think about a migration to other DBMS...

BR,

Rafal

View Entire Topic
former_member200945
Contributor
0 Kudos

I think your real question is which database working best for repository.

For SQL Server, read the following

https://help.sap.com/saphelp_pd1660_install/helpdata/en/13/25807bf9c14675a19005f2f570f7ce/frameset.h...

Other than that, there is not much difference.

When you run into performance issue, most likely it is caused by repository size, network traffic, available random access memory, etc.

This is especially true if you are using direct connect.

If you are using proxy server, you need add more cached memory for the server.