Summary

Following is a summary of notes for monitoring SQL Server:

  • The System Monitor is an excellent tool for monitoring SQL Server and the Windows NT operating system.

  • Don't let the System Monitor drive you crazy! Instead of trying to track a multitude of counters, track five to eight key performance indicators. Anything over eight or ten different counters makes it difficult to determine what is happening.

  • Following are some useful counters to track:

    • Processor: % Processor Time

    • SQLServer: BufferManager: Cache Hit Ratio

    • PhysicalDisk: % Disk Time

    • SQLServer: General Statistics: User Connections

    • NBT Connections: Bytes Total/sec

  • Use the Current Activity Monitor to track user connections, locks, and process numbers. The Current Activity Monitor can also ...

Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial