Connection failed (Bad data)

mipe10 · January 10, 2011 4:41AM

Hi,
I have sql monitored installed on a cluster. Everythings seems to work when a run the sql instance on one of the physical servers, when i fail over to the other machine in the cluster i get the error connection failed (bad data). The Exception message report that Perfmon data is missing objects: MSSQL$SQL1:Access Methods, MSSQL$SQL1:Buffer Manager, MSSQL$SQL1:Databases, MSSQL$SQL1:General Statistics, MSSQL$SQL1:Latches, MSSQL$SQL1:Locks, MSSQL$SQL1:Memory Manager, MSSQL$SQL1:SQL Statistics. Possible causes include performance counter library corruption, or a 32-bit/64-bit mismatch between Windows and the performance counter provider (e.g. SQL Server).

I have verified that both windows and sql server is running the x64 version. The counters reported missing exists on both physical machines as well (verified using perfmon on each physical machine)

I need help to find the problem.

Thanks

priyasinha · January 10, 2011 7:45AM

Hi,

Apologies for the error.

Do you still see this error i.e. perfmon data not appearing? Or does it happen only for sometime just after the failover?

Thanks,
Priya

mipe10 · January 11, 2011 7:20AM

Hi,
The problem exists when runnig on one of the physical machines. The problem is continues and isn't solved until I fail over to the other node where everything works fine.

mipe10 · January 11, 2011 7:37AM

Errors are also reported in the red-gate software log in windows (on the server where the base monitor service is installed. Perhaps I should start a support case instead to get to the bottom of this!?

priyasinha · January 11, 2011 8:49AM

Hi,

Thanks for your post. Yes, please raise a support call. Add a reference to this forum request too. Also, please send the log files and screen shot of the Monitored servers page also.

Thanks,
Priya

Connection failed (Bad data)

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk