Monitoring tools

  • I am looking for SQL performance monitoring tools like SQLPower. Please share your real world experiences in using these tools.

  • Check out Quests "Spotlight On" www.quest.com

  • Antares, is this what you use? This is what our dba uses as well and every once in a while the CPU peaks between 85 and 95% and so the developers get asked the famous question of what changed today from yesterday. Sometimes the dba can pinpoint where the blocking is occurring but a lot of times those procedures haven't been touched in months. We usually just brush it off because everything looks optimal and why change something that has been working for so long and we have already tested every which way to run at its best performance.

    Does anyone have any advice or any other tools that we could look into? The idea of a SQL monitoring tool that uses SQL as it's backend, doesn't really make much sense to me.

  • Actually I won a copy and gave it to another group. I don't use anything to constantly monitor as I have foudn the extra loads unacceptable. I have been testing MS MOM but still leary. Just monitor when an issue occurrs that I need to research and I use Profiler and PerfMon mostly.

  • I've worked with MS perf guys and they mainly use Permon and Profiler as well. I've found these to be the best for spot troubleshooting. At work we use Patrol (BMC) for ongoing monitoring which is useful for looking back at yesterday or last week if you need it.

    Steve Jones

    sjones@sqlservercentral.com

    http://www.sqlservercentral.com/columnists/sjones

    http://www.dkranch.net

  • Check SQL Management Suite from NetIQ (www.netiq.com)

  • Pearl Knowledge Solutions, Inc. recently announced the release of SQLCentric v1.2

    SQLCentric, is a fully functional Web-based MSSQL-Centric Network Database Monitoring & Alert System which is deployed on your company’s corporate intranet.

    SQLCentric is extremely easy to install, deploy, manage and use. No complex configuration

    Minimally invasive to the SQL Servers it monitors, and is a zero-impact solution.

    Integrates seamlessly with your e-mail system to provide auto-alerts and follow-up messaging.

    An intuitive administration module allows the user to manage servers, groups, & email operators, configure run-time parameters and disk alert thresholds.

    Here are just some of the exciting features and enhancements in 1.2:

    Now supports multiple named instances!

    Dynamic Disk Management - monitors all logical disk partitions on a server

    Ping Drill-Down - You can now drill-down for ping connectivity details, and ping any server real-time

    Is Cluster aware for SQL 2000

    To download an Eval Copy of SQLCentric v.1.2, please visit http://www.pearlknows.com

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply