Post reply

Operations Manager and SQL Server

  • July 23, 2008 at 12:15 am

    #191392

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

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

  • July 23, 2008 at 12:27 am

    #846835

    Nice article...:)

  • July 23, 2008 at 12:50 am

    #846849

    Not bad ...:hehe:

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

  • July 23, 2008 at 5:55 am

    #846939

    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

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • July 23, 2008 at 6:42 am

    #846977

    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.

  • July 23, 2008 at 6:56 am

    #846997

    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.

  • July 23, 2008 at 8:57 am

    #847107

    Great article, thank you.

  • July 23, 2008 at 10:12 am

    #847174

    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]

  • July 23, 2008 at 12:08 pm

    #847265

    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.

  • July 23, 2008 at 12:16 pm

    #847270

    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]

  • July 23, 2008 at 12:17 pm

    #847272

    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]

  • July 23, 2008 at 3:10 pm

    #847398

    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.

  • July 24, 2008 at 1:54 pm

    #848059

    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!

  • July 24, 2008 at 5:14 pm

    #848143

    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?

  • February 8, 2010 at 4:01 pm

    #1115849

    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 14 (of 14 total)

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