Home > IT Answers > SQL Server > Performance and Resource Consuming Monitors SQL Server 2008 R2
ITKE
16,755 pts.
 Performance and Resource Consuming Monitors SQL Server 2008 R2
SQL Server 2008 R2, SQL Server 2008 R2 Performance Monitoring, SQL Server Performance Monitoring
Are there any specific GUI tools available to monitor the performance and resource consuming process? At present we are using third party tool to do so (Spot light)?

Software/Hardware used:
ASKED: May 3, 2010  9:55 PM
UPDATED: January 28, 2011  12:34 AM
RELATED QUESTIONS
Answer Wiki:
Yes. With the new Multi-server management capabilities (enhancements to Management Studio) there is a new Utility Control Point (UCP) where you can enroll and manage multiple instances. The Explorer Dashboard provides overall utilization for the instances and you can drill down to get the specifics (CPU, Storage, etc.)
Last Wiki Answer Submitted:  May 3, 2010  9:55 pm  by  MicrosoftExpert   975 pts.
All Answer Wiki Contributors:  MicrosoftExpert   975 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

But it is no SERIOUS match for the capabilities of Spotlight on SQL Server Enterprise. Graphically and “tell at a glance” it is way beyond anything MS has deigned to offer. I was a VERY happy user of Spotlight for 5 years and found it the best in class, despite it lacking some of the (utterly distracting from the task of seeing a problem area at a glance) eye candy that SQL Sentry offers up. Just my 2-cents…

SSNewbie
 55 pts.