SQL Autogrow Size?

[KeirL]

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

[TonySterling · Accepted solution]

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.

[KeirL]

Great - thanks Tony

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

Cheers

Keir