Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


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


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

Author
Message
Press Release
Press Release
SSC Rookie
SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)

Group: General Forum Members
Points: 28 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
Bob Bridges-173967
Bob Bridges-173967
SSC Journeyman
SSC Journeyman (92 reputation)SSC Journeyman (92 reputation)SSC Journeyman (92 reputation)SSC Journeyman (92 reputation)SSC Journeyman (92 reputation)SSC Journeyman (92 reputation)SSC Journeyman (92 reputation)SSC Journeyman (92 reputation)

Group: General Forum Members
Points: 92 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...
alen teplitsky
alen teplitsky
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1595 Visits: 4621
how much is it?
Wibke Carstensen
Wibke Carstensen
Forum Newbie
Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)

Group: General Forum Members
Points: 5 Visits: 182
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
Robert.Sterbal
Robert.Sterbal
SSC Veteran
SSC Veteran (213 reputation)SSC Veteran (213 reputation)SSC Veteran (213 reputation)SSC Veteran (213 reputation)SSC Veteran (213 reputation)SSC Veteran (213 reputation)SSC Veteran (213 reputation)SSC Veteran (213 reputation)

Group: General Forum Members
Points: 213 Visits: 2000
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.
priya.sinha
priya.sinha
Grasshopper
Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)

Group: General Forum Members
Points: 19 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
benjrees
benjrees
Forum Newbie
Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)

Group: General Forum Members
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
Michael L John
Michael L John
SSCrazy
SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)

Group: General Forum Members
Points: 2054 Visits: 7401
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/
benjrees
benjrees
Forum Newbie
Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)

Group: General Forum Members
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
alen teplitsky
alen teplitsky
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1595 Visits: 4621
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search