Monitoring Server Performance and Activity
SQL Server 2000
There are a variety of tools and techniques that can be used to monitor Microsoft® SQL Server™. Understanding how to monitor SQL Server can help you:
- Determine whether performance improvements can be made.
- Determine user activity to find out what queries users are issuing and who is connecting to SQL Server.
- Troubleshoot problems.
- Test applications.