You can now set MaxDOP during SQL 2019 CTP3.0 setup. MaxDOP is the sledge hammer to Cost Threshold’s tack hammer (also MaxDOP database scoped configuration […]
Category: Performance
Verify Allocation Unit Size for SQL Server
Why Do I Care? Everything in SQL Server is stored on disk in 8K pages. The Microsoft recommended best practice is to format using a […]
Implementing Buffer Pool Extension
Buffer Pool Extension was released in SQL 2014 so it’s not new. It is also not advertised very much, but that’s not for lack of […]
Query Store Questions From The Field
I have had several Query Store questions come in from customers lately. Some of the questions stemmed from things read on the internet so this […]
Trace Flag 1117 Growth and Contention
In this video I talk about Trace Flag 1117 and how it was designed to help keep data file growth with multiple data files in […]
8 Hours of Free Performance Training
How could you possibly argue with getting 8 straight hours of SQL Server Performance training for FREE? You can’t! Go check out the annual Performance […]
Local TempDB on SQL 2012
This post has been sitting in the draft folder for way too long, March of last year to be precise. Â So although this is no […]
Reinstall SQL Server Performance Counters
I’ve had several instances over the last few months where I had to reinstall the SQL Server Performance Counters. Â It sounds odd to have them […]
You must be logged in to post a comment.