SQL Monitor

Kwisatz78Kwisatz78 Posts: 11
edited October 20, 2010 5:51AM in SQL Monitor Previous Versions
Hi - I am wondering if its possible to use SQL monitor to baseline your enivronments, such that you can store historical numbers and graphs about IOs, CPU and memory usage?

The idea is that I can periodically generate baselines for capacity planning.

Thanks
· Share on Twitter

Comments

  • priyasinhapriyasinha Posts: 548 Silver 1
    Hi,

    Thanks for your feedback.

    SQL Monitor does store historical data. You can view all these information over period of time via the Analysis page. We do show some basic stats also. Having said that we do not do any trending on that data yet.

    The best place to give feedback about SQL Monitor would be this forum or via email to eapresponse@red-gate.com.

    Thanks and Regards,
    Priya
    Priya Sinha
    Project Manager
    Red Gate Software
    · Share on Twitter
  • Kwisatz78Kwisatz78 Posts: 11
    Hi - yes I think that would be a useful feature and one that could be easily built upon if you already store the data.

    That said in the mean time is it possible to use the data in the SQL Monitor's database to perhaps build our own reports from using SSRS?
    · Share on Twitter
  • benreesbenrees Posts: 16 Bronze 1
    Hi - yes, absolutely. The data is stored in a SQL Server backend. We've created a number of VIEWs to help the user understand the database schema and we'll also be providing some sample SSRS reports to help users get started.

    Regards

    Ben Rees
    · Share on Twitter
Sign In or Register to comment.