Have you ever wondered what DBCC SQLPERF does? Here are three uses: checking log space, resetting wait statistics and resetting latch statistics.
SQL Server – Configuration Manager Console Running Very Slow and Time Out
During a performance health check, a client’s Configuration Manager Console ran very slow and timed out. Here is what we found in SQL Server behind it.
SQL SERVER – Database Scoped Configurations – Query Optimizer Fixes
During recent SQL Server Performance Tuning Practical Workshop I receive following question about Query Optimizer Fixes.
SQL Download – SQL Server Management Studio (SSMS) – Performance Dashboard
The latest SQL Server Management Studio now includes the Performance Dashboard by default. Here is the free SSMS download link and a quick look at it.
Auto-Created Statistics: What the _WA_Sys Names Tell You
Read auto-created statistics through sys.stats and sys.stats_columns, then use their columns as clues for better query tuning.
SQL SERVER – How to Abort Index Rebuilding After Specific Time?
A DBA in my workshop asked how to abort index rebuilding when it runs over 10 minutes on a busy table. On SQL Server 2014 and later, one command does it.
Heimdall Data Auto-Caching for SQL Server – No Changes to Application
Heimdall Data adds auto-caching and auto-invalidation to SQL Server with zero changes to your application or database. Here is how it works.