SQL Server Setup Best Practices
On May 12, 2020, I had the honor to participate and speak in one of my favorite conferences - GroupBy. I talked about best practices when setting up a new instance of SQL Server - before, during and after the actual installation. It was part of the European performance track.
I covered the following topics:
Choose the Appropriate SQL Server Version & Edition
Plan for Capacity
Install SQL Server on a Dedicated Machine
Plan and Prepare Storage Layout
Install Only the Required Features
Choose the Appropriate Instance Collation
Enable Instant File Initialization
Leave Enough Memory for the Operating System
Adjust Instance Configurations
Add Tempdb Data Files
Enable Global Trace Flags
Manage the SQL Server Error Logs
You can watch the session recording here.
And you can download the session materials here.
See you in the next GroupBy conference on October 27-28, 2020.