This project is read-only.
1

Closed

Reproduce Error on Windows 2008 Cluster and SQL 2005 Instance

description

As reported in the discussions tread there is a problem on a Windows 2008 cluster installation. While in discussions tread it appears that the installation fails this might not be the issue. There is a monitoring log and this is only created when the service is running. This workitem is to investigate and reproduce the error. Below is an excerpt from the logfile
 
20090922 13:52:21.39 Information ServiceCore.LoadSampledData Data retrieval started...
20090922 13:52:21.39 Information ServiceCore.LoadSampledData Running on cluster CLUSTERCL1
20090922 13:52:21.39 Information ServiceCore.LoadSampledData Retrieving Cluster Resource Groups
20090922 14:09:54.86 Information ServiceCore.LoadSampledData Data retrieval started...
20090922 14:09:54.86 Information ServiceCore.LoadSampledData Running on cluster CLUSTERCL1
20090922 14:09:54.86 Information ServiceCore.LoadSampledData Retrieving Cluster Resource Groups
20090922 14:09:54.93 Information ServiceCore.LoadSampleData MSCluster_Node.Name="CLUSTERCL1N1"::MSCluster_ResourceGroup.Name="Available Storage"
20090922 14:09:54.93 Information ServiceCore.LoadSampleData MSCluster_Node.Name="CLUSTERCL1N1"::MSCluster_ResourceGroup.Name="Cluster Group"
20090922 14:09:54.93 Information ServiceCore.LoadSampleData MSCluster_Node.Name="CLUSTERCL1N1"::MSCluster_ResourceGroup.Name="CLUSTERCL1DTC"
20090922 14:09:54.93 Information ServiceCore.LoadSampleData MSCluster_Node.Name="CLUSTERCL1N1"::MSCluster_ResourceGroup.Name="SQL Server Group"
20090922 14:09:54.96 Error ServiceCore.GetPerfmonCounters Generic failure
20090922 14:09:55.00 Error ServiceCore.OsCore System.Management.ManagementException: Generic failure at System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus errorCode) at System.Management.ManagementObjectCollection.ManagementObjectEnumerator.MoveNext() at SqlMonitoring.Service.OS.OSHealth.GetServices(DataTable dataTableServices, String hostName, String hostDomain) at SqlMonitoring.Service.OS.OSCore.GetSampledData(DataTable sampledData, DataTable perfmonData) at SqlMonitoring.Service.ServiceCore.LoadSampledData()
20090922 14:09:55.02 Error ServiceCore.SqlCore Generic failure
20090922 14:09:55.04 Information ServiceCore.BulkCopyData Bulk inserting data...
20090922 14:09:55.04 Information ServiceCore.BulkCopyData Copied SampleData: 0 rows
20090922 14:09:55.05 Information ServiceCore.ProcessAlerts Processed 0 Alert(s).
Closed Nov 30, 2011 at 8:19 PM by rhartsk

comments

bert1962 wrote Sep 23, 2009 at 8:53 PM

It is possible that it's running (I'm not too familiar with Win 2008). But I don't see a service running and the client never displays any info this instance.

rhartskeerl wrote Sep 25, 2009 at 8:03 PM

Bert,
The SqlMonitoring log is only created when the service is running. This should be visible in the services snap-in (services.msc, look for an entry SqlMonitoring.Service). When I look at the SqlMonitoring Log it has a problem getting the Perfmon counters. These should be inside the central monitoring database in the EntityGroup table where the column IsPerfmonCounter reads 1. This is the reason the row SampleData shows 0 rows. I believe that because the Perfmon is failing the others are failing as well. I will update the code to circumvent this, I've seen this happen on servers not running Sql Server.

Why the installation reported a failure is a mistery to me. There are no errors in the log, just the rollback. But still, the second log you attached is only created when the service is running.

wrote Nov 30, 2011 at 8:19 PM

wrote Feb 14, 2013 at 3:49 AM

wrote May 16, 2013 at 8:02 AM