© Benjamin Nevarez 2016

Benjamin Nevarez, High Performance SQL Server, 10.1007/978-1-4842-2271-3_4

4. SQL Server Configuration

Benjamin Nevarez

(1)Santa Clarita, California, 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: The Go Faster Book 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.