The following counters are monitored in this video:
Memory
Available Bytes
Available MBytes
Page Faults/sec
Pages/sec
PhysicalDisk
% Disk Time
Avg. Disk sec/Read
Avg. Disk sec/Write
Current Disk Queue Length
Disk Bytes/sec
Disk Transfers/sec
Processor
% Privileged Time
% Processor Time
SQLServer:Access Methods
FreeSpace Scans/sec
Full Scans/sec
SQLServer:Buffer Manager
Buffer cache hit ration
Checkpoint pages/sec
Free pages
Lazy writes/sec
Page life expectancy
SQLServer:General Statistics
User Connections
SQLServer:Latches
Total Latch Wait Time (ms)
SQLServer:Locks
Lock Timeouts/sec
Lock Wait Time (ms)
Number of Deadlocks/sec
SQLServer:Memory Manager
Memory Grants Pending
Target Server Memory (KB)
Total Server Memory (KB)
SQLServer:SQL Statistics
Batch Requests/sec
SQL Compilations/sec
SQL Re-Compilations/sec
System
Context Switches/sec
Processor Queue Length