SQL Monitor running slow

SQL Server performance monitoring and alerting

Moderators: eddie davis, priyasinha, Adam, chriskelly, Chris Lambrou, Chris Spencer

SQL Monitor running slow

Postby philstevens » Tue Jan 31, 2012 11:59 pm

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
philstevens
 
Posts: 3
Joined: Tue Jan 31, 2012 11:54 pm

purging sql monitor database data

Postby RajK » Thu Feb 02, 2012 8:25 am

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/C ... SM_Purging

Regards,
RajK
 
Posts: 58
Joined: Thu Feb 02, 2012 8:21 am

Postby RBA » Thu Feb 02, 2012 5:53 pm

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
RBA
 
Posts: 148
Joined: Fri Jun 05, 2009 12:13 pm
Location: Cambridge


Return to SQL Monitor 2

Who is online

Users browsing this forum: No registered users and 0 guests