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.

The SQL Server monitor also provides deeper monitoring ability. Because Enterprise Manager monitors SQL Server by running a query, an administrator isn’t limited to monitoring the SQL Server ...

If you've been managing databases for any length of time, you've probably had to contend with the 'noisy neighbors' scenario. In this scenario, you have several applications, each with their own ...

Experiencing slow performance on a Windows Server is a common issue that can disrupt critical operations. Whether it’s a lag in application response, delayed file access, or high resource usage ...

Once SQL Server is installed and all windows are closed, the CPU usage never drops below 20% in VMM. I was puzzled by this for some time, probably longer than I should have been.

The Resource Governor was the feature DBAs working with large-scale SQL Server environments seemed most excited about when SQL 2008 was first announced. Resource Governor enables DBAs - for the first ...

Scott Lowe provides an overview of disk-related metrics in the Windows Resource Monitor. Find out you can use the tool to troubleshoot CPU performance issues.