Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Red Gate releases new SQL Monitor 2.0: The future of monitoring is wherever you are Expand / Collapse
Author
Message
Posted Saturday, November 6, 2010 1:59 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, July 15, 2008 7:24 AM
Points: 0, Visits: 0
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
Post #1016894
Posted Monday, November 8, 2010 6:56 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, March 7, 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...
Post #1017164
Posted Monday, November 8, 2010 8:38 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, August 21, 2014 12:08 PM
Points: 1,414, Visits: 4,540
how much is it?

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]
Post #1017233
Posted Monday, November 8, 2010 9:31 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Post #1017269
Posted Monday, November 8, 2010 9:59 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 7:36 AM
Points: 158, Visits: 1,806
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.
Post #1017289
Posted Monday, November 8, 2010 10:20 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, September 19, 2013 8:38 AM
Points: 17, Visits: 74
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
Post #1017300
Posted Monday, November 8, 2010 10:26 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Post #1017304
Posted Monday, November 8, 2010 10:40 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 9:49 AM
Points: 960, Visits: 3,013
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/
Post #1017319
Posted Monday, November 8, 2010 11:37 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Post #1017365
Posted Monday, November 8, 2010 11:50 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, August 21, 2014 12:08 PM
Points: 1,414, Visits: 4,540
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]
Post #1017373
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse