April 5, 2012 at 4:05 am
Hi ,
I want to prepare a report(weekly/monthly) that collects the performance data related to SQL Server. Can anybody suggest the columns/format for that?
Thanks 🙂
April 5, 2012 at 5:45 am
That's a very large topic. I have one chapter of my performance tuning book focused on the important metrics you need to collect. I really don't want to replicate the chapter here.
In general, focus on wait stats and queues. Those are early indicators of performance issues.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
April 5, 2012 at 5:49 am
Grant Fritchey (4/5/2012)
That's a very large topic. I have one chapter of my performance tuning book focused on the important metrics you need to collect. I really don't want to replicate the chapter here.In general, focus on wait stats and queues. Those are early indicators of performance issues.
Thanks Grant!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply