Contributions, Troubleshooting

Instant File Initialization – Performance Improvement

When your database files grow (either manual or automatically), does it take time and lead to performance issues?

The answer is yes! Do you find that the following operations are consuming more time than you thought required?:

  • Creating new databases that are bigger in size
  • Adding files
  • Restoring databases from backup


Instant file initialization help make the operations mentioned above faster. Creating bigger databases initially is always recommended to ensure that there is enough room to support the workload during peak utilizations. It also helps keep pace with the future growth.

Continue Reading…