Learn more about SQL Server tools



solving sql server problems for millions of dbas and developers since 2006 join MSSQLTips for free SQL Server tips













































   Got a SQL tip?
            We want to know!

SQL Server Performance Monitoring Tools

MSSQLTips author Jeremy Kadlec By:   |   Read Comments (16)   |   Related Tips: More > Performance Tuning
Problem

Being able to identify SQL Server performance issues at the drop of a hat is easier said than done.  Without a means to collect and analyze the performance data it is difficult at best to understand and correct the items in a timely manner. SQL Server ships with a handful of tools to include Profiler, Sysmon\Perfmon and the Database Engine Tuning Advisor\Index Tuning Wizard.  Much of the time these tools meet the needs for manual collection and analysis, but what if you need to go beyond the tools that are available and to resolve a performance issue quickly?

Solution

A handful of vendors have built SQL Server performance products that can be quickly deployed to collect performance metrics to focus resources on the most resource intensive portions of SQL Server.  These products include:

ID Product Monitoring Tuning SQL Server Windows Network Reporting Alerting Advice
1 ApexSQL Monitor *   * * *   *  
2 Confio Ignite * * * * * * * *
3 Embarcadero DB Performance Center XE *   *     *   *
4 Heroix Longitude *   * * * * *  
5 Idera's SQL diagnostic manager * * * *   * * *
6 Lepide SQL Storage Manager * * *     * * *
7 Microsoft's System Monitor *   * * *   *  
8 Microsoft's SQL Server Profiler *   *          
9 Microsoft's SQL Server Database Engine Tuning Advisor   * *     *   *
10 Pearl Knowledge Solution's SQL Centric *   * * * * *  
11 Precise i3 for SQL Server * * * * * * * *
12 Quest Products for SQL Server * * *     * * *
13 Red-Gate SQL Monitor * * *     * * *
14 SQL Power Tools *  * *  *  * *  * *
15 SQL Sentry Performance Advisor * * * * * * *  
16 TNT Software's ELM Performance Manager *   * *   *    

 

Check out the complete listing of SQL Server tools.

Next Steps
  • If you do not have performance problems you are in the minority.  When they occur from adding more users or applications to your SQL Server, turn to these products as a means to improve the overall ROI on your platform.
  • Most of these products have a trial version for 15 to 30 days.  Check out the trial versions to see if they will meet your needs so you can focus on building and supporting your business applications.
  • These products are built by organization's who solely focus on performance issues.  As such, these products can save you a great deal of time as opposed to building an internal solution and not being confident of the results.
  • If you use another tool or work for a company that builds a performance monitoring or tuning tool for SQL Server please send an email to tips@mssqltips.com so we can add it to the list.


Last Update: 12/20/2012


About the author
MSSQLTips author Jeremy Kadlec
Jeremy Kadlec is the CTO @ Edgewood Solutions, co-founder of MSSQLTips.com, Baltimore SSUG co-leader and SQL Server MVP since 2009.

View all my tips
Related Resources


print tip Print  
Become a paid author





join MSSQLTips for free SQL Server tips     



Learn more about SQL Server tools
Comments and Feedback:
Friday, July 24, 2009 - 5:16:03 AM - Dr DBA Read The Tip

Nice list of vendors. SQL server monitoring tools have come a long way over the years and I believe every shop should have some. I would like to point out the there is an error on your matrix. The Quest SQL server (Spotlight is it's name) does monitor/alert/advice on  Windows OS and networking. I have been using this product for 10 years now and have also evaluated most of the other products. It seems that time and time again it works the best and no I do not work and/or get kick backs from Quest. Every DBA / Developer I have shown this product to purchase it. It just works that well. 

There is a enterprise version that will colllect information/stats from all your SQL servers (including Windows and network stats) and stores them into a centralized database. From that you can use and/or create customized reports it get everything you ever wanted to know. We have used this product to help determine which SQL servers would best operate in a consolidated server, meaning a server with several instances of SQL server installed.

 To all the readers, take my advice and get some tools. It really make life a lot easier.

 Thanks,

DR DBA

 


Monday, September 10, 2012 - 7:08:30 PM - Jason Read The Tip

You're missing an important player: Confio's Ignite.  I've been really impressed with the full featured trial version so far:

 

http://www.confio.com/performance/sql-server/ignite/


Tuesday, September 11, 2012 - 5:54:37 PM - Jeremy Kadlec Read The Tip

Jason,

Agreed.  I need to update this tip with all of the product changes from the last few years.

Thank you,
Jeremy Kadlec


Thursday, December 20, 2012 - 1:13:35 PM - Jeremy Kadlec Read The Tip

Everyone,

I posted a few quick updates to this tip today.  I plan on additional updates in the future.

Thank you,
Jeremy Kadlec
Community Co-Leader


Monday, December 24, 2012 - 5:49:10 AM - William Read The Tip

Very nice comparision of SQL monitoring tools ...really appreciable

I think some important tools are miising in the comaprision listingas mentioned jason

Lepide SQL Storage Manager is one of them which is the most cost effective solution is this category

 

http://www.lepide.com/sql-storage-manager/

 

 

 


Thursday, December 27, 2012 - 2:52:46 PM - Jeremy Kadlec Read The Tip

William,

Thank you for the post.  I have updated the tip to include Lepide's tool.

Thank you,
Jeremy Kadlec
Community Co-Leader


Monday, June 03, 2013 - 4:17:45 AM - Philipp Read The Tip

Hi Jeremy,

Very interesting posting indeed. FYI Found recently that in addition to i3 Precise released a new tool called SQLYzer which is very easy to install and provide nice monitoring/tuning feature. I liked the trial version and I'm currently trying to persuad my boss to buy licenses.

Cheers

Philipp


Monday, June 03, 2013 - 6:27:19 PM - Nicole Garris Read The Tip

Did you consider Microsoft's Management Data Warehouse? Seems to me that it is a partial solution in that it collects performance information to a database, and also includes reports. I'm thinking of using it (once I can get it working!) and would really like your opinion on it.


Friday, June 07, 2013 - 6:34:49 AM - William Read The Tip

Hi jereny 

Thanks for your reply and Adding the Lepide SQL Storage Manager  in your splendid comparision of SQL server Monioring tool 

Your Comparision definitely helping in different community and resolving the doubts of many DBAs 

I have personally refering your article in some places 

Thanks 

William 


Wednesday, September 25, 2013 - 10:21:49 AM - Praveen Read The Tip

Hi Jeremy,

A very useful comparison sheet.

Also, FYI

SolarWinds Server and Application Monitor (SAM) now delivers comprehensive SQL database server monitoring in a simple, intuitive, easy to use manner that would aid anyone, from novice systems administrators to veteran DBAs alike, identify both common and complex SQL issues in their environment. 

Also, you can visit the link given below to see the features available in AppInsight:

http://thwack.solarwinds.com/community/solarwinds-community/product-blog/blog/2013/05/29/server-application-monitor-60-beta-3--introducing-appinsight-for-sql

 

Thanks 

Praveen. 


Tuesday, October 29, 2013 - 4:44:35 AM - Sql DBA Read The Tip

This is a very useful  information.

can you get the cost comparison between these tools.


Friday, April 25, 2014 - 4:14:04 AM - IvoYordanov Read The Tip

Hello

I've been using pandora to monitor my sql server instance and it may come in handy to you guys. I'm a starter on pandora but it seems very useful you can find more information on it in the following webpage: http://pandorafms.com/Producto/what-is-pandorafms/en

Regards

Ivo


Tuesday, April 29, 2014 - 2:47:45 AM - Joe Shestak Read The Tip

Very nice comparision of SQL monitoring tools,

I want to add one more SQL monitoring tools in thi list. I want to suggest you "MindArray IPM". MindArray IPM is a unified, easy-to-use, all-in-one performance management software that provides detailed SQL server database health and helps in troubleshooting slow queries by drilling down to SQL level performance details.


Monday, August 11, 2014 - 9:57:58 PM - al Read The Tip

Jeremy,

My company wrote a tool that is entirely SQL Server focussed as opposed to enterprise monitoring that happens to include sql server. It is also at a price point I think a lot of people will be interested in - please add it to your list if you think it is relevant.

www.minidba.com

Thanks


Tuesday, August 12, 2014 - 1:10:07 PM - Jeremy Kadlec Read The Tip

Al,

Congrats on your product and thank you for the post.

Let me get this tip updated with many of the new products.

Thank you,
Jeremy Kadlec
Community Co-Leader


Tuesday, August 26, 2014 - 9:22:18 AM - Francis Read The Tip

You missed a free app: "SQLRanger". It can be found at www.sqlranger.com. It doesn't have all of the functionality of the paid apps, but it does everything I need for free. Can't beat that!



Post a Comment or Question

Keep it clean and stay on the subject or we may delete your comment.
Your email address is not published. Required fields are marked with an asterisk (*)

*Name   *Email Notify for updates



Comments
Get free SQL tips:

*Enter Code refresh code


 
Sponsor Information







Copyright (c) 2006-2014 Edgewood Solutions, LLC All rights reserved
privacy | disclaimer | copyright | advertise | about
authors | contribute | feedback | giveaways | free t-shirt | user groups | community | events | first timer?
Some names and products listed are the registered trademarks of their respective owners.