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 Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • 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