Installing SQL Server adds SQL Serverspecific performance counters to the Windows 2000 System Monitor (Performance Monitor in Windows NT 4.0). You can use these counters with the standard Win2K or NT performance counters to keep tabs on your system's response to gradual load changes. To establish a baseline, begin system monitoring when the system is running as usual. Seven important performance counters can give you a quick idea of your SQL Server system's overall status.
You must be a paid Professional Member to access this entire article.
Already a Professional Member? Please log in now: