© Benjamin Nevarez 2021
B. NevarezHigh Performance SQL Serverhttps://doi.org/10.1007/978-1-4842-6491-1_3

3. SQL Server Configuration

Benjamin Nevarez1  
(1)
Santa Clarita, CA, USA
 

Properly configuring SQL Server is of paramount importance for the performance of your databases and applications. Even when the product has been updated throughout the years to ensure it has the best possible configuration by default, there are still multiple cases, especially for high performance workloads, in which additional configurations and optimizations may be required.

So, how is SQL Server configured? There are several levels and methods of configuring SQL Server. For example, there are some configuration options at the instance, the database, or even at the table ...

Get High Performance SQL Server: Consistent Response for Mission-Critical Applications now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.