Hello All, we would like to utilize our enterprise monitoring system (System Center Operations Manager 2012 R2) to monitor our SQL Server Service Broker queue/Framework. Per my research so far I haven't been able find any information regarding SCOM offering SQL Service Broker monitoring nor I see nay management packs available for it. I do see and found MSMQ MP but not SQL Service Broker. Please advice as to what are my options to monitor service broker end-to-end?

Thanks

Hi Sir,

"

Some rules in the management pack are disabled by default to avoid noise. Consider enabling rules that can be valuable in your environment. The following rules are disabled by default:

• An SQL job failed to complete successfully
• An SQL Server Service Broker procedure output results
• An SNI call failed during a Service Broker/Database Mirroring transport operation
• SQL Server restarted
• SQL Server Service Broker Manager has shutdown
• SQL Server Service Broker or Database Mirroring is running in FIPS compliance mode
• SQL Server Service Broker or Database Mirroring Transport stopped
• SQL Server Service Broker transmitter shut down due to an exception or a lack of memory
• SQL Server terminating because of system shutdown
• Table: Creating statistics for the following columns
• The Service Broker or Database Mirroring Transport has started

"

Please refer to the SQL MP document :

http://www.microsoft.com/en-us/download/details.aspx?id=10631

Best Regards,

Elton Ji