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:

1. Choose the Appropriate SQL Server Version & Edition

2. Plan for Capacity

3. Install SQL Server on a Dedicated Machine

4. Plan and Prepare Storage Layout

5. Install Only the Required Features

6. Choose the Appropriate Instance Collation

7. Enable Instant File Initialization

8. Leave Enough Memory for the Operating System

9. Adjust Instance Configurations

10. Optimize Parallelism

11. Add Tempdb Data Files

12. Enable Global Trace Flags

13. 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.