Red Gate releases new SQL Monitor 2.0: The future of monitoring is wherever you are

  • Comments posted to this topic are about the item Red Gate releases new SQL Monitor 2.0: The future of monitoring is wherever you are

  • I'd be interested to know (from people who have seen/used both) what the difference is between this and Idera's SQL Diagnostic Manager...

  • how much is it?

  • Hi Alen,

    SQL Monitor is available from $595 per server. More information is available on the Red Gate website:

    http://www.red-gate.com/sqlmonitor

    If you want to try SQL Monitor, you can monitor SQL Server Central's servers on http://www.thefutureofmonitoring.com without having to install the tool.

    If you have any questions, please feel free to email dba.info@red-gate.com.

    Thanks and with kind regards,

    Wibke

    Red Gate Software

  • A really neat product, I'm especially interested in how you came up with this list of performance counters, and if the list is considered proprietary:

    Machine: processor time

    Avg. CPU queue length

    Machine: memory used

    Memory pages/sec

    Network utilization

    Disk used

    Disk avg. read time

    Disk avg. write time

    Disk transfers/sec

    Avg. disk queue length

    User connections

    SQL Server: processor time

    SQL Server: total memory

    SQL Server: target memory

    Batch requests/sec

    Compilations/sec

    Compilations/batch

    Recompilations/sec

    Buffer cache hit ratio

    Buffer free pages

    Buffer page life expectancy

    Full scans/sec

    Page splits/sec

    Page splits/batch request

    Latch wait time

    Lock timeouts/sec

    Lock waits/sec

    Avg. lock wait time

    Transactions/sec

    Active transactions

    Total size

    Data size

    Log size

    Log space used

    Log bytes flushed/sec

    Log flushes/sec

    Log flush waits/sec

    Thanks for the wonderful detail about each counter. It would be nice to see it posted on this website.

  • Hi,

    Thanks a lot for your feedback.

    We came up with this list of counters after extensive research, feedback/ review from many DBA's and from our Beta/ EAP (Early Access Program) users. The help on the Analysis page has also been reviewed by multiple DBA's including Brad McGehee also.

    Regards,

    Priya

  • Hi Robert

    Thanks for the great feedback on SQL Monitor - glad you like what you see.

    First of all - the list is certainly not proprietary. Feel free to use it - I hope it's useful to you.

    On your main question - we put together the list by talking to a lot of DBAs and doing a lot of research. We asked all sorts of DBAs the question - "What do you use to help you find and fix problems?" and we came up with that list.

    And great that the descriptions are useful - that was the aim of those!

    Regards

    Ben Rees

    Red Gate Software

  • Is email the only method that can be used to send notifications for an alert?

    Michael L John
    If you assassinate a DBA, would you pull a trigger?
    To properly post on a forum:
    http://www.sqlservercentral.com/articles/61537/

  • Hi Michael

    Yes, it is at the moment, though this is very configurable.

    What sort of notification were you looking for?

    Ben

  • Robert.Sterbal (11/8/2010)


    A really neat product, I'm especially interested in how you came up with this list of performance counters, and if the list is considered proprietary:

    Machine: processor time

    Avg. CPU queue length

    Machine: memory used

    Memory pages/sec

    Network utilization

    Disk used

    Disk avg. read time

    Disk avg. write time

    Disk transfers/sec

    Avg. disk queue length

    User connections

    SQL Server: processor time

    SQL Server: total memory

    SQL Server: target memory

    Batch requests/sec

    Compilations/sec

    Compilations/batch

    Recompilations/sec

    Buffer cache hit ratio

    Buffer free pages

    Buffer page life expectancy

    Full scans/sec

    Page splits/sec

    Page splits/batch request

    Latch wait time

    Lock timeouts/sec

    Lock waits/sec

    Avg. lock wait time

    Transactions/sec

    Active transactions

    Total size

    Data size

    Log size

    Log space used

    Log bytes flushed/sec

    Log flushes/sec

    Log flush waits/sec

    Thanks for the wonderful detail about each counter. It would be nice to see it posted on this website.

    about 9 months ago i started to really monitor our SQL servers and set up perfmon. i just selected any counter which i thought could be remotely useful. made some reports in SSIS but haven't had much time for really doing something with the data

  • How about an SMS text, a Blackberry PIN message, and possibly a cell phone call?

    Michael L John
    If you assassinate a DBA, would you pull a trigger?
    To properly post on a forum:
    http://www.sqlservercentral.com/articles/61537/

  • i have been running this product all through the beta. (about 2 months now) it has come along way....

    my company will be buying it first QTR 2011. (had to wait for the bean counters to put it in the budget)

    while it is not as "complete" as Diagnostic Manager or SQL Ignite, for the price, it is great!

    RedGate has a forum for users and testers to make recommendations and voice complaints. they are very quick to respond and tell you if they can help or not. for example, I said they were missing an alert for failed logins and they responded back with in 6 hours saying it will be added in a future update.

    thanks RedGate for another choice for SQL monitoring.

  • Glad to hear Geoff that you are liking it.

    Regards,

    Priya

  • Michael L John (11/8/2010)


    How about an SMS text, a Blackberry PIN message, and possibly a cell phone call?

    Hi Michael

    Thanks for the feedback - we have been looking at some of these options for future releases.

    There are third party companies that offer this sort of service on top of alerting systems, http://www.pagerduty.com/[/url], for example. In particular these companies often provide quite advanced call management (for example, if someone doesn't answer the phone call, the system will redirect it to the next person on the list and so on). Is this the sort of functionality you're looking for?

    Regards

    Ben

  • Most carriers offer you an email, usually yourphone@carrier.com (like 5555555@tmobile.com) to send an SMS from email.

Viewing 15 posts - 1 through 15 (of 16 total)

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