Database monitoring soft ware

  • Ilooking for a soft ware where I can be able to monitor all the traffic and users in my system

  • Do a search. There are probably hundreds of them. Here are a list of companies & products:

    Microsoft System Center Operations Manager

    Cognos Ignite

    Red-Gate SQL Alert

    Idera Diagnostic Manager

    Quest Fogloght

    SQL Sentry

    There are lots more. Do a google search to see others. My company uses Microsoft's SCOM & Idera's DM. I personally like Cognos Ignite. It really depends on what you really want to monitor, how you want to respond to the issues, and how much money you're ready to spend.

    "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

  • Grant Fritchey (6/3/2010)I personally like Cognos Ignite.

    You mean Confio Ignite[/url]? Right?

  • Nils Gustav Stråbø (6/3/2010)


    Grant Fritchey (6/3/2010)I personally like Cognos Ignite.

    You mean Confio Ignite[/url]? Right?

    Oops!

    Yeah, Confio. Sorry about that. There's been lots of Cognos discussions around here recently and I clearly have them on the brain.

    "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

  • Try SQL Stripes. It's very robust and provides easy multiple-servers monitoring.

    [font="Arial"]www.sqlstripes.com

    [/font]

  • I'd prefer Idera's SQL Diagnostic Manager. Thats really a wonderful tool.

    You can even go with Redgate's SQL Monitor. Redgate tools are also excellent and are much cheaper than Idera's.

    Thank You,

    Best Regards,

    SQLBuddy

  • sqlbuddy123 (1/5/2011)


    I'd prefer Idera's SQL Diagnostic Manager. Thats really a wonderful tool.

    You can even go with Redgate's SQL Monitor. Redgate tools are also excellent and are much cheaper than Idera's.

    Thank You,

    Best Regards,

    SQLBuddy

    True, since this post, which is six months old, Red Gate has released SQL Monitor. It's head and shoulders better than the old SQL Alert.

    "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

  • I tried the live demo of SQL Monitor which is actually monitoring the servers that runs SQLServerCentral.

    http://monitor.red-gate.com/overviews/cluster/254914-ntclus.lon.intensive.int/sql/ins1/db/SQLServerCentralReally? Autogrowth set to 1MB? 😉

Viewing 8 posts - 1 through 7 (of 7 total)

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