Growth rate of data repository

SQL Server performance monitoring and alerting

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

Growth rate of data repository

Postby nkelly » Mon Mar 12, 2012 7: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,
Nicole
nkelly
 
Posts: 1
Joined: Mon Mar 12, 2012 6:48 pm

Postby Chris Spencer » Wed Mar 14, 2012 12:51 pm

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.
http://msdn.microsoft.com/en-us/library/ms189080.aspx

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


Return to SQL Monitor 2

Who is online

Users browsing this forum: No registered users and 0 guests