This issue has been solved.

SQL Autogrow Size?

Created: 09 Sep 2012 | Updated: 09 Sep 2012
KeirL's picture
KeirL Partner
Login to vote
0 0 Votes

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

Quick Look Solution

Hi ya, You can refer to

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.

Filed Under

Tags:
, ,

Comments

TonySterling's picture
TonySterling
Trusted Advisor
09
Sep
2012
Votes
+1
SOLUTION

Hi ya, You can refer to

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.

Tony Sterling
www.bluesource.net or www.bluesource.co.uk
Offices in the US and the UK

KeirL's picture
KeirL
Partner
09
Sep
2012
Votes
0

Great - thanks Tony I was

Great - thanks Tony

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

Cheers

Keir