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»»

Operations Manager and SQL Server Expand / Collapse
Author
Message
Posted Wednesday, July 23, 2008 12:15 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 1:10 PM
Points: 2,771, Visits: 454
Comments posted to this topic are about the item Operations Manager and SQL Server

----------------------
http://thomaslarock.com
Post #539003
Posted Wednesday, July 23, 2008 12:27 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, March 20, 2014 7:32 AM
Points: 5,191, Visits: 1,368
Nice article...:)


Post #539014
Posted Wednesday, July 23, 2008 12:50 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, February 21, 2014 2:16 PM
Points: 1,259, Visits: 3,417
Not bad ...

============================================================
SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Post #539031
Posted Wednesday, July 23, 2008 5:55 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 4:48 AM
Points: 14,802, Visits: 27,278
Nice article, Tom. Thanks for sharing that solution. I'm passing it on to our OpsMgr admin to see if he can use it.

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #539153
Posted Wednesday, July 23, 2008 6:42 AM
SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: Moderators
Last Login: Thursday, April 17, 2014 3:54 PM
Points: 8,369, Visits: 733
Good article. We have been using Op Manager for a while and even thou it isn't my responsibility to monitor I have certain events emailed to me as I am the one who corrects them anyway and don't want to have to wait for the call as they are setup to notify me before they are really an issue.


Post #539196
Posted Wednesday, July 23, 2008 6:56 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, March 27, 2014 2:06 PM
Points: 2,507, Visits: 112
One more tool to look into. I certainly like the dashboard for a quick view of the overall health of all of the servers... Thanks for the article.
Post #539217
Posted Wednesday, July 23, 2008 8:57 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, January 25, 2012 8:14 AM
Points: 567, Visits: 512
Great article, thank you.
Post #539359
Posted Wednesday, July 23, 2008 10:12 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, April 17, 2014 2:42 PM
Points: 1,851, Visits: 3,575
This is something I have been looking forward to for a while.

There is not a lot of SQL-Server-specific SCOM info out there.

Thanks!


__________________________________________________________________________________

Turbocharge Your Database Maintenance With Service Broker: Part 2
Turbocharge Your Database Maintenance With Service Broker: Part 1
Real-Time Tracking of Tempdb Utilization Through Reporting Services
Monitoring Database Blocking Through SCOM 2007 Custom Rules and Alerts
Preparing for the Unthinkable - a Disaster/Recovery Implementation
Post #539442
Posted Wednesday, July 23, 2008 12:08 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, April 17, 2014 11:58 AM
Points: 3,924, Visits: 1,588
Good article. But, OpsMgr is not as accurate and trust worthy as it has to be. I implemented it couple of weeks back and even though my dev two servers are down for network issue for more than 24 hrs, it still showed me as "healthy", which was not.

But, I agree it does reduces some efforts of DBA but not all.


SQL DBA.
Post #539550
Posted Wednesday, July 23, 2008 12:16 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, April 17, 2014 2:42 PM
Points: 1,851, Visits: 3,575
SanjayAttray (7/23/2008)
Good article. But, OpsMgr is not as accurate and trust worthy as it has to be. I implemented it couple of weeks back and even though my dev two servers are down for network issue for more than 24 hrs, it still showed me as "healthy", which was not.

But, I agree it does reduces some efforts of DBA but not all.


In a recent MS survey I gave it a 6 out of 10 as a product. Yes, there is definitely a lot of room for improvement. We have recently had to re-install the whole thing because the OpsMgr agents were not working properly and SQL job discovery was not working! I spent an enormous amount of time trying to get the thing to work, even with help from MS support!

So, yes, in my opinion, the product is not on the same level of quality as SQL Server at this point. But the premise I think is there, and the more we all use it the better it will be in future versions.

For one thing, its customization features, along with introduction of powershell, are very promising.


__________________________________________________________________________________

Turbocharge Your Database Maintenance With Service Broker: Part 2
Turbocharge Your Database Maintenance With Service Broker: Part 1
Real-Time Tracking of Tempdb Utilization Through Reporting Services
Monitoring Database Blocking Through SCOM 2007 Custom Rules and Alerts
Preparing for the Unthinkable - a Disaster/Recovery Implementation
Post #539557
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse