Performance tips, security advisories, health check findings, and industry analysis. Practical, technically accurate, no fluff.
When SQL Server slows down, wait statistics reveal exactly where the problem is hiding. Learn how to query DMVs to diagnose performance issues quickly.
Read article →Use SQL Server's plan cache DMVs to surface full table scans, missing indexes, and columns with no statistics without running a trace or waiting for an incident.
Read article →Learn how to use SQL Server's missing index DMVs to identify index gaps that are quietly draining CPU and I/O from your production environment.
Read article →Learn how to grant read-only Activity Monitor access in SQL Server using VIEW SERVER STATE, without handing over sysadmin rights.
Read article →Learn how to apply Microsoft's compatibility update to get the SQL Server 2005 Performance Dashboard working correctly against SQL Server 2008 and 2008 R2 instances.
Read article →Learn how to query SQL Server index fragmentation using DMV views and identify which indexes need rebuilding or reorganising to restore query performance.
Read article →Five field-tested DMV queries that give you immediate visibility into SQL Server performance, from procedure execution frequency to wait statistics and plan cache health.
Read article →When your SQL Server is running hot, knowing which queries are responsible is the first step. This script uses DMVs to surface the top 50 queries by average CPU time.
Read article →Index fragmentation builds silently and drags down SQL Server performance over time. Learn how to check fragmentation levels and identify which indexes are worth acting on.
Read article →Learn how to find your longest running SQL Server queries using sys.dm_exec_query_stats, so you can identify the top resource consumers and fix performance problems fast.
Read article →Performance tips, security advisories, and industry analysis. No fluff, no spam.