Post reply

Database Monitoring tool

  • December 30, 2012 at 8:57 pm

    #268151

    Hi,

    Do anyone knows what is the best tool for database monitoring. Basically I need to monitor more than 50 database which include the log size, log space usage, job status, troubleshoot job (if fails), disk usage, mirroring and etc.

    Im using SQL server 2005.

    help me pretty pleaseeeeeeeeeeeeeeeeeeeee 😀

    Thanks in advance!

  • December 30, 2012 at 10:02 pm

    #1572423

    you can think try this Quest : Spot light . its pretty handy. i have used this.

    see http://www.quest.com/spotlight-on-sql-server-enterprise/

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • December 31, 2012 at 9:33 am

    #1572534

    Have a look at this:

    http://www.sqlservercentral.com/Forums/Topic409505-690-1.aspx

  • December 31, 2012 at 10:41 am

    #1572551

    SQL Server Magazine > 2012 SQL Server Pro Editors' Best and Community Choice Awards

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • December 31, 2012 at 10:55 am

    #1572556

    Isn't it interesting the nearly inverse relationship between the Editors' picks and those of the community? Actually, Spotlight didn't even make the community list and the Editors' top pick (Gold) was only Bronze for the community. Interesting.

  • December 31, 2012 at 11:01 am

    #1572557

    I am not saying the SQL Sentry tool is not great because I haven't used it, and their free Execution Plan Explorer is excellent, but I see a lot of SQL Sentry ads in SQLMag. Just saying...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • December 31, 2012 at 11:15 am

    #1572560

    opc.three (12/31/2012)

    I am not saying the SQL Sentry tool is not great because I haven't used it, and their free Execution Plan Explorer is excellent, but I see a lot of SQL Sentry ads in SQLMag. Just saying...

    I was trying to use some critical thinking skills without saying as much but I'll admit that was my suspicion as well.

  • December 31, 2012 at 12:02 pm

    #1572576

    Scott D. Jacobson (12/31/2012)

    opc.three (12/31/2012)

    I am not saying the SQL Sentry tool is not great because I haven't used it, and their free Execution Plan Explorer is excellent, but I see a lot of SQL Sentry ads in SQLMag. Just saying...

    I was trying to use some critical thinking skills without saying as much but I'll admit that was my suspicion as well.

    I guess I am not capable of being that subtle. Editor Picks are to be viewed and weighed appropriately 😀

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • January 2, 2013 at 4:53 am

    #1572831

    Determining the "best" tool really is a part of determining what your needs are. The different tools out there are all pretty good, but they do things differently and delivery different things. You need to understand what you want out of the software and that will make choosing the best one for you easier.

    Full disclosure, I work for Red Gate software.

    I would split the tool sets into full-featured, enterprise-level monitoring, and small to mid-range monitoring. On the high end, I can't recommend SQL Sentry enough. Great piece of software written and supported by great people. But, it's expensive and if you're in a small shop, it might be massive overkill. For small shops with more limited needs, I recommend you take a look at Red Gate's SQL Monitor[/url]. It's a good piece of software. You can download it and install it for free and check it out for a few days, see if it does what you want.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • January 2, 2013 at 5:10 am

    #1572837

    Depends on the budget i'd say . there are plenty of tools out there but for the list mentioned by the OP I would simply use CMS and write my own queries setup SSRS too if I had the time 😀

    Jayanth Kurup[/url]

  • April 10, 2014 at 3:11 am

    #1704788

    Hi

    I use in my company to monitoring all my systems Pandora FMS. We have 68 mysql databases, 15 oracle databases, and 22 sql server databases and all databases are monitoring for this tool.

    There are several plugins that will automatically extract all the performance information of these databases, and can even obtain the result of some query. http://pandorafms.com/

    Regards

  • April 16, 2014 at 3:07 am

    #1706360

    I very much agree with what Grant has said here.

    I doubt you'd find consensus on the "best" tool to do any kind of monitoring on account of varying needs and budgets of different shops.

    Ask for suggestions by all means, but ultimately you'd have to evaluate each product for your particular needs.

Viewing 12 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply