4 votes

Significance of Historical waits report in SQL server Performance dashboard

compared to what? This report stinks for a couple reasons: It doesn't tell you how long the server has been up It doesn't tell you how long each wait lasted on average I wouldn't use this to try to ...
Erik Darling's user avatar
  • 40.8k
1 vote

How can I optimize dashboard performance?

It will be hard to guess without much information provided related to data as mentioned by David and probably why there is no indication of missing indexes. One more point that I can guess why there ...
KASQLDBA's user avatar
  • 7,159
1 vote
Accepted

How can I optimize dashboard performance?

suggest any missing indices which could help You need to show what indexes you currently, and the size & shape of your data (approx how many rows historically?, and how many new are added each ...
David Spillett's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible