May 18, 2005 03:18 PM

Setting Autogrow Properties

Rating: (0)
SQL Server Magazine
InstantDoc ID #46220

When setting the autogrow properties for a SQL Server data file, is it better to use a fixed size or a percentage growth?

It's hard to say always or never in the performance-tuning world. It's usually better to define the reasons why certain decisions are better in particular situations. Whether you use a fixed size or a percentage for autogrow settings, you'll still have to tweak the values as your file grows. Typically, I'll set the file size to a reasonable starting point, t...

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

NOT A PROFESSIONAL MEMBER? YOU CHOOSE:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Add a Comment

There are no comments to display. Be the first one!
You must log on before posting a comment.

Are you a new visitor? Register Here
GOOGLE LINKS
SPONSORED LINKS
FEATURED LINKS