Monitoring Server Performance and Activity

There are a variety of tools and techniques that can be used to monitor Microsoft® SQL Server™ 2000. The general reasons for monitoring SQL Server are:

• Determining if performance improvements can be made.
  
  
• Determining user activity to find out what queries users are issuing and who is connecting to SQL Server.
  
  
• Troubleshooting problems.
  
  
• Testing applications.