Growth rate of data repository

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

Growth rate of data repository

Postby nkelly » Mon Mar 12, 2012 6:07 pm

I found this documentation on your website:

"What is the growth rate of the SQL Monitor Data Repository?
You should expect the Data Repository database to grow by about 35 - 100 MB per day for each SQL Server instance you are monitoring. If you monitor 10 SQL Servers for a week, your database will increase by between 2 and 7 GB.
Note: This amount will depend on how busy your monitored SQL Servers are, particularly the number of Windows processes, SQL processes and the number of databases on each instance."

Is this regardless of what the purge data timeframe is set to? My data repository is 130GB. Is there any way to shrink that or is it going to continually grow at this rate? It has been installed for less than a year and I am monitoring five servers (8 instances)(182 databases).

Thanks for any advice,
Posts: 1
Joined: Mon Mar 12, 2012 5:48 pm

Postby Chris Spencer » Wed Mar 14, 2012 11:51 am

Hi Nicole

The growth rate would remain consistent providing you don't add/remove servers but the database size should eventually remain constant as all data rows older than the purge setting are removed.

Is your data repository still growing or is it constant at ~130GB? Also what are your purge settings?

The only way to reduce the stored data is to lower the purge settings. If you've already reduced the settings but have seen no size reduction then it's likely due to the fact that SQL Server by default doesn't remove unused pages. As far as I know the only way to do this is using the DBCC SHRINKDATABASE and DBCC SHRINKFILE commands or the equivalent in SQL Server Management Studio.

Chris Spencer
Test Engineer
Red Gate
Chris Spencer
Posts: 301
Joined: Tue Aug 29, 2006 8:09 am
Location: Red Gate - Cambridge

Return to SQL Monitor Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests