question

Cyborg avatar image
Cyborg asked

SQL Server Monitoring tools

which one is the best monitoring tool for SQL Server? (My Concerns are Performance monitoring, Reporting, Advice,Alert,Tuning)
servermonitoringtoolsclient-tools
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

DaniSQL avatar image
DaniSQL answered
This has been discussed many times here. Check out this similar questions, it might help you: [3rd Party SQL Server management tools][1] [RED GATE TOOLS must have for a DBA??][2] [What are some good tools to know for a new SQL admin..??][3] [What tools do you use to increase efficiency and productivity for SQL Development][4] ---------- EDIT: BTW i use Idera Diagnostic Manager at work to monitor production databases and I am satisfied with it and I have been testing Confio's Ignite for the last 3 weeks and I am impressed. [1]: http://ask.sqlservercentral.com/questions/7480/3rd-party-sql-server-management-tools [2]: http://ask.sqlservercentral.com/questions/5975/red-gate-tools-must-have-for-a-dba [3]: http://ask.sqlservercentral.com/questions/15302/what-are-some-good-tools-to-know-for-a-new-sql-admin [4]: http://ask.sqlservercentral.com/questions/4738/what-tools-do-you-use-to-increase-efficiency-and-productivity-for-sql-development
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

WilliamD avatar image
WilliamD answered
I think this is a question of taste more than functions that are offered, as most tools are pretty similar. I use [SQL Sentry][1], and [Confio Ignite][2], but there are lots of them on the market (Redgate, Quest & Idera to name a few more). Each company offers trial software or free versions (with less functionality or a time limit) so you can try them out. I suggest doing just that and comparing the tools to see which suits your needs best. [1]: http://www.sqlsentry.net [2]: http://www.confio.com/English/Products/Ignite_for_SQL_Server.php
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Fatherjack avatar image
Fatherjack answered

I use SQL Monitor from RedGate as it comes as part of a package I have but it can be bought on it own. I also use Confio Ignite Free, because its free and I cant afford to buy any other products! I like to see them both highlight the same issues so I am sure I'm not chasing smoke.

RedGate are busy building the next version of SQL Monitor which is very different from the previous version. You can get a free trial of both from their site although SQL Response v2 is currently a Beta version.

Disclosure: I am a Friend of RedGate so am involved early on in their product development on some tools. I have been testing and trialling SQL Monitor v2 for several months and would have a bias towards using that.

4 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ThomasRushton avatar image ThomasRushton ♦♦ commented ·
Don't you find that the milk and cinnamon gets in the way of all that lovely caffeine? Double espresso for me, please, TYVM.
2 Likes 2 ·
Leo avatar image Leo commented ·
We use SQL Response from RedGate as well. That is not bad but GUI is quite poor if we are compare with other monitoring tools. Idera, etc... That's come with Red Gate Backup tools and they didn't update the version for SQL Response for ages. But as you explained, that might be something interesting for next version of SQL Response.
1 Like 1 ·
Fatherjack avatar image Fatherjack ♦♦ commented ·
@leo - it is certainly interesting. A whole world different in the way it presents the alerts and allows you to manage them - grab a free trial of the new version. It runs beside v1 with no problems at all
1 Like 1 ·
Phil Factor avatar image Phil Factor commented ·
Yep, and with the new version of SQL Response, you can monitor your servers on an iPad whilst sipping cappachino in a coffee bar.
1 Like 1 ·
denisrichi avatar image
denisrichi answered
I have tested Lepide SQL Storage Manager and it works fine to me The tool offers various functionalities for database defragmentation, table partitioning, object switching, reorganizing heaps and indexes Take a look [ http://www.sqldatabasemonitoring.com/][1] [1]: http://www.sqldatabasemonitoring.com/
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

PraveenManohar avatar image
PraveenManohar answered
Check out the new Solarwinds Server and Application Monitor(SAM) version 6 which can give highly detailed, insightful SQL Server performance monitoring. [ http://www.solarwinds.com/sql-server-performance.aspx][1] [1]: http://www.solarwinds.com/sql-server-performance.aspx
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

joeshestak avatar image
joeshestak answered
I suggest you to use MindArray IPM's [SQL Server monitoring tools][1]. It is one of the best monitoring tools for SQL server. It analyzes the resources that affect the performance of SQL database. The DBA can view graphical and statistical analysis of SQL server performance with the report of IPM. [1]: http://www.mindarraysystems.com/sql-server-monitoring.php
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.