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.

Performance Troubleshooting with Windows Resource Monitor

Windows Resource Monitor can be a very useful tool for initial diagnosis of performance issues. In this two part series we look at how to troubleshoot performance issues using Resource Monitor.

An nHibernate Head Scratcher

An interesting mystery on why some nHibernate performance issues might exist on your systems. Read this piece from SQL Server expert David Poole and look to see if this is a problem you can easily solve in your environment.

SQL Server Index Maintenance Performance Tuning for Large Tables

This article describes a real-world example of performance tuning index maintenance for a large table of approximately 1 billion rows.