Comments
Sort by recent activity
Sorry for my late reply.
I wanted to confirm I used UNC path. And appreciate the answer and follow up. Hope my thread helps someone in the future.
Thanks again! / comments
Sorry for my late reply.
I wanted to confirm I used UNC path. And appreciate the answer and follow up. Hope my thread helps someone in the future.
Thanks again!
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. [image]
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. / comments
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.
C...