SqlServer-QA.net

Whenever you perform a database creation, add a data or log file to database, AUTOGROW process is intiated or restore of database will trigger the file initialization if that is created afresh.   In addition to this when you talk about files intialization you must consider the hardware such as RAID, as the software data block ...

It is a good practice to determine the required capacity for a database application before it is deployed on the Production environment. As it speaks the I/O system is ''most'' important to the performance of SQL Server, in the event of any performance loss or even configuring a new server for SQL Server you would need to assess the disk ...