|
|
|
Forum Newbie
      
Group: General Forum Members
Last Login: Tuesday, July 15, 2008 7:24 AM
Points: 0,
Visits: 0
|
|
|
|
|
|
SSC Journeyman
      
Group: General Forum Members
Last Login: Thursday, March 07, 2013 6:16 AM
Points: 90,
Visits: 350
|
|
| 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...
|
|
|
|
|
Ten Centuries
      
Group: General Forum Members
Last Login: Monday, June 10, 2013 10:43 AM
Points: 1,411,
Visits: 4,517
|
|
|
|
|
|
Forum Newbie
      
Group: General Forum Members
Last Login: Wednesday, February 13, 2013 6:43 AM
Points: 3,
Visits: 179
|
|
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 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
|
|
|
|
|
SSC Journeyman
      
Group: General Forum Members
Last Login: Friday, June 14, 2013 7:11 AM
Points: 94,
Visits: 1,360
|
|
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.
|
|
|
|
|
Grasshopper
      
Group: General Forum Members
Last Login: Friday, May 24, 2013 8:44 AM
Points: 17,
Visits: 62
|
|
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
|
|
|
|
|
Forum Newbie
      
Group: General Forum Members
Last Login: Thursday, February 17, 2011 2:38 PM
Points: 7,
Visits: 43
|
|
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
|
|
|
|
|
Right there with Babe
      
Group: General Forum Members
Last Login: Today @ 5:19 AM
Points: 750,
Visits: 2,121
|
|
Is email the only method that can be used to send notifications for an alert?
Michael L John To properly post on a forum: http://www.sqlservercentral.com/articles/61537/
|
|
|
|
|
Forum Newbie
      
Group: General Forum Members
Last Login: Thursday, February 17, 2011 2:38 PM
Points: 7,
Visits: 43
|
|
Hi Michael
Yes, it is at the moment, though this is very configurable.
What sort of notification were you looking for?
Ben
|
|
|
|
|
Ten Centuries
      
Group: General Forum Members
Last Login: Monday, June 10, 2013 10:43 AM
Points: 1,411,
Visits: 4,517
|
|
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
https://plus.google.com/100125998302068852885/posts?hl=en http://twitter.com/alent1234 x-box live gamertag: i am null [url=http://live.xbox.com/en-US/MyXbox/Profile[/url]
|
|
|
|