SQL Autogrow Size?
Created: 09 Sep 2012 | Updated: 09 Sep 2012 | 2 comments
This issue has been solved. See solution.
Hi
Is there a recommended setting for the EV Databases autogrow size? The default for SQL2008 is 1MB whcih seems on the low side. Most dba's say 25MB-50MB or 10% as the 'grow' activity can be quite intensive for SQL.
I think the log files are set to 10% but should the databases be set the same?
What are other people doing?
many thanks
K
Discussion Filed Under:
Comments 2 Comments • Jump to latest comment
Hi ya,
You can refer to this:
Symantec Enterprise Vault 10.0: SQL Best Practices Guide
There is a section on page 26 that talks about autogrow.
Tony Sterling
www.bluesource.net or www.bluesource.co.uk
Offices in the US and the UK
Great - thanks Tony
I was looking in the performance and tuning guide and not the best practices guide
Cheers
Keir
Would you like to reply?
Login or Register to post your comment.