September 8, 2003 at 12:59 pm
We have a 90 GB database that is set to autogrow by 10%. We noticed it grew last friday.
1) How do we find out exactly when that happened.
2) Where can we look to see when it's close to growing again so we can manually grow it on the weekend instead of business hours.
Thanks
Darren
Darren
Darren
September 8, 2003 at 1:16 pm
It was the data file that grew.
Darren
Darren
September 8, 2003 at 1:16 pm
Is it the data portion that grows, or the log file?
If it is the log file, index defrags etc hit the log file quite hard.
Steven
September 8, 2003 at 2:17 pm
There are a number of solution for file growth from setting up a sql agent alert to
coding checks.
Take a look at http://www.sqlservercentral.com/scripts/contributions/108.asp
Steven
September 9, 2003 at 5:03 am
You can monitor it, I just typically override the percentage with fixed growth amount for large db's. Users shouldnt notice the time it takes to do a smaller grow and it's worth the convienence in my opinion. Then you just have to keep an eye on free disk space.
Andy
September 9, 2003 at 7:28 am
quote:
We have a 90 GB database that is set to autogrow by 10%. We noticed it grew last friday.1) How do we find out exactly when that happened.
The modified date in file's property may give you the indication.
quote:
I would monitor the free spaces in database and manually increase the data file size.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply