I hope I would receive some helpful info. regarding below mentioned question.
It is about database tuning for performance.
Are there any parameters to take into consideration for DB tuning? If there are then Pl provide.
Pl consider this case as in situation where DB is not designed by DB professional and the DB is in production environment.
How to know the existing DB structure is tuned as good enough or well or perfect?
Can we think of index usage DMV for that analysis?
i.e. suppose we have 100 indexes for a DB and most of the operations performed through index scan than index seek.
Or any other way to reach to the decision?
Pl provide detailed info. if possible.
I know I have asked very long ?. Heartly sorry for this one.
Thanks in advance
View Complete Post