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

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Monitor 2
SQL Monitor 2 forum

SQL Monitor running slow

Search in SQL Monitor 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
philstevens



Joined: 31 Jan 2012
Posts: 3

PostPosted: Tue Jan 31, 2012 11:59 pm    Post subject: SQL Monitor running slow Reply with quote

Hi

I'm having issues with SQL Monitor at the moment where the DB is growing out of control (around 90GB at the moment) and it is killing the web server that the web interface is running off. Any ideas for how to speed this up? E.g. deleting old alerts from the DB or anything else you might think of.

Thanks

Phil
Back to top
View user's profile Send private message
RajK



Joined: 02 Feb 2012
Posts: 58

PostPosted: Thu Feb 02, 2012 8:25 am    Post subject: purging sql monitor database data Reply with quote

Hi Phil,

You should be able to purge SQL Monitor database data by changing the length of time it keeps the data. The information to do this is available at the following location. Please attempt to change the settings and let us know your findings on this issue.

http://www.red-gate.com/supportcenter/Content/SQL_Monitor/help/2.3/SM_Purging

Regards,
Back to top
View user's profile Send private message
RBA



Joined: 05 Jun 2009
Posts: 148
Location: Cambridge

PostPosted: Thu Feb 02, 2012 5:53 pm    Post subject: Reply with quote

Hi,

You can also reduce the collection rate, so SQL Monitor polls (and thus stores) less frequently.

This is done by editing an XML file, details for which are available upon request.

Cheers,
_________________
Robin Anderson
Development
Red-Gate Software
Back to top
View user's profile Send private message Send e-mail
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