Red Gate forums :: View topic - Connection failed (Cannot Connect)
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Monitor 2
SQL Monitor 2 forum

Connection failed (Cannot Connect)

Search in SQL Monitor 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
qcjims



Joined: 02 Sep 2009
Posts: 27

PostPosted: Fri Dec 03, 2010 8:55 pm    Post subject: Connection failed (Cannot Connect) Reply with quote

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
Back to top
View user's profile Send private message
Chris Spencer



Joined: 29 Aug 2006
Posts: 301
Location: Red Gate - Cambridge

PostPosted: Sat Dec 04, 2010 12:43 am    Post subject: Reply with quote

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/Content.aspx?p=SQL%20Monitor&c=SQL_Monitor/help/2.0/SM_Testing_data_collection.htm&toc=SQL_Monitor/help/2.0/toc1269935.htm

Hope this helps
Chris
_________________
Chris Spencer
Test Engineer
Red Gate
Back to top
View user's profile Send private message
hbuckner



Joined: 16 Jun 2006
Posts: 61

PostPosted: Sat Dec 04, 2010 2:00 pm    Post subject: Re: Connection failed (Cannot Connect) Reply with quote

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
Back to top
View user's profile Send private message
qcjims



Joined: 02 Sep 2009
Posts: 27

PostPosted: Tue Dec 07, 2010 9:50 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
hbuckner



Joined: 16 Jun 2006
Posts: 61

PostPosted: Tue Dec 07, 2010 10:08 pm    Post subject: Re: Reply with quote

Here is a blog on the issue.


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

http://blogs.technet.com/b/kevinholman/archive/2010/06/09/wmi-leaks-memory-on-server-2008-r2-monitored-agents.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
Back to top
View user's profile Send private message
qcjims



Joined: 02 Sep 2009
Posts: 27

PostPosted: Tue Dec 07, 2010 10:38 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group