Monitoring Server Performance and Activity

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.