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 ...
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.
