Hello, I would like to disable monitoring for a SQL Server instance. I have apply an override to server hosting SQL Server instance. I have setup parameter name "Enabled" to false. Now SQL Server instance has status "Not monitored", but when I stop SQL Server service and SQL Server agent I received always scom alert. Is it necessary to apply an other override to stop monitoring ? Thanks Eric

There are many things monitored in the SQL MP, so disabling one monitor isn't going to stop all the other alerts that can be generated. You may want to override the discovery of this server for SQL. There is a seed discovery that starts the initial SQL discovery. Override disable that for this server. Bounce the agent on that SQL box so that it gets new configuration. Then in a few hours run: remove-disabledmonitoringobject from opsmgr powershell. That server should disappear from all SQL views and components.Regards, Blake Email: mengotto<at>hotmail.com Blog: http://discussitnow.wordpress.com/

1. disable sql discover instance discovery of this sql server 2. run Remove-DisabledMonitoringObject to remove disable monitor object http://thoughtsonopsmgr.blogspot.com/2010/07/challenge-how-to-exclude-certain.html roger

Hi, Please try again referring to the method in Kevins blog: Stop monitoring SQL Express and Windows Internal Database http://blogs.technet.com/b/kevinholman/archive/2010/02/13/stop-monitoring-sql-express-and-windows-internal-database.aspx Hope this helps. Thanks. Nicholas Li TechNet Community Support

Hi, Thanks for your link Nicholas It resolve my problem. 1)I have apply an override to -object discovery name: SQL Server 2008 Database Engines (Windows Server) -Target : Server_Name Then Apply value false to parameter name = Enabled 2) And apply Powershell command : Remove-DisabledMonitoringObject Now if I stop Sqlserver instance, I do not receive SCOM alert Eric

Hi, Thanks for your link Nicholas It resolve my problem. 1)I have apply an override to -object discovery name: SQL Server 2008 Database Engines (Windows Server) -Target : Server_Name Then Apply value false to parameter name = Enabled 2) And apply Powershell command : Remove-DisabledMonitoringObject Now if I stop Sqlserver instance, I do not receive SCOM alert Eric

Hello, It's resolve my problem for SQL Server Engine But to disable discover for SSAS instance I have always a problem I have a setup an override to: -object discovery name : SQL Server 2005 Analysis Services Windows Service(windows server) Override target : network name of SSAS instance (it is cluster instance. When I want to connect SSAS instance I specify network_name\Instance_Name ) However object corresponding instance name always populate my groupes Any ideas ? Eric

Hi, Please check the issue referring to the following post: Challenge: How to exclude certain servers from being monitored on a certain application? http://thoughtsonopsmgr.blogspot.com/2010/07/challenge-how-to-exclude-certain.html Thanks. Nicholas Li TechNet Community Support

Hi, Please check the issue referring to the following post: Challenge: How to exclude certain servers from being monitored on a certain application? http://thoughtsonopsmgr.blogspot.com/2010/07/challenge-how-to-exclude-certain.html Thanks. Nicholas Li TechNet Community Support

Those are separate discoveries. FOr SQL roles there are a few and targetted at Windows Computer I think. You can override those discoveries for that computer object. And of course the remove-disabledmonitoringobject command.Bob Cornelissen - BICTT (My Blog about SCOM) - MVP 2012 and Microsoft Community Contributor 2011 Recipient

Those are separate discoveries. FOr SQL roles there are a few and targetted at Windows Computer I think. You can override those discoveries for that computer object. And of course the remove-disabledmonitoringobject command.Bob Cornelissen - BICTT (My Blog about SCOM) - MVP 2012 and Microsoft Community Contributor 2011 Recipient