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


Monitoring tools


Monitoring tools

Author
Message
sqlbuddy123
sqlbuddy123
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

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

Thank You,

Best Regards,
SQLBuddy
bwieland
bwieland
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: 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 (104 reputation)SSC-Enthusiastic (104 reputation)SSC-Enthusiastic (104 reputation)SSC-Enthusiastic (104 reputation)SSC-Enthusiastic (104 reputation)SSC-Enthusiastic (104 reputation)SSC-Enthusiastic (104 reputation)SSC-Enthusiastic (104 reputation)

Group: General Forum Members
Points: 104 Visits: 1321
Can System Center Operations Manager be used for this type of monitoring?
bwieland
bwieland
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: 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
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: 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-Insane
SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)

Group: General Forum Members
Points: 21101 Visits: 18259
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 Rookie
SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)

Group: General Forum Members
Points: 35 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 (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: 21
My thanks to all of you for the great advice. Already looking actively at your recommendations! Best regards and Happy Holidays.
SKYBVI
SKYBVI
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1233 Visits: 3239
Idera's SQL diagonistic manager has been good in the fields you are requesting.

Regards,
Sushant
grahamc
grahamc
Mr or Mrs. 500
Mr or Mrs. 500 (576 reputation)Mr or Mrs. 500 (576 reputation)Mr or Mrs. 500 (576 reputation)Mr or Mrs. 500 (576 reputation)Mr or Mrs. 500 (576 reputation)Mr or Mrs. 500 (576 reputation)Mr or Mrs. 500 (576 reputation)Mr or Mrs. 500 (576 reputation)

Group: General Forum Members
Points: 576 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