Server process ID's

[williamkremer]

We have a CRM that connects to SQL server and has been administered haphazardly in the past. There are almost 50 SPID's and it's not possible to tell who is the user in most cases (the owner is Sess and Lock type = DB, Mode = S and Status = Grant) They mostly have the same "last TSQL Batch command" Is this having a negative effect on performance? can/should some be deleted? Are they actually causing locks to occur? I'm afraid to Kill, when I don't know who/why so many SPID's. And I can't find the answers exactly in BOL. Thanks in advance!

"You cannot hold a torch to another man's path without brightening your own"
Best regards,
Bill

 

[SQLDenis]

everything below 51 is used by SQL server so don't kill those

run sp_who2 and look in the BlkBy field for any blocking

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[williamkremer]

Will do - Thanks Denis

"You cannot hold a torch to another man's path without brightening your own"
Best regards,
Bill