Database Setting - File Growth

Hi,
What will happen or what should a database administrator do if the setting
for file growth for a database and log file is not automatic growth?
Monitor free space and before nearing full increase the size of the relevant files (ALTER DATABASE
... MODIFY FILE...).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Alice" <Alice@.discussions.microsoft.com> wrote in message
news:6329BF3B-A9E3-4F8A-989F-717103397012@.microsoft.com...
> Hi,
> What will happen or what should a database administrator do if the setting
> for file growth for a database and log file is not automatic growth?
|||Hello,
Like Tibor mentioned you may need to monitor the MDF and LDF files closely
if the file size is not to set automatic growth.
But my best recommendation is create the MDF and LDF size with required size
and make sure that auto growth not happends as well as
you can make the auto growth option enabled. THis will help you not having
any downtime due to lack of database space...
Thanks
Hari
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23PFEXm1qHHA.3492@.TK2MSFTNGP02.phx.gbl...
> Monitor free space and before nearing full increase the size of the
> relevant files (ALTER DATABASE ... MODIFY FILE...).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Alice" <Alice@.discussions.microsoft.com> wrote in message
> news:6329BF3B-A9E3-4F8A-989F-717103397012@.microsoft.com...
>
|||1) DO NOT EVER let a production database keep the default size and
especially growth increments for either the data OR log file!!! You will
quickly get extremely fragmented os files (for any reasonable amount of data
size) that will significantly affect performance of the database.
2) I advise my clients to estimate their data growth needs for at least 1
year out and set the database/log size appropriate for that to avoid any
growth and also to leave relatively large blocks of empty space so sql
server can lay data down contiguously (esp. during maintenance) - thus
leading to much better disk I/O performance.
3) Set autogrowth on and some reasonable MB or percentage growth factor
depending on size and growth patterns.
TheSQLGuru
President
Indicium Resources, Inc.
"Alice" <Alice@.discussions.microsoft.com> wrote in message
news:6329BF3B-A9E3-4F8A-989F-717103397012@.microsoft.com...
> Hi,
> What will happen or what should a database administrator do if the setting
> for file growth for a database and log file is not automatic growth?