SQL Server Setup Best Practices

STAY IN TOUCH

Get New posts delivered straight to your inbox

  • Guy Glantser

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.

JOIN OUR MAILING LIST

CONTACT US

 3 Rapaport St. Kfar Saba, Israel

 +972-9-7400101

  • Google+ - White Circle
  • Facebook - White Circle
  • Twitter - White Circle
  • LinkedIn - White Circle