Post reply

Creating Performance Dashboard reports on 2008 R2 and 2012

  • May 2, 2013 at 10:54 am

    #277339

    Hi All,

    I got a requirement to create dashboard reports for all SQL Servers. The requirement is to performance(CPU, Memory, bottlenecks, diskspace growth, costly queries etc etc) report to all DBA every morning. We might schedule this jobs every week or daily depending upon necessity.

    Can someone please guide me how to start on this ?

    Most of the servers are 2008 R2 and 2012.

    Also please let me know how does this Microsoft® SQL Server® 2012 Performance Dashboard Reports helps me in this scenario ?

    http://www.microsoft.com/en-us/download/details.aspx?id=29063

    Thanks all.

  • May 2, 2013 at 9:43 pm

    #1612073

    You May use data collection for instant reports. In this report you can memory, disk i/o, cpu bottlenecks, query statistics, disk usage etc.

    Hope it will help..

  • May 2, 2013 at 9:45 pm

    #1612074

    You should certainly consider these products. BTW, I do NOT work for this company, but just know they have a superior product for just the sort of things you seem to be asking about.

    SQL SENTRY PERFORMANCE MONITOR

    SQL SENTRY EVENT MANAGER

     

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

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