SQL Clone
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
Ten Centuries
Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)

Group: General Forum Members
Points: 1412 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
Right there with Babe
Right there with Babe (744 reputation)Right there with Babe (744 reputation)Right there with Babe (744 reputation)Right there with Babe (744 reputation)Right there with Babe (744 reputation)Right there with Babe (744 reputation)Right there with Babe (744 reputation)Right there with Babe (744 reputation)

Group: General Forum Members
Points: 744 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
SSChampion
SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)

Group: General Forum Members
Points: 12386 Visits: 4674
how much is it?
Wibke Carstensen
Wibke Carstensen
Grasshopper
Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)

Group: General Forum Members
Points: 15 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 Eights!
SSC Eights! (993 reputation)SSC Eights! (993 reputation)SSC Eights! (993 reputation)SSC Eights! (993 reputation)SSC Eights! (993 reputation)SSC Eights! (993 reputation)SSC Eights! (993 reputation)SSC Eights! (993 reputation)

Group: General Forum Members
Points: 993 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
SSC Veteran
SSC Veteran (229 reputation)SSC Veteran (229 reputation)SSC Veteran (229 reputation)SSC Veteran (229 reputation)SSC Veteran (229 reputation)SSC Veteran (229 reputation)SSC Veteran (229 reputation)SSC Veteran (229 reputation)

Group: General Forum Members
Points: 229 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
Valued Member
Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)

Group: General Forum Members
Points: 63 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 Eights
SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)

Group: General Forum Members
Points: 9494 Visits: 8517
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
Valued Member
Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)

Group: General Forum Members
Points: 63 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
SSChampion
SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)

Group: General Forum Members
Points: 12386 Visits: 4674
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