SQL Monitor running slow

Monitor, diagnose and receive alerts to problems across your SQL Servers.

SQL Monitor running slow

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


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.


Posts: 3
Joined: Tue Jan 31, 2012 10:54 pm

purging sql monitor database data

Postby RajK » Thu Feb 02, 2012 7: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

Posts: 58
Joined: Thu Feb 02, 2012 7:21 am

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


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.

Robin Anderson
Red-Gate Software
Posts: 148
Joined: Fri Jun 05, 2009 11:13 am
Location: Cambridge

Return to SQL Monitor Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests