O'Reilly logo

Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition by Mark Spenik, Orryn Sledge

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Tools for Monitoring SQL Server

The following tools are used to monitor SQL Server:

  • System Monitor

  • SQL Server Enterprise Manager

  • SQL Server Profiler

System Monitor

The System Monitor is a Windows 2000 tool for monitoring SQL Server and the Windows NT operating system (Windows NT 4.0 has a similar tool named Performance Monitor). The advantage of the System Monitor is that it is tightly integrated with the operating system. This enables you to track real-time statistics about SQL Server and Windows NT. Together, these statistics can be used to isolate bottlenecks and track performance.

NOTE

The System Monitor might slightly degrade system performance on older machines. The overhead incurred from the System Monitor has been found to be 5% or less ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required