Red Gate forums :: View topic - What should the autogrowth size be for the RedGateMonitor DB
Return to www.red-gate.com RSS Feed Available

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

What should the autogrowth size be for the RedGateMonitor DB

Search in SQL Monitor 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
lnielsen



Joined: 21 Jan 2013
Posts: 1

PostPosted: Mon Jan 21, 2013 2:25 pm    Post subject: What should the autogrowth size be for the RedGateMonitor DB Reply with quote

I've got RedGate set to monitor 3 DBs and the actual RedGateMonitor database size right now is around 8GB and the log is around 1.5GB. This is will a full backup setup nightly.

Currently the RedGateMonitor DB has 24MB free space and the autogrowth is set for 5% and the log at 10%.

Now, I've only been running this thing since 1/3/2013 (17 days) so I have two main questions.

1) What should the autogrowth be set at for the RedGateMonitor database/log file

2) Does this size seem excessing? Any recommendations.

I'm just using the out of the box alerts with SMTP setup. One thing I have noticed is the tool is SLOW. It's the only thing running and has 6GB memory all to itself. Sad
Back to top
View user's profile Send private message
stanori



Joined: 23 Apr 2012
Posts: 72

PostPosted: Tue Jan 22, 2013 11:32 pm    Post subject: Reply with quote

Hi lnielsen,

Thanks for your post. In regards to your question about the autogrowth settings, this is really dependant upon the amount of data that is being retained and collected by SQL Monitor. The more servers, databases, amount of DB activity, etc all are factors in the amount of data that is going to be collected. Since you are running out of space, it should be increased accordingly. The 8GB for the current size does not seem excessive for an active DB server that is being monitored and if there are multiple servers being monitored.

You can also help reduce the amount of data retained by adjusting the data purging settings. Reducing the amount of data that is retained will also bring down the size of the repository. To get to the purge settings:

Configuration -> Data Management -> Data Purging

Once the settings are adjusted and save, it will take a few hours for the effect of the size to show up in DB size. Regarding the performance of the tool, it is very dependant upon the amount of resources that are available on the machine in which the SQL Monitor is installed such as CPU and RAM.

Hope this helps.

Best Regards,
Steve Tanori
_________________
_________________
Steve Tanori
Product Support
Red Gate Software Ltd.
866-997-0378
Back to top
View user's profile Send private message
sql-lover



Joined: 12 Feb 2013
Posts: 17

PostPosted: Wed Apr 24, 2013 7:06 pm    Post subject: Re: What should the autogrowth size be for the RedGateMonitor DB Reply with quote

lnielsen wrote:
I've got RedGate set to monitor 3 DBs and the actual RedGateMonitor database size right now is around 8GB and the log is around 1.5GB. This is will a full backup setup nightly.

Currently the RedGateMonitor DB has 24MB free space and the autogrowth is set for 5% and the log at 10%.

Now, I've only been running this thing since 1/3/2013 (17 days) so I have two main questions.

1) What should the autogrowth be set at for the RedGateMonitor database/log file

2) Does this size seem excessing? Any recommendations.

I'm just using the out of the box alerts with SMTP setup. One thing I have noticed is the tool is SLOW. It's the only thing running and has 6GB memory all to itself. Sad


Never set auto-growth on any database to a percentage, use MB and fix values instead. It creates fragmentation and makes the queries slow!

I suggest to keep an eye for a week or so, and put a fix MB value. I usually leave 20% available free space, above whatever it needs, so it will have space to growth without increasing the actual file, avoiding fragmentation.

How much should be? Like the RedGate engineering said, difficult to say. Just keep an eye on it.
Back to top
View user's profile Send private message
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