Video Screencast Help
New Company Name and Logo Announced. Learn More.

SQL Autogrow Size?

Created: 09 Sep 2012 • Updated: 09 Sep 2012 | 2 comments
KeirL's picture
This issue has been solved. See solution.


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


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

Article:DOC5365  |  Created: 2012-02-17  |  Updated: 2012-03-27  |  Article URL

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

KeirL's picture

Great - thanks Tony

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