This forum has migrated to Microsoft Q&A. Visit Microsoft Q&A to post new questions.

Remove From My Forums

SQL Server Windows Service monitor not working

Question
0

Sign in to vote

Hi,

Has anyone seening the alert from SQL Server Windows Service monitor in SQL2005/2008 MPs. The monitor is enabled by default, but it didn't alert when my SQL Server instance went down for 5 minutes. Did I miss anything? Please help.

Thanks,

Ed

Wednesday, June 13, 2012 11:16 PM

All replies

0

Sign in to vote

Hi,

I suggest you refer to the MP guide to re-configure it for a test:

SQL Server Management Pack Guide

http://technet.microsoft.com/en-us/library/dd279608

Supported Configurations

http://technet.microsoft.com/en-us/library/dd767423

Alex Zhao

TechNet Community Support

Thursday, June 14, 2012 9:27 AM
0

Sign in to vote

Update: I did further testing. It works on non-clustered sql server instances, but the monitor doesn't work in the clustered sql instances even though I set "Alet only if service startup type is automatic" to false. It appears to be a bug. Can please someone validate?

Ed

Monday, June 18, 2012 5:02 PM
0

Sign in to vote

Hi,

Have you referred to the article below?

SQL Server 2008 Cluster Monitoring Using SCOM 2007 R2

http://blogs.technet.com/b/birojitn/archive/2010/04/14/sql-server-2008-cluster-monitoring.aspx
Alex Zhao

TechNet Community Support

Tuesday, June 19, 2012 2:03 AM
0

Sign in to vote

Yes Alex. The steps in the article were done. And SCOM discovers the cluster and its resources. But the monitor doesn't work.

Tuesday, June 19, 2012 3:58 PM
0

Sign in to vote

I am experiencing the same issue. Did you ever find a solution to this?

Friday, May 24, 2013 1:54 PM