Monitoring Server Performance and Activity

There are a variety of tools and techniques that can be used to monitor Microsoft® SQL Server™. 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.