Performance and Resource Consuming Monitors SQL Server 2008 R2

344955 pts.
Tags:
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)?

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.)

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • ITKE
    [...] Performance and Resource Consuming Monitors SQL Server 2008 R2 was asked by a reader and answered by [...]
    0 pointsBadges:
    report
  • SSNewbie
    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...
    55 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following