Capture server hardware facts from SQL Server views, keep an inventory, and distinguish visible resources from workload sizing evidence.
SQL SERVER – How to Fix High CPU Consumption on SQL Server 2017 and 2016
After a big upgrade, a client’s SQL Server showed high CPU Consumption, and they called me in twice. Here is what we found and the simple fix.
[Exclusive] Practical Real World Performance Tuning – Live Training Session for Limited Time
Brent Ozar and I launched Practical Real World Performance Tuning, a demo-driven live course built on handy scripts. Registration is open for a limited time.
Automatic Plan Correction: Reading SQL Server’s Tuning Advice
Read automatic plan correction advice, compare regressed and recommended plans, and verify that forcing the last good plan held.
SQL SERVER – Improve Index Rebuild Performance by Enabling Sort In TempDB
A client’s index rebuild was taking forever. We improved their index rebuild performance by enabling sort in TempDB, and here is how it works.
SQL SERVER – Identity Jumping 1000 – IDENTITY_CACHE
Has your identity column ever jumped by 1000 after a restart? SQL Server 2017 fixes it with IDENTITY_CACHE. Here is a demo with the setting ON and OFF.
SQL SERVER – Performance Observation of TRIM Function
Does the new TRIM function slow your queries like other functions in a WHERE clause do? Here is my performance observation of TRIM function in SQL Server 2017.