Video Screencast Help
Give us your opinion and win with Symantec! Please help us by taking this survey to tell us about your experience with Symantec Connect, so that we can continue to grow and improve.  Take the survey.

SQL Autogrow Size?

Created: 09 Sep 2012 • Updated: 09 Sep 2012 | 2 comments
KeirL's picture
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

Comments 2 CommentsJump to latest comment

TonySterling's picture

Hi ya,

You can refer to this:

Symantec Enterprise Vault 10.0: SQL Best Practices Guide
padding: 1px;padding-bottom: 3px ;font: 12px Arial; text-align: left;color: #666666; background-color:#f2f2f2">Article:DOC5365 padding: 1px;font: 12px Arial; text-align: left;color: #666666;background-color:#f2f2f2;"> |  padding: 0px;font: 12px Arial; text-align: left;color: #666666;background-color:#f2f2f2;">Created: 2012-02-17 padding: 1px;font: 12px Arial; text-align: left;color: #666666;background-color:#f2f2f2"> |  padding: 1px;font: 12px Arial; text-align: left;color: #666666;background-color:#f2f2f2">Updated: 2012-03-27 padding: 1px;font: 12px Arial; text-align: left;color: #666666;background-color:#f2f2f2"> |  padding: 1px;font: 12px Arial; text-align: left;color: #666666;background-color:#f2f2f2">Article URL http://www.symantec.com/docs/DOC5365

There is a section on page 26 that talks about autogrow.

SOLUTION
KeirL's picture

Great - thanks Tony

I was looking in the performance and tuning guide and not the best practices guide  blush

Cheers

Keir