The selections under "Automatically Grow File" definitely matter and
still have an effect. These settings tell the system how much to
increase the size of your database every time it needs to create more
space. In other words, say you set the Automatically grow file to 10MB;
this means that every time one of these files or file sets is at
capacity, SQL will automatically increase the file by 10 megs. If you
have the database set to "Unrestricted file growth" then the file will
grow in 10 meg increments indefinitely (or until you run out of drive
space).
Note that if you leave these settings too low (eg, 1 meg, 10%, etc) for
a system that has a high WRITE transaction rate (so that the file sizes
are increasing frequently) you will eventually experience system
performance issues due to fragmentation of the files.
Hope this helps.
Chris
-----Original Message-----
From: Mark Fleming
[mailto:mssqldba-ezmlmshield-x68719173.[Email address protected]
Sent: Thursday, April 28, 2005 7:51 AM
To: LazyDBA Discussion
Subject: Data & Log File Sizes in SQL Server 2000
Data Divas,
In Enterprise Manager the database properties dialogue has tabs for Data
Files and Transaction Log. Both of these show the same File Properties
options and allow 'Automatically Grow File'. Assume this is ticked and
on the right the 'Unrestricted file growth' button is selected in
'Maximum file size' so the 'Restrict file growth' figure is greyed out.
On the left does the figure (in MB or %) for 'File growth', which is not
greyed out, still have any effect? If so, what?
Thanks
Mark J. Fleming
_COMPANY CONFIDENTIAL UNLESS STATED OTHERWISE.
Any opinions expressed in this message are those of the sender only and
do not necessarily represent the views or opinions of THE PROMISE
SOLUTIONS GROUP or any associated companies. Registered Office: Promise
Solutions Ltd Promise House, Stafford Road, Wolverhampton, West Midlands
WV10 6AD.
Company Registration Number: 04822774
The information contained in this message and any attachments is
intended solely for the use of the individual or entity to whom it is
addressed. It may contain privileged and confidential information and
exempt from disclosure under applicable law. If you are not the intended
recipient you must not disclose, copy, distribute, retain or take action
reliant on any part of it. If you have received the e-mail in error
please notify immediately to [Email address protected]
Whilst we have checked this e-mail and any attachments for viruses, we
do not warrant that they are virus-free. You therefore take full
responsibility for virus checking.
Promise Finance Limited is authorised and regulated by the Financial
Services Authority in respect of mortgage and general insurance
activities only.
This e-mail has been scanned for all viruses by Star. The service is
powered by MessageLabs.
______________________________________________________________________
________________________________________________________________________
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Website :
http://www.LazyDBA.com To unsubscribe:
http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]
MS Sql Server LazyDBA home page