Re-Post - Process Information

Dear All,
Under Managment/Current Activity/Process Info you can see
all the users with connections to the system.
Here is the problem. A couple of users seem to have
multiple (10 or more) process ID's, all of them sleeping.
After a chat with them they said they were not in the
application, but the process was still being displayed.
My questions are then, should I be concerned, and why
aren't they closing automatically ?
Thanks
Peter
> Dear All,
> Under Managment/Current Activity/Process Info you can see
> all the users with connections to the system.
> Here is the problem. A couple of users seem to have
> multiple (10 or more) process ID's, all of them sleeping.
> After a chat with them they said they were not in the
> application, but the process was still being displayed.
> My questions are then, should I be concerned, and why
> aren't they closing automatically ?
> Thanks
> Peter
Hi Peter,
It is possible that they are orphaned processes. Checkout this article:
INF: How to Troubleshoot Orphaned Connections in SQL Server
http://support.microsoft.com/?id=137983
Hope this helps,
Eric Crdenas
SQL Server senior support professional