Home > OpsMgr > Disable SQL Express monitoring

Disable SQL Express monitoring

When you deploy the SQL MP (2005 & 2008), the discovery rule that targets the windows computer class start to collect information about SQL DB Engine. the results are that SQL Express edition (SQL 2005) and the Windows Internal DB (SQL 2008) are being monitored immediately.

In my experience, most DBAs do not like to get alerts about instances of SQL Express edition and Windows Internal DB. but several system administrators like to know if there is a problem with applications that uses those DB (Antivirus software, SCVMM, backup etc’). so basically if we will disable the discovery process we will not be able to get the state of the SQL service.

in that case, I advice my customers that do need to monitor SQL Express to build a dynamic group for those instances. to build this group do the following:

1. Open the admin console –> authoring –> groups.

2. Create a new group (SQL Express DB Engine)

image

3. Right click on the group you created and select View Group Members…

image

verify the the group contain the SQL Express and Windows Internal DB.

image

now its time to disable the monitors that we don’t need.

scope the authoring view to SQL 2005 DB Engine and SQL 2008 DB Engine and override the monitors that you do need. use the group we created earlier for the override.

image

 image

Do not Forget that the best way to disable a monitor is to use overrides and the disable option, if you disable a monitors you can not choose the management pack for overrides and you use the default MP!!!

Note:

1. The overrides are for monitors only, take in mind that we did not overrides any rules that target SQL DB Engine.

2. If you with to disable discovery for SQL Express and Windows Internal DB you can use the following: http://blogs.technet.com/kevinholman/archive/2010/02/13/stop-monitoring-sql-express-and-windows-internal-database.aspx

Advertisements
Categories: OpsMgr Tags: ,
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: