Performance Monitoring and Tuning How-to Topics
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.