After installing SQL Server, its important to give the service account permissions to "Perform Volume Maintenance Tasks". This allows databases to grow with zero initialization. It doesn't work on log files, but it can shave minutes or even hours off of database expansion tasks!
To do so, open the local group policy editor on the server and navigate to Computer Configuration -->Windows Settings -->Security Settings-->Local Policies-->User Rights Assignment. Then in the right hand side, double click on "Perform Volume Maintenance Tasks" and add the service account to the list.
Then just restart the MSSQL service
No comments:
Post a Comment