November 6, 2010 at 1:59 pm
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
November 8, 2010 at 6:56 am
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...
November 8, 2010 at 8:38 am
how much is it?
November 8, 2010 at 9:31 am
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
November 8, 2010 at 9:59 am
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.
November 8, 2010 at 10:20 am
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
November 8, 2010 at 10:26 am
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
November 8, 2010 at 10:40 am
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/
November 8, 2010 at 11:37 am
Hi Michael
Yes, it is at the moment, though this is very configurable.
What sort of notification were you looking for?
Ben
November 8, 2010 at 11:50 am
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
November 8, 2010 at 12:15 pm
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/
November 9, 2010 at 6:24 am
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.
November 9, 2010 at 7:06 am
Glad to hear Geoff that you are liking it.
Regards,
Priya
November 9, 2010 at 7:37 am
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
November 9, 2010 at 7:40 am
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 15 total)
You must be logged in to reply to this topic. Login to reply