Hi All,

We are redesigning the our database due to performance issues. Is there any tool which helps us to provide insight of whats wrong in our DB structure.

Please provide your valuable suggestions for DB redisign

Hi DBALearner,

What performance issues do you get? Could you please share us some examples?

In addition, in SQL Server, you can use Database Engine Tuning Advisor tool to tune the physical design of your database. Database Engine Tuning Advisor uses a representative workload in the form of a Transact-SQL script, a trace file, or a trace table, to analyze the effects of running that workload on databases that have been selected for tuning.

After consuming the workload, Database Engine Tuning Advisor produces a recommended configuration of physical database design structures to improve performance for the workload that was tuned. For more details, please review this article.



Thanks,
Lydia

Hello,

No tool can guess your Business logic and requirements for the database design. But if you are going to re-engineer your DB design then I like to suggest to use SSDT = SQL Server Database Tools for this; see Download Latest SQL Server Data Tools