Post reply

Data that should be included in performance report

  • April 5, 2012 at 4:05 am

    #258721

    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 🙂

    Sujeet Singh

  • April 5, 2012 at 5:45 am

    #1469424

    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

    #1469427

    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!

    Sujeet Singh

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply