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
"You cannot hold a torch to another man's path without brightening your own"
Best regards,
Bill