June 17, 2014 at 5:53 am
Hello,
my boss would like to compare the performance of our SQL server (17).
He would like to capture this KPI, and show it in a scorecard.
Now I look for meaningful KPI, and a chance to save them, and according to weekly, monthly or evaluate.
Does anyone have a tip or an interesting page where you can enter with this issue?
Thanks
Kind regards,
Andreas
June 17, 2014 at 6:11 am
There are a fairly large number of performance measures. The best documentation I have on that is in my book on query tuning. There's a link below. It also covers how to gather those metrics.
Another option would be to get one of the third party monitoring tools which have already put together the data collection and the reports for you.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply