Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Server process ID's

Status
Not open for further replies.

williamkremer

Programmer
Oct 27, 2005
61
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
 
Will do - Thanks Denis

"You cannot hold a torch to another man's path without brightening your own"
Best regards,
Bill
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top