Joey on SQL Server Why Activity Monitor May Be Hurting Your SQL Server's Performance As Joey explains, Activity Monitor consumes a lot of resources and yields little usable data.

Microsoft's goal for the Query Store was to help DBAs facilitate upgrading to newer releases of SQL Server by providing persistent performance data to could be analyzed over time.

SQL Server also has separate logs for the SQL Server Agent, as well as other components of the data platform, such as SQL Server Analysis Services. In each case, SQL Server keeps seven rolling log ...

Here is a list of common wait types and techniques that every DBA (or wannabe DBA) should know. While there are many more wait types than listed here, understanding these will give you a leg up when ...