SQL SP under two same processing ID takes very slow
I have one SP (store prodecure) in my sql 2000 that will not respond thru vb.net application. The SP was under two of same Processing ID in Last TSQL Command Batch. I killed both and restart Application then worked. How to avoid this problem?