Solved

Microsoft SCCM & SQL User Connections

Posted on 2011-03-22
2
771 Views
Last Modified: 2012-05-11
Hello,

I track my SQL Server's active user count, and recently that threshold has passed the 150 mark where I get an alert from, looking at sp_who2 procedure, I can see that that a lot of the processes are in a "sleeping" mode.

Most of our products making use of the SQL Server are Microsoft (SCCM, Windows Update, ForeFront Threat Management, SharePoint etc.). Is there an issue with "sleeping" processes with a "AWAITING_COMMAND" status?

Perhaps a way to avoid them? They look like idle processes, now I know in our OLTP system this is bad news, don't know about SQL RDBMS where its not as highly in transactions.

Any help, tips or guidance on this is appreciated.
51	sleeping                      	VAND1\spsearch	VAN-SP01     	  .	Search_Service_Application_PropertyStoreDB_e3cd02b4c1544741b848f8b010a92f25	AWAITING COMMAND	0	0	03/22/11 14:44	Microsoft SharePoint Foundation                                             
52	sleeping                      	VAND1\spsearch	VAN-SP01     	  .	Search_Service_Application_PropertyStoreDB_e3cd02b4c1544741b848f8b010a92f25	AWAITING COMMAND	0	0	03/22/11 14:44	Microsoft SharePoint Foundation                                             
53	sleeping                      	VAND1\spfarm	VAN-SP01     	  .	Search_Service_Application_PropertyStoreDB_e3cd02b4c1544741b848f8b010a92f25	AWAITING COMMAND	0	0	03/22/11 14:44	Microsoft SharePoint Foundation                                             
54	sleeping                      	VAND1\davla	VAN-DAVLA    	  .	master	AWAITING COMMAND	0	0	03/22/11 14:39	Microsoft SQL Server Management Studio                                      
55	sleeping                      	VAND1\spsearch	VAN-SP01     	  .	WSS_Search_VAN-SP01	AWAITING COMMAND	0	0	03/22/11 14:44	Microsoft SharePoint Foundation                                             
56	sleeping                      	VAND1\spfarm	VAN-SP01     	  .	SharePoint_Config	AWAITING COMMAND	0	0	03/22/11 14:44	.Net SqlClient Data Provider                                                
57	sleeping                      	VAND1\davla	VAN-DAVLA    	  .	FRESHLOOK_DW	AWAITING COMMAND	0	1	03/22/11 9:14	Microsoft SQL Server Management Studio                                      
58	sleeping                      	VAND1\spsearch	VAN-SP01     	  .	Search_Service_Application_PropertyStoreDB_e3cd02b4c1544741b848f8b010a92f25	AWAITING COMMAND	0	0	03/22/11 14:44	Microsoft SharePoint Foundation                                             
59	sleeping                      	VAND1\mirde	VAN-MIRDE    	  .	master	AWAITING COMMAND	15	0	03/22/11 14:44	Microsoft SQL Server Management Studio                                      
60	sleeping                      	VAND1\VAN-SCCM$	VAN-SCCM     	  .	SMS_O01	AWAITING COMMAND	2234	0	02/23/11 16:53	System Center Configuration Manager                                         
61	sleeping                      	VAND1\service	SAC-SERVER01 	  .	SMS_O01	AWAITING COMMAND	0	0	03/22/11 14:43	System Center Configuration Manager                                         
62	sleeping                      	VAND1\davla	VAN-DAVLA-NEW	  .	MarketIntelligence	AWAITING COMMAND	4592	14741	03/21/11 16:36	Microsoft SQL Server Management Studio - Query                              
63	sleeping                      	VAND1\spsearch	VAN-SP01     	  .	Search_Service_Application_CrawlStoreDB_9ffa5dcaf1e7495d8b1c3f45d5753bce	AWAITING COMMAND	0	0	03/22/11 14:43	Microsoft SharePoint Foundation                                             
64	sleeping                      	VAND1\davla	VAN-DAVLA-NEW	  .	master	AWAITING COMMAND	1154	69	03/21/11 14:43	Microsoft SQL Server Management Studio                                      
65	sleeping                      	VAND1\service	VAN-MONITOR  	  .	MCAFEE_EPO4	AWAITING COMMAND	0	0	03/22/11 14:44	Apache HTTP Server                                                          
66	sleeping                      	VAND1\spsearch	VAN-SP01     	  .	Search_Service_Application_PropertyStoreDB_e3cd02b4c1544741b848f8b010a92f25	AWAITING COMMAND	25561	1247	03/22/11 14:26	Microsoft SharePoint Foundation                                             
67	sleeping                      	VAND1\VAN-SCCM$	VAN-SCCM     	  .	SMS_O01	AWAITING COMMAND	0	0	03/22/11 14:44	SMS_CI_ASSIGNMENT_MANAGER                                                   
68	sleeping                      	VAND1\VAN-SCCM$	VAN-SCCM     	  .	SMS_O01	AWAITING COMMAND	0	0	03/22/11 14:43	SMS_CI_ASSIGNMENT_MANAGER                                                   
69	sleeping                      	VAND1\VAN-SCCM$	VAN-SCCM     	  .	SUSDB	AWAITING COMMAND	0	0	03/22/11 14:44	WSUS:wsusservice:28472                                                      
70	sleeping                      	VAND1\SPServices	VAN-SP01     	  .	Managed Metadata Service_85ce4f63bfc547e6b378350e701da95c	AWAITING COMMAND	0	0	03/22/11 14:44	.Net SqlClient Data Provider                                                
71	sleeping                      	VAND1\service	WIL-SERVER01 	  .	SMS_O01	AWAITING COMMAND	0	0	03/22/11 14:44	System Center Configuration Manager                                         
72	sleeping                      	VAND1\service	VAN-MONITOR  	  .	MCAFEE_EPO4	AWAITING COMMAND	210657	16537	03/22/11 14:43	jTDS                                                                        
73	sleeping                      	NT AUTHORITY\NETWORK SERVICE	VAN-SQL02    	  .	msdb	AWAITING COMMAND	328	130	03/22/11 1:30	SQLAgent - Generic Refresher                                                
74	sleeping                      	app_surroundscm	VAN-SCCM     	  .	Surround SCM	AWAITING COMMAND	1221	137	02/23/11 16:50	Seapine Surround SCM                                                        
75	sleeping                      	VAND1\spsearch	VAN-SP01     	  .	WSS_Search_VAN-SP01	AWAITING COMMAND	359	0	03/20/11 18:07	Microsoft SharePoint Foundation                                             
76	sleeping                      	VAND1\VAN-SCCM$	VAN-SCCM     	  .	SMS_O01	AWAITING COMMAND	218	73	03/22/11 14:43	SMS_STATE_SYSTEM                                                            
77	sleeping                      	VAND1\SPServices	VAN-SP01     	  .	Sync DB	AWAITING COMMAND	21530	6047	03/22/11 14:41	Microsoft® Forefront™ Identity Manager 2010                                 
78	sleeping                      	VAND1\VAN-SCCM$	VAN-SCCM     	  .	SMS_O01	AWAITING COMMAND	0	0	02/23/11 17:03	System Center Configuration Manager                                         
79	sleeping                      	VAND1\VAN-SCCM$	VAN-SCCM     	  .	SMS_O01	AWAITING COMMAND	0	0	03/22/11 14:43	SMS Provider                                                                
80	sleeping                      	VAND1\spsearch	VAN-SP01     	  .	WSS_Search_VAN-SP01	AWAITING COMMAND	0	0	03/22/11 14:44	Microsoft SharePoint Foundation                                             
81	sleeping                      	VAND1\VAN-SCCM$	VAN-SCCM     	  .	SMS_O01	AWAITING COMMAND	0	0	03/22/11 14:43	SMS Provider                                                                
82	sleeping                      	VAND1\VAN-SCCM$	VAN-SCCM     	  .	SMS_O01	AWAITING COMMAND	593	126	03/22/11 12:56	SMS Provider                                                                
83	sleeping                      	VAND1\davla	VAN-DAVLA-NEW	  .	MarketIntelligence	AWAITING COMMAND	2734	64	03/21/11 14:51	Microsoft SQL Server Management Studio - Query                              
84	sleeping                      	VAND1\davla	VAN-DAVLA    	  .	master	AWAITING COMMAND	405	106	03/22/11 9:09	Microsoft SQL Server Management Studio                                      
85	sleeping                      	VAND1\service	VAN-MONITOR  	  .	MCAFEE_EPO4	AWAITING COMMAND	209787	17563	03/22/11 14:43	jTDS                                                                        
86	sleeping                      	app_surroundscm	VAN-SCCM     	  .	Surround SCM	AWAITING COMMAND	60874	149231	03/22/11 14:40	Seapine Surround SCM                                                        
87	sleeping                      	VAND1\VAN-SCCM$	VAN-SCCM     	  .	SUSDB	AWAITING COMMAND	0	0	03/22/11 14:44	WSUS:ClientWS:15812                                                         
88	sleeping                      	VAND1\spsearch	VAN-SP01     	  .	WSS_Search_VAN-SP01	AWAITING COMMAND	37244	11790	03/22/11 14:05	Microsoft SharePoint Foundation                                             
89	sleeping                      	VAND1\SPServices	VAN-SP01     	  .	Sync DB	AWAITING COMMAND	0	0	03/22/11 14:44	.Net SqlClient Data Provider                                                
92	sleeping                      	VAND1\davla	VAN-DAVLA    	  .	FRESHLOOK_DW	AWAITING COMMAND	8187	8489	03/22/11 9:15	Microsoft SQL Server Management Studio - Query                              
93	sleeping                      	VAND1\spfarm	VAN-SP01     	  .	Search_Service_Application_DB_0597da6fa9904fc3aecea2ecb967bad4	AWAITING COMMAND	0	0	03/22/11 14:44	Microsoft SharePoint Foundation                                             
94	sleeping                      	VAND1\davla	VAN-DAVLA    	  .	MarketIntelligence	AWAITING COMMAND	640	115	03/22/11 8:43	Microsoft SQL Server Management Studio - Query                              
95	sleeping                      	VAND1\VAN-SCCM$	VAN-SCCM     	  .	SMS_O01	AWAITING COMMAND	0	0	03/22/11 14:44	SMS_COMPONENT_STATUS_SUMMARIZER                                             
96	sleeping                      	VAND1\spsearch	VAN-SP01     	  .	WSS_Search_VAN-SP01	AWAITING COMMAND	423	3	03/20/11 18:07	Microsoft SharePoint Foundation                                             
97	sleeping                      	VAND1\spsearch	VAN-SP01     	  .	WSS_Search_VAN-SP01	AWAITING COMMAND	565	1	03/20/11 18:07	Microsoft SharePoint Foundation                                             
98	sleeping                      	VAND1\VAN-SCCM$	VAN-SCCM     	  .	SMS_O01	AWAITING COMMAND	0	0	02/23/11 16:53	System Center Configuration Manager                                         
99	sleeping                      	VAND1\davla	VAN-DAVLA-NEW	  .	MarketIntelligence	AWAITING COMMAND	189	15	03/15/11 15:41	Microsoft SQL Server Management Studio - Query                              
100	sleeping                      	VAND1\SPServices	VAN-SP01     	  .	Sync DB	AWAITING COMMAND	0	0	02/03/11 10:04	Microsoft® Forefront™ Identity Manager 2010                                 
101	sleeping                      	VAND1\spfarm	VAN-SP01     	  .	WSS_Content	AWAITING COMMAND	0	0	03/22/11 14:44	.Net SqlClient Data Provider                                                
102	sleeping                      	VAND1\spsearch	VAN-SP01     	  .	Search_Service_Application_CrawlStoreDB_9ffa5dcaf1e7495d8b1c3f45d5753bce	AWAITING COMMAND	5424	19	03/22/11 12:56	Microsoft SharePoint Foundation                                             
103	sleeping                      	VAND1\VAN-SCCM$	VAN-SCCM     	  .	SUSDB	AWAITING COMMAND	0	0	03/22/11 14:44	WSUS:SimpleAuthWS:15812                                                     
104	sleeping                      	VAND1\SPServices	VAN-SP01     	  .	Sync DB	AWAITING COMMAND	0	0	02/03/11 10:04	Microsoft® Forefront™ Identity Manager 2010                                 
105	sleeping                      	VAND1\VAN-SCCM$	VAN-SCCM     	  .	SMS_O01	AWAITING COMMAND	31	4	03/22/11 14:44	System Center Configuration Manager                                         
106	sleeping                      	VAND1\service	VIS-SERVER01 	  .	SMS_O01	AWAITING COMMAND	0	0	03/22/11 14:43	System Center Configuration Manager                                         
107	sleeping                      	VAND1\spsearch	VAN-SP01     	  .	WSS_Search_VAN-SP01	AWAITING COMMAND	36966	12177	03/22/11 14:05	Microsoft SharePoint Foundation                                             
108	sleeping                      	VAND1\SPServices	VAN-SP01     	  .	Sync DB	AWAITING COMMAND	361459	125719	03/22/11 14:44	Microsoft® Forefront™ Identity Manager 2010                                 
109	sleeping                      	NT AUTHORITY\NETWORK SERVICE	VAN-SQL02    	  .	msdb	AWAITING COMMAND	9022	6272	03/22/11 14:40	SQLAgent - Job invocation engine                                            
111	sleeping                      	VAND1\spfarm	VAN-SP01     	  .	WSS_Content_SPTest	AWAITING COMMAND	0	0	03/22/11 14:44	.Net SqlClient Data Provider                                                
112	sleeping                      	VAND1\davla	VAN-DAVLA-NEW	  .	FRESHLOOK_DW	AWAITING COMMAND	1625	1466	03/17/11 13:29	Microsoft SQL Server Management Studio - Query                              
113	sleeping                      	VAND1\service	HOU-SERVER01 	  .	SMS_O01	AWAITING COMMAND	0	0	03/22/11 14:43	System Center Configuration Manager                                         
114	sleeping                      	VAND1\VAN-SCCM$	VAN-SCCM     	  .	FEPDW_O01	AWAITING COMMAND	32	4	03/10/11 12:01	.Net SqlClient Data Provider                                                
115	sleeping                      	VAND1\spsearch	VAN-SP01     	  .	Search_Service_Application_CrawlStoreDB_9ffa5dcaf1e7495d8b1c3f45d5753bce	AWAITING COMMAND	5856	25	03/22/11 14:28	Microsoft SharePoint Foundation                                             
116	sleeping                      	app_surroundscm	VAN-SCCM     	  .	Seapine Licensing	AWAITING COMMAND	20035	206	03/22/11 14:43	Seapine License Server                                                      
117	sleeping                      	VAND1\davla	VAN-DAVLA    	  .	FRESHLOOK_DW	AWAITING COMMAND	156	14	03/22/11 9:09	Microsoft SQL Server Management Studio                                      
118	sleeping                      	VAND1\VAN-SCCM$	VAN-SCCM     	  .	SMS_O01	AWAITING COMMAND	0	0	03/22/11 14:43	SMS Provider                                                                
119	sleeping                      	VAND1\VAN-SCCM$	VAN-SCCM     	  .	SMS_O01	AWAITING COMMAND	1484	0	02/23/11 16:59	System Center Configuration Manager                                         
120	sleeping                      	VAND1\VAN-SCCM$	VAN-SCCM     	  .	SMS_O01	AWAITING COMMAND	0	0	03/22/11 14:44	System Center Configuration Manager                                         
121	sleeping                      	VAND1\spfarm	VAN-SP01     	  .	WSS_Content_Wiki	AWAITING COMMAND	0	0	03/22/11 14:44	.Net SqlClient Data Provider                                                
122	sleeping                      	VAND1\davla	VAN-DAVLA-NEW	  .	FRESHLOOK_DW	AWAITING COMMAND	0	0	03/17/11 13:26	Microsoft SQL Server Management Studio - Query                              
123	sleeping                      	VAND1\spfarm	VAN-SP01     	  .	WSS_Logging	AWAITING COMMAND	15	0	03/22/11 14:43	.Net SqlClient Data Provider                                                
124	sleeping                      	VAND1\SPServices	VAN-SP01     	  .	Sync DB	AWAITING COMMAND	0	0	02/03/11 10:04	Microsoft® Forefront™ Identity Manager 2010                                 
125	sleeping                      	VAND1\service	VAN-SQL02    	  .	SQL_Stats	AWAITING COMMAND	17328	3259	03/22/11 13:46	Microsoft SQL Server Analysis Services                                      
126	sleeping                      	VAND1\spfarm	VAN-SP01     	  .	Profile DB	AWAITING COMMAND	0	0	03/22/11 14:40	.Net SqlClient Data Provider                                                
127	sleeping                      	VAND1\SPServices	VAN-SP01     	  .	Sync DB	AWAITING COMMAND	0	0	02/03/11 10:04	Microsoft® Forefront™ Identity Manager 2010                                 
128	sleeping                      	VAND1\VAN-SCCM$	VAN-SCCM     	  .	SMS_O01	AWAITING COMMAND	0	0	02/23/11 16:59	SMS Provider                                                                
130	sleeping                      	NT AUTHORITY\NETWORK SERVICE	VAN-SQL02    	  .	ReportServer	AWAITING COMMAND	0	0	03/22/11 14:44	Report Server                                                               
131	sleeping                      	app_surroundscm	VAN-SCCM     	  .	Surround SCM	AWAITING COMMAND	51938	147894	03/22/11 14:40	Seapine Surround SCM                                                        
132	sleeping                      	VAND1\davla	VAN-DAVLA    	  .	FRESHLOOK_DW	AWAITING COMMAND	1249	2348	03/22/11 9:14	Microsoft SQL Server Management Studio - Query                              
133	sleeping                      	VAND1\VAN-SCCM$	VAN-SCCM     	  .	SMS_O01	AWAITING COMMAND	0	0	03/22/11 14:44	SMS_STATE_SYSTEM                                                            
136	sleeping                      	VAND1\VAN-SCCM$	VAN-SCCM     	  .	SMS_O01	AWAITING COMMAND	0	0	03/22/11 14:44	System Center Configuration Manager                                         
137	sleeping                      	VAND1\spsearch	VAN-SP01     	  .	WSS_Search_VAN-SP01	AWAITING COMMAND	732	2	03/20/11 18:07	Microsoft SharePoint Foundation                                             
138	sleeping                      	VAND1\service	VAN-MONITOR  	  .	MCAFEE_EPO4	AWAITING COMMAND	136353	11730	03/22/11 14:44	jTDS                                                                        
140	sleeping                      	VAND1\VAN-SCCM$	VAN-SCCM     	  .	SMS_O01	AWAITING COMMAND	281	0	03/22/11 14:40	SMS_OBJECT_REPLICATION_MANAGER                                              
141	sleeping                      	VAND1\davla	VAN-DAVLA-NEW	  .	FRESHLOOK_DW	AWAITING COMMAND	11328	0	03/17/11 14:52	Microsoft SQL Server Management Studio - Query                              
142	sleeping                      	VAND1\SPServices	VAN-SP01     	  .	Sync DB	AWAITING COMMAND	0	0	02/03/11 10:04	Microsoft® Forefront™ Identity Manager 2010                                 
143	sleeping                      	app_surroundscm	VAN-SCCM     	  .	Surround SCM	AWAITING COMMAND	13754	397	03/22/11 14:40	Seapine Surround SCM                                                        
144	sleeping                      	VAND1\spfarm	VAN-SP01     	  .	SharePoint_Config	AWAITING COMMAND	0	0	03/22/11 14:40	.Net SqlClient Data Provider                                                
145	sleeping                      	VAND1\VAN-SCCM$	VAN-SCCM     	  .	SUSDB	AWAITING COMMAND	0	0	03/22/11 14:43	WSUS:wsusservice:28472                                                      
146	sleeping                      	VAND1\davla	VAN-DAVLA-NEW	  .	FRESHLOOK_DW	AWAITING COMMAND	39454	8224	03/17/11 14:10	Microsoft SQL Server Management Studio - Query                              
147	sleeping                      	VAND1\davla	VAN-DAVLA-NEW	  .	FRESHLOOK_DW	AWAITING COMMAND	859	709	03/17/11 13:31	Microsoft SQL Server Management Studio - Query                              
148	sleeping                      	VAND1\service	MAN-SERVER01 	  .	SMS_O01	AWAITING COMMAND	0	1	03/22/11 14:43	System Center Configuration Manager                                         
150	sleeping                      	VAND1\spfarm	VAN-SP01     	  .	SharePoint_Config	AWAITING COMMAND	0	0	03/22/11 14:44	.Net SqlClient Data Provider                                                
151	sleeping                      	VAND1\service	VAN-MONITOR  	  .	MCAFEE_EPO4	AWAITING COMMAND	226215	22255	03/22/11 14:43	jTDS                                                                        
152	sleeping                      	VAND1\davla	VAN-DAVLA    	  .	FRESHLOOK_DW	AWAITING COMMAND	203	464	03/22/11 10:35	Microsoft SQL Server Management Studio - Query                              
154	sleeping                      	VAND1\VAN-SCCM$	VAN-SCCM     	  .	SMS_O01	AWAITING COMMAND	360	456	03/22/11 14:44	System Center Configuration Manager                                         
157	sleeping                      	VAND1\spsearch	VAN-SP01     	  .	WSS_Search_VAN-SP01	AWAITING COMMAND	343	1	03/20/11 18:07	Microsoft SharePoint Foundation                                             
158	sleeping                      	VAND1\VAN-SCCM$	VAN-SCCM     	  .	SMS_O01	AWAITING COMMAND	0	0	03/22/11 14:44	SMS_CI_ASSIGNMENT_MANAGER                                                   
161	sleeping                      	VAND1\VAN-SCCM$	VAN-SCCM     	  .	SMS_O01	AWAITING COMMAND	0	0	03/22/11 14:44	SMS_CI_ASSIGNMENT_MANAGER                                                   
164	sleeping                      	app_surroundscm	VAN-SCCM     	  .	Surround SCM	AWAITING COMMAND	5598	37	03/22/11 14:40	Seapine Surround SCM                                                        
167	sleeping                      	VAND1\VAN-SCCM$	VAN-SCCM     	  .	SUSDB	AWAITING COMMAND	0	0	03/22/11 14:44	WSUS:ApiRemotingWS:15812                                                    
168	sleeping                      	VAND1\SPServices	VAN-SP01     	  .	Profile DB	AWAITING COMMAND	0	0	03/22/11 14:44	.Net SqlClient Data Provider                                                
169	sleeping                      	VAND1\spsearch	VAN-SP01     	  .	WSS_Search_VAN-SP01	AWAITING COMMAND	24928	4132	03/22/11 14:05	Microsoft SharePoint Foundation                                             
170	sleeping                      	VAND1\VAN-SCCM$	VAN-SCCM     	  .	SUSDB	AWAITING COMMAND	0	0	03/22/11 14:44	WSUS:ReportingWS:15812                                                      
171	sleeping                      	VAND1\service	VAN-MONITOR  	  .	MCAFEE_EPO4	AWAITING COMMAND	112373	10455	03/22/11 14:43	jTDS                                                                        
173	sleeping                      	VAND1\VAN-SCCM$	VAN-SCCM     	  .	SUSDB	AWAITING COMMAND	0	0	03/22/11 14:44	WSUS:ServerSyncWS:15812                                                     
175	sleeping                      	VAND1\VAN-SCCM$	VAN-SCCM     	  .	FEPDW_O01	AWAITING COMMAND	0	0	03/22/11 14:43	.Net SqlClient Data Provider                                                
176	sleeping                      	VAND1\service	VAN-MONITOR  	  .	MCAFEE_EPO4	AWAITING COMMAND	119866	16156	03/22/11 14:43	jTDS                                                                        
178	sleeping                      	VAND1\VAN-SCCM$	VAN-SCCM     	  .	SMS_O01	AWAITING COMMAND	0	0	03/22/11 14:44	SMS_CI_ASSIGNMENT_MANAGER                                                   
179	sleeping                      	VAND1\VAN-SCCM$	VAN-SCCM     	  .	SMS_O01	AWAITING COMMAND	0	0	03/22/11 14:44	System Center Configuration Manager                                         
181	sleeping                      	VAND1\VAN-SCCM$	VAN-SCCM     	  .	SMS_O01	AWAITING COMMAND	0	0	03/22/11 14:44	SMS_COMPONENT_STATUS_SUMMARIZER                                             
184	sleeping                      	VAND1\spfarm	VAN-SP01     	  .	SharePoint_AdminContent_2c5eed27-a283-40cb-8bff-e81a36c2ce3a	AWAITING COMMAND	0	0	03/22/11 14:44	.Net SqlClient Data Provider                                                
187	sleeping                      	NT AUTHORITY\NETWORK SERVICE	VAN-SQL02    	  .	ReportServer	AWAITING COMMAND	0	0	03/22/11 14:44	Report Server                                                               
188	sleeping                      	VAND1\spsearch	VAN-SP01     	  .	Search_Service_Application_DB_0597da6fa9904fc3aecea2ecb967bad4	AWAITING COMMAND	0	0	03/22/11 14:44	Microsoft SharePoint Foundation                                             
189	sleeping                      	VAND1\VAN-SCCM$	VAN-SCCM     	  .	SMS_O01	AWAITING COMMAND	0	0	03/22/11 14:44	System Center Configuration Manager                                         
192	sleeping                      	VAND1\SPServices	VAN-SP01     	  .	WebAnalyticsServiceApplication_StagingDB	AWAITING COMMAND	0	0	03/22/11 14:40	.Net SqlClient Data Provider                                                
193	sleeping                      	VAND1\spfarm	VAN-SP01     	  .	Search_Service_Application_CrawlStoreDB_9ffa5dcaf1e7495d8b1c3f45d5753bce	AWAITING COMMAND	47	0	03/22/11 14:40	.Net SqlClient Data Provider                                                
194	sleeping                      	VAND1\spsearch	VAN-SP01     	  .	Search_Service_Application_DB_0597da6fa9904fc3aecea2ecb967bad4	AWAITING COMMAND	0	0	03/22/11 14:44	Microsoft SharePoint Foundation                                             
195	sleeping                      	VAND1\VAN-SCCM$	VAN-SCCM     	  .	SMS_O01	AWAITING COMMAND	179295	42687	03/22/11 14:44	SMS_STATUS_MANAGER                                                          
196	sleeping                      	VAND1\spfarm	VAN-SP01     	  .	SharePoint_Config	AWAITING COMMAND	0	0	03/22/11 14:44	.Net SqlClient Data Provider                                                
197	sleeping                      	VAND1\SPServices	VAN-SP01     	  .	WebAnalyticsServiceApplication_StagingDB	AWAITING COMMAND	0	0	03/22/11 14:40	.Net SqlClient Data Provider                                                
200	sleeping                      	VAND1\spfarm	VAN-SP01     	  .	Search_Service_Application_PropertyStoreDB_e3cd02b4c1544741b848f8b010a92f25	AWAITING COMMAND	0	0	03/22/11 14:44	OSearch14 Query Processor - Application afc6e43e-2fa2-4f18-a8df-b658d1442dca
201	sleeping                      	VAND1\spfarm	VAN-SP01     	  .	Search_Service_Application_DB_0597da6fa9904fc3aecea2ecb967bad4	AWAITING COMMAND	0	0	03/22/11 14:44	OSearch14 Query Processor - Application afc6e43e-2fa2-4f18-a8df-b658d1442dca
205	sleeping                      	VAND1\spfarm	VAN-SP01     	  .	Search_Service_Application_DB_0597da6fa9904fc3aecea2ecb967bad4	AWAITING COMMAND	0	0	03/22/11 14:44	.Net SqlClient Data Provider                                                
210	sleeping                      	VAND1\spfarm	VAN-SP01     	  .	WSS_Content_MySite	AWAITING COMMAND	0	0	03/22/11 14:44	.Net SqlClient Data Provider

Open in new window

0
Comment
Question by:mirde
2 Comments
 
LVL 8

Accepted Solution

by:
Kobe_Lenjou earned 500 total points
ID: 35197129
Nothing to worry about in fact.

If you want to avoid this kind, you'll have to do that on the application side, starting less threats/processes/..

but for SQL server itself there is no real issue here.
0
 

Author Comment

by:mirde
ID: 35200332
Thanks for the info, seeing as these are proprietary Microsoft applications making use of SQL Server there is no real way to change the application and being able to still get support from Microsoft.

My choice I think in this case is just to accommodate with the resource.
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now