Skip to Content
0

Best DBMS for PowerDesigner Repository

Jan 02 at 10:28 AM

56

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Phillip Lam
Jan 22 at 08:47 PM
0

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.htm

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.

Share
10 |10000 characters needed characters left characters exceeded