vendredi 2 novembre 2018

Database Instant File Initialization For Microsoft Sql Server Local DB 2016 SP1

My company makes extensive use of Microsoft SQL Server Express Local DB 2016 (SP1) for code testing. I recently read about Database Instant File Initialization, and I believe this would improve the performance of our testing processes.

When I check the logs for the Local DB instance, they indicate that Database Instant File Initialization is disabled. I have made sure that my specific user has "Perform Volume Maintenance Tasks" permissions.

Does anyone know if this feature works in the Local DB version? If so, any thoughts on what I might be doing wrong would be appreciated.

Aucun commentaire:

Enregistrer un commentaire