SQL SERVER 2005 Performance Monitoring

585 pts.
Tags:
SQL Server 2005
SQL Server performance
Hello, is there a free software tool to monitor sql server 2005 similar to Quest FogLight? Quest FogLight is just too expensive for my budget. I am an independent consultant and I want to be able to monitor my client’s sql server.

Software/Hardware used:
SQL SERVER

Answer Wiki

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

Depends on what “similar” means to you. Performance Monitor comes with the OS and likely can be setup to do most everything you want with a bit of work. You can use the Alerts functionality to perform actions based upon defined thresholds.

As a step up from this, you can use Power Shell to pull WMI counters which will include not only perfmon but a lot of other items. This will require some programming.

Discuss This Question: 4  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
  • Colin Smith
    Check out what Brent Ozar says. Great information on how to get what you need. http://www.brentozar.com/sql-server-performance-tuning/data-mining-perfmon-profiler-data/
    885 pointsBadges:
    report
  • Rick Martinez
    [...] SQL Server 2005 Performance monitoring [...]
    0 pointsBadges:
    report
  • Rick Martinez
    [...] SQL Server 2005 performance monitoring [...]
    0 pointsBadges:
    report
  • Warshita72
    No need to maintain. We can do
    10 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