SQL Server Performance Management

There's a nice pdf on the Embarcadero site on SQL Server Performance Management with the Embarcadero Space Analyst, but there is plenty of information to monitor your own counters. Covers ratio-based analysis, how to spot bottlenecks and I/O problems, session resource consumption, etc.