March 19, 2007 at 12:34 am
I am using ms sql 2005 sp2 64 bit and my problem is that when my application run a Stored Procedure it some times enter a loop that when I run sp_who2 & sp_lcok I see that it use more than one thread and one of them is running and the rest are suspended and it never stop until I kill the session
I need to know why This happen and how to deal with the problem do someone have a clue
March 19, 2007 at 1:16 am
Everytime you see that a SPID is running on multiple threads, it simply means it is using a parallel query plan to execute your command. Parallism is meant to speed up things.
If you think your query/SP would be fine without any parallelism, use MAXDOP hint in your procedure / or set MAX Degree Of Parallelism = 1 at your server level.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply