Learn more about SQL Server tools


Latest SQL Server Tips

Free SQL Server Learning

SQL Server Performance Monitoring in the Cloud

Monitor and Troubleshoot SQL Server Performance

5 ways monitoring SQL Server Agent Jobs can make your job easier

Deploying Applications in Azure without Configuration Limitations

SQL Server Performance Monitoring Tools

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

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?


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 ManageEngine SQLDBManager Plus * * *     * * *
8 Microsoft's System Monitor *   * * *   *  
9 Microsoft's SQL Server Profiler *   *          
10 Microsoft's SQL Server Database Engine Tuning Advisor   * *     *   *
11 Pearl Knowledge Solution's SQL Centric *   * * * * *  
12 Precise i3 for SQL Server * * * * * * * *
13 Quest Products for SQL Server * * *     * * *
14 Red-Gate SQL Monitor * * *     * * *
15 SQL Power Tools *  * *  *  * *  * *
16 SQLRanger *   *          
17 SQL Sentry Performance Advisor * * * * * * *
18 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/22/2014

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
Post a comment or let the author know this tip helped you.

       All comments are reviewed, so stay on subject or we may delete your comment.

*Name   *Email Notify for updates

       Note: your email address is not published. Required fields are marked with an asterisk (*)

Get free SQL tips:

*Enter Code refresh code     

Wednesday, March 18, 2015 - 12:49:14 PM - George Zhou Read The Tip

Very nice article, thank you Jeremy, we have 200+ SQL instances, we are planning to purchase SQL server monitor tools for half of them, considering the price and tool quality, I tested 3 tools so far, Spotlight, SQLDM, SQL sentry, I like the SQLDM interface, easy to find many useful info, however, seems like it has more watcher overhead, Spotlight covers SSAS but has some issues with reuse the log of the playback database, just started to try SQL sentry, seems hard to find info, not licenses are seperate on many parts regarding SQL monitoring, I would appreciate any one sharing from end user's experience.

Tuesday, January 06, 2015 - 11:30:42 AM - UnoT Read The Tip

An excellent free tool is SQL Performance Monitor.  It has a great UI and give a very wide spectrum of information.

This definitely competes with functionality with even the paid apps.

You can get it here:




Monday, October 27, 2014 - 9:04:27 AM - marykaichini Read The Tip

I think I can add one more product where SQL monitoring is one part of the whole monitoring options - Anturis, a cloud-based all in one monitoring with various alerts and troubleshooting.

Wednesday, October 22, 2014 - 7:52:48 AM - Colin Allen Read The Tip

MDW does a good job, PAL deserves a mention, Activity Monitor seems seldom used, Brent Ozars Blitz scripts & askbrent, performance dashboard, Adams SP_WhoIsActive, plus several SQL Monitoring tools on codeplex including SQL Live Monitor which I quite like.

You will have noticed all of the above are free, I like a lot of the paid for tools but as a contractor free is normally the only option.

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!

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


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

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


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.



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.

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


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



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.

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:





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 



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.

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.



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


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

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






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


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

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


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

Thank you,
Jeremy Kadlec

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:



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.




Sponsor Information