SQL Monitor

[Kwisatz78]

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

[priyasinha]

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

[Kwisatz78]

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?

[benrees]

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