Video Screencast Help

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

Article:DOC5365  |  Created: 2012-02-17  |  Updated: 2012-03-27  |  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