Red Gate forums :: View topic - SQL Monitor
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Response 1
SQL Response 1 forum

SQL Monitor

Search in SQL Response 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
Kwisatz78



Joined: 18 Oct 2010
Posts: 7

PostPosted: Mon Oct 18, 2010 4:32 pm    Post subject: SQL Monitor Reply with quote

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
Back to top
View user's profile Send private message
priyasinha



Joined: 03 Jan 2007
Posts: 530

PostPosted: Tue Oct 19, 2010 1:02 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Kwisatz78



Joined: 18 Oct 2010
Posts: 7

PostPosted: Wed Oct 20, 2010 10:24 am    Post subject: Reply with quote

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?
Back to top
View user's profile Send private message
benrees



Joined: 27 Sep 2010
Posts: 16

PostPosted: Wed Oct 20, 2010 10:51 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group