SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Monitoring tools


Monitoring tools

Author
Message
sqlbuddy123
sqlbuddy123
SSCrazy
SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)

Group: General Forum Members
Points: 2418 Visits: 2243
I'd prefer Idera's SQL Diagnostic Manager.

Thank You,

Best Regards,
SQLBuddy
bwieland
bwieland
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: 21
It is my hope that the SQL Monitor Webinar on 12/14 can answer those questions....
arussell_10
arussell_10
SSC-Enthusiastic
SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)

Group: General Forum Members
Points: 170 Visits: 1326
Can System Center Operations Manager be used for this type of monitoring?
bwieland
bwieland
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: 21
Very quick question for you. Do you have any research on pro's / con's of both products. I was listening to the presentation yesterday and it was very helpful. It would seem for our organization, we are looking not only for monitoring, but potentially some level of remedial approaches when monitoring indicates a challenge. While most of the DBA's that attend SQL Server Central are adept, I'm not certain our small organization (that is growing) has the same level of expertise as people like you. The presenter did a very good job of framing the 'four areas' to watch. It would appear that there are multiple solutions that will help you 'watch' your DB's. Do you find any of these tools that provide remedial approaches to problems or is it 'every man for himself'. Thanks for the insight.
Sbarie
Sbarie
Grasshopper
Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)

Group: General Forum Members
Points: 11 Visits: 23
bwieland said: I'm not certain our small organization (that is growing) has the same level of expertise as people like you. "Do you find any of these tools that provide remedial approaches to problems or is it 'every man for himself'?

One helpful aspect of LogicMonitor is that its alerts don't just tell you a host is down. It gives you suggestions for resolution.
SQLRNNR
SQLRNNR
SSC-Dedicated
SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)

Group: General Forum Members
Points: 33034 Visits: 18560
As far as monitoring goes - another good tool is Confio Ignite. I did an eval of this tool and found it to be extremely helpful.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw

Sodtke
Sodtke
SSC Journeyman
SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)

Group: General Forum Members
Points: 79 Visits: 302
If you are looking for a simple monitoring tool for your SQL Agent job systems with vibrant visuals, you can check out SQL Agent Insight @ www.brentec.ca. The software is relatively new with new features being actively added. Email notification is there as well for any thresholds that are exceeded.

Hope this is helpful.
Regards.
bwieland
bwieland
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: 21
My thanks to all of you for the great advice. Already looking actively at your recommendations! Best regards and Happy Holidays.
SKYBVI
SKYBVI
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: 1575 Visits: 3239
Idera's SQL diagonistic manager has been good in the fields you are requesting.

Regards,
Sushant
grahamc
grahamc
Right there with Babe
Right there with Babe (750 reputation)Right there with Babe (750 reputation)Right there with Babe (750 reputation)Right there with Babe (750 reputation)Right there with Babe (750 reputation)Right there with Babe (750 reputation)Right there with Babe (750 reputation)Right there with Babe (750 reputation)

Group: General Forum Members
Points: 750 Visits: 1039
System
Centre
Operations
Manager

from Microsoft is also pretty good. The SQL management packs were quite good. The benefit is that its Microsoft, the management packs are (were) written by the SQL team and the SCOM can be used monitor more than just SQL (Exchange, OS, etc, etc). SCOM uses an agent on the server, so you can monitor and see how much of an impact the agent has on the server.

I used Idera at a previous place, and did not like it. It uses an agentless method and "pulls" information from the server. This can compound issues when a server is performing poorly.
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