Operations Manager and SQL Server

  • SQLRockstar

    SSCertifiable

    Points: 6169

    Comments posted to this topic are about the item Operations Manager and SQL Server

    ----------------------
    https://thomaslarock.com

  • Anipaul

    SSC-Insane

    Points: 24681

    Nice article...:)

  • Dugi

    SSCoach

    Points: 17998

    Not bad ...:hehe:

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • Grant Fritchey

    SSC Guru

    Points: 396471

    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 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd Edition
    Product Evangelist for Red Gate Software

  • Antares686

    SSC Guru

    Points: 125444

    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.

  • Jon Monahan

    SSCertifiable

    Points: 5099

    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.

  • einman33

    SSCrazy

    Points: 2753

    Great article, thank you.

  • Marios Philippopoulos

    SSC Guru

    Points: 57030

    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!

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

  • SanjayAttray

    SSChampion

    Points: 13157

    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.

  • Marios Philippopoulos

    SSC Guru

    Points: 57030

    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.

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

  • Wayne West

    SSC-Insane

    Points: 22586

    That looks very neat, but considering the cost of getting into Management Server, I doubt we'll ever see it here.

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • Ameena Lalani-347953

    Old Hand

    Points: 322

    I was looking for information like this. We have recently implemented SCOM and as a DBA I need to learn part of it. Yesterday I upgraded one of my moitored server to sql 2005 with sp2 and latest hotfix. Today SCOM sents an alert saying this installation does not have sevice pack. We checked to make sure. We have other tools and we found that it was a false alert.

  • Ronald C Hagerman

    SSC Enthusiast

    Points: 101

    Thanks for the article.

    I used it to create a view into our depot servers 🙂

    We assign roles to all of our servers so I used your method to get the role name out of the registry.

    Very nice and well done

    Thanks!

  • Davuth Te

    SSC Veteran

    Points: 202

    OpsManager reminds me a lot of another product, Data Palette (www.stratavia.com). Does anyone have experience using both products? If so, what are the pros and cons of each?

  • Keith Mescha

    Old Hand

    Points: 370

    Tom, I did finally get this all setup and thanks a ton for this. I am still having some issues on certain instances not showing up. I'll dig more but wonder if you had similar issues.

    Certain SQL2005 cluster instances are not showing up. Some are however so that is strange.

    Also I have one named instance on SQL2000 that doesn't get caught. I'll start digging into the Registry keys tomorrow to see what's up but if you had run into this you might save me some time.

    Thanks,

    2/9/2010

    Update I have figured out that the Registry key that this article is pointing to is the default instance key for SQL Server. So on servers without a default instance (We have a few) this will not work. Still looking for other options and will post back when I find one.

Viewing 15 posts - 1 through 15 (of 15 total)

You must be logged in to reply to this topic. Login to reply