InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 21:26:57 GMT20http://www.sqlservercentral.com/Forums/Topic539003-287-1.aspxTom, 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/2010Update 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.Mon, 08 Feb 2010 16:01:49 GMTKeith Meschahttp://www.sqlservercentral.com/Forums/Topic539003-287-1.aspxOpsManager 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?Thu, 24 Jul 2008 17:14:20 GMTDavuth Tehttp://www.sqlservercentral.com/Forums/Topic539003-287-1.aspxThanks 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 doneThanks!Thu, 24 Jul 2008 13:54:13 GMTRonald C Hagermanhttp://www.sqlservercentral.com/Forums/Topic539003-287-1.aspxI 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.Wed, 23 Jul 2008 15:10:12 GMTAmeena Lalani-347953http://www.sqlservercentral.com/Forums/Topic539003-287-1.aspxThat looks very neat, but considering the cost of getting into Management Server, I doubt we'll ever see it here.Wed, 23 Jul 2008 12:17:21 GMTWayne Westhttp://www.sqlservercentral.com/Forums/Topic539003-287-1.aspx[quote][b]SanjayAttray (7/23/2008)[/b][hr]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.[/quote]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.Wed, 23 Jul 2008 12:16:29 GMTMarios Philippopouloshttp://www.sqlservercentral.com/Forums/Topic539003-287-1.aspxGood 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.Wed, 23 Jul 2008 12:08:44 GMTSanjayAttrayhttp://www.sqlservercentral.com/Forums/Topic539003-287-1.aspxThis 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!Wed, 23 Jul 2008 10:12:38 GMTMarios Philippopouloshttp://www.sqlservercentral.com/Forums/Topic539003-287-1.aspxGreat article, thank you.Wed, 23 Jul 2008 08:57:29 GMTeinman33http://www.sqlservercentral.com/Forums/Topic539003-287-1.aspxOne 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.Wed, 23 Jul 2008 06:56:47 GMTJon Monahanhttp://www.sqlservercentral.com/Forums/Topic539003-287-1.aspxGood 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.Wed, 23 Jul 2008 06:42:27 GMTAntares686http://www.sqlservercentral.com/Forums/Topic539003-287-1.aspxNice article, Tom. Thanks for sharing that solution. I'm passing it on to our OpsMgr admin to see if he can use it.Wed, 23 Jul 2008 05:55:52 GMTGrant Fritcheyhttp://www.sqlservercentral.com/Forums/Topic539003-287-1.aspxNot bad ...:hehe:Wed, 23 Jul 2008 00:50:38 GMTDugihttp://www.sqlservercentral.com/Forums/Topic539003-287-1.aspxNice article...:)Wed, 23 Jul 2008 00:27:06 GMTAnipaulhttp://www.sqlservercentral.com/Forums/Topic539003-287-1.aspxComments posted to this topic are about the item [B]<A HREF="/articles/Operations+Manager/63490/">Operations Manager and SQL Server</A>[/B]Wed, 23 Jul 2008 00:15:56 GMTThomas LaRock