The Multifunctioning DBA

Oct 27 2011   1:18PM GMT

SQL Monitoring with Ignite

Colin Smith Colin Smith Profile: Colin Smith

Over the past few weeks, we have been using the Ignite Monitoring Tool to monitor some of our SQL Server instances and we have been pleased with our findings. This tool gives us the ability to look and see what is currently going on with the SQL Server instance and respond quickly to any issues that we may be having. Not only can we more quickly respond to current issues, but this tool also gives us the ability to look into the past and do troubleshooting on issues that may have occurred when no one was looking.

Some of the things that this tool brings us that we find useful are:

  • Historical tracking of SQL Statements that were executed against a database.
  • Tracking of the waits that occurred while the SQL Statements were executing and the ability to tie those waits directly to the SQL that caused them.
  • Blocking monitoring and historical tracking.
  • Plan capturing and comparing.
  • The ability to tie a SQL event or events to resource bottlenecks.
  • The ability to send the report that we see via email to application teams so they can see where they may have opportunity to tune queries.
  • This tool centralizes the ability to do many things that we currently either do not have the ability to do at all or we have to use multiple tools to do all that this one tool does.
  • The ability to set up custom alerts on almost any condition that we would like to be notified on.
  • The user Interface that is designed to quickly lead you to the most problematic queries.
  • The < 1% load that monitoring brings to the instance.
    and we have not even really started on the Oracle side yet but for SQL Server I really like it. I think Confio has done a really good job keeping this product light on the production databases and they are holding a good history of events and the retention and rollup of those events are all configurable so your datastore of this data can be what you want it to be.

    Hope this helps.

 Comment on this Post

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 other members comment.

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:

Share this item with your network: