Connection failed (Cannot Connect)

SQL Server performance monitoring and alerting

Moderators: eddie davis, priyasinha, Adam, chriskelly, Chris Lambrou, Chris Spencer

Connection failed (Cannot Connect)

Postby qcjims » Fri Dec 03, 2010 8:55 pm

after some time I start getting these errors:

3 Dec 2010 11:52 AM WMI GetInstances: root\\cimv2 select Name,State,StartMode from Win32_Service Cannot connect COMException

and then monitoring for a server stops.

I also see these errors all the time:

3 Dec 2010 11:52 AM WMI GetInstances: root\\cimv2 select Handle,CreationDate,ProcessId from Win32_Process where CreationDate = '20101203195242.588801+000' and ProcessId = 8196 Cannot connect ManagementException Out of memory
qcjims
 
Posts: 27
Joined: Wed Sep 02, 2009 7:08 am

Postby Chris Spencer » Sat Dec 04, 2010 12:43 am

Hi

We have a help page dedicated to troubleshooting our various data collection methods. It's worth trying the 'Testing WMI' section for any servers that are getting this problem. This should highlight whether it's a configuration issue or not.
http://www.red-gate.com/supportcenter/C ... 269935.htm

Hope this helps
Chris
Chris Spencer
Test Engineer
Red Gate
Chris Spencer
 
Posts: 301
Joined: Tue Aug 29, 2006 9:09 am
Location: Red Gate - Cambridge

Re: Connection failed (Cannot Connect)

Postby hbuckner » Sat Dec 04, 2010 2:00 pm

What Server OS are you getting theese errors on? Windows Server 2008 R2 has a win32_service memory leak with that error. Look in the server logs and see if you see any wmi exceptions.

I can point you to a Microsoft hotfix if it is the same OS.

qcjims wrote:after some time I start getting these errors:

3 Dec 2010 11:52 AM WMI GetInstances: root\\cimv2 select Name,State,StartMode from Win32_Service Cannot connect COMException

and then monitoring for a server stops.

I also see these errors all the time:

3 Dec 2010 11:52 AM WMI GetInstances: root\\cimv2 select Handle,CreationDate,ProcessId from Win32_Process where CreationDate = '20101203195242.588801+000' and ProcessId = 8196 Cannot connect ManagementException Out of memory
hbuckner
 
Posts: 60
Joined: Fri Jun 16, 2006 6:37 pm

Postby qcjims » Tue Dec 07, 2010 9:50 pm

yes it is win2k8 R2. i'll check for the KB article on the memory leak, but in case I can't find it please post the information you have. thanks.



-js
qcjims
 
Posts: 27
Joined: Wed Sep 02, 2009 7:08 am

Re:

Postby hbuckner » Tue Dec 07, 2010 10:08 pm

Here is a blog on the issue.


http://brooke.blogs.sqlsentry.net/2010/ ... -leak.html

http://blogs.technet.com/b/kevinholman/ ... gents.aspx

Here is the hotfix.

http://support.microsoft.com/kb/981314

qcjims wrote:yes it is win2k8 R2. i'll check for the KB article on the memory leak, but in case I can't find it please post the information you have. thanks.



-js
hbuckner
 
Posts: 60
Joined: Fri Jun 16, 2006 6:37 pm

Postby qcjims » Tue Dec 07, 2010 10:38 pm

THanks Harold.

I grabbed that hotfix and have it applied. We'll see if the error goes away, but it definitely looks to be a match.

I also ran across this WMI memory leak article. http://support.microsoft.com/kb/977357



-js
qcjims
 
Posts: 27
Joined: Wed Sep 02, 2009 7:08 am


Return to SQL Monitor 2

Who is online

Users browsing this forum: No registered users and 0 guests