Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Express Edition and Compact Edition (2005)
 ProcessID

Author  Topic 

sqlsantha
Starting Member

3 Posts

Posted - 2009-07-07 : 05:30:21

Hi EveryBody,

What is that Process that I am seeing in Activity Monitor, whether a Process can have n number of connections at a time?

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2009-07-07 : 06:50:07
Do a DBCC Inputbuffer(<SPID>) on the process to find out what it is doing. If the process number is low (< 30), it is generally a system process.
Go to Top of Page
   

- Advertisement -