Expand db during non-business hours? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Expand db during non-business hours?

My server has autogrow disabled for couple of dbs to improove performance
Why should i expand database during non-working hours? Is that locking database? HOw about the other database that expanding automatically?
Let’s say autogrow 10% .
How are they affected?
Thank you
If the database is accessed continously from the application performing the ALTER DATABASE will have performance affects and it may not allow new connections depending upon the server resources. SQL Server 2000 files can grow automatically from their originally specified size. When you define a file, you can specify a growth increment. Each time the file fills, it increases its size by the growth increment. If there are multiple files in a filegroup, they do not autogrow until all the files are full. Growth then occurs using a round-robin algorithm. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>