Performance Monitoring with Dynamic Management Views

In this article, Ron Johnson shows how you can use DMVs for proactive real-time SQL Server performance monitoring.

A Performance Troubleshooting Methodology for SQL Server

When healing a sick SQL Server, you must forget the idea that there could ever be a simple correspondence between symptom and disease: The art of troubleshooting is much more the art of discovering, and assembling, the various pieces of the puzzle so that you have a complete understanding of what is going on inside of a server.

Speeding up database access - part 4 Fixing expensive queries

Part 4 of a series from Matt Perdeck on speeding up your database access. This is a great series for developers. This is based on the book ASP.NET Site Performance Secrets.

System Monitor (Perfmon) Counters for SQL Server 2005

Capturing performance monitor counters is of great value to understand how SQL Server is behaving at a macro level, that being how overall resources are being used within the engine. Without this data it is difficult to determine where the performance issues are occurring. Capturing the metrics has been traditionally from Performance Monitor either on an ad-hoc basis or setting up a log to capture the values on a predefined basis.

Speeding up database access Part 2 - Pinpointing Other Bottlenecks

Part 2 of a series from Matt Perdeck on speeding up your database access. This is a great series for developers. This is based on the book ASP.NET Site Performance Secrets.

Email Long Running SPID Info

This script will email info about the longest running SPID in an HTML formatted table

Plans

Top 10 SQL Server Counters for Monitoring SQL Server Performance

Greg Larsen lists his top 10 SQL Server counters for maintaining database performance.

Performance Counters

Performance Troubleshooting with Windows Resource Monitor - Part 2

In the second part of the Resource Monitor series we conclude with a look using the Memory tab and Disk tab to diagnose performance issues.