Q
Problem solve Get help with specific problems with your technologies, process and projects.

Proactive monitoring of bad performing queries

We are looking for proactive monitoring of bad performing queries in Oracle/Sybase/DB2/MS SQL Server. Do you know any single tool can support such a requirement? If not, which tool or tools you suggest for proactive monitoring of bad performing queries and providing optimization for those queries?

We are looking for proactive monitoring of bad performing queries in Oracle/Sybase/DB2/MS SQL Server. Do you know any single tool can support such a requirement? If not, which tool or tools you suggest for proactive monitoring of bad performing queries and providing optimization for those queries?
There are a lot of third-party tools that can help find and fix bad SQL statements on one database platform. That number drops to a handful when you're looking for that capability on two database platforms. When you want that capability on several database platforms, you're down to slim pickin's.

At the risk of sounding biased, I'd put forward my own company, Quest Software's Spotlight line of products. Spotlight provides very rich diagnostic information. If you're looking for something more lightweight, then you might consider Zero Impact Monitor from SQL Power Tools. Once you get past these two, there really aren't that many products that are cross-platform that I'm aware of.

This was last published in August 2005

Dig Deeper on Microsoft SQL Server Performance Monitoring and Tuning

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close