Member-only story
Get the most out of your SQL Server on-prem instance with this checklist of configuration settings.
Microsoft SQL Server is an OLTP relational database that can be used with many different applications and under many different types of workloads. SQL Server performance is often measured on the front end by user’s perceptions of how quickly the application can open, save, and run reports. In cases of low-volume and low data amounts, the default settings work just fine, but in larger environments with high demands, a few changes to SQL Server’s processing logic can make a big difference. Ensuring that SQL Server is wisely using all its resources requires tweaking some configurations from the default settings given to it by Microsoft.
For this example, I am using SQL Server 2022 running on a Linux Container (MS Learn quickstart) on a pre-M1 Macbook Air.
NOTE: Thank you to Glen Berry at https://glennsqlperformance.com/resources/. Many of these queries are copied directly from the SQL Server 2022 Diagnostic Queries. I highly recommend going through all of the queries and his other content.
Purpose of this article
If you are a DBA already, most likely this checklist is a part of your daily routine and you have it memorized in greater detail. I am writing this article at a…
