When all queries against a SQL Server instance or a particular database application are slow, the cause is often outside any single query. This article helps database administrators and application ...

As Joey explains, Activity Monitor consumes a lot of resources and yields little usable data. Here are some third-party alternatives. I get to work with a lot of customers, so I get to see a lot of ...

A popular performance tuning book gets updated for SQL Server 2025, how does it fare? Ian Stirk takes and in depth look and finds it pretty good. This well-liked SQL Server book examines performance ...

A popular performance tuning book gets updated for SQL Server 2022, how does it fare? This well-liked SQL Server book examines performance from various angles, but concentrates on improvements related ...

A common task that all database and system administrators face is patching systems. Patching your systems is very important -- first and foremost, security fixes are included in patches. Patches also ...