March 13, 2006 at 10:33 am
Has anyone seen the same process id appearing mutiple times in process info?
What is causing this? When I look at the details all 5, they have the same SQL statement. Each one is pointing to an Improptu as the application.
March 13, 2006 at 11:18 am
Since sql server 2000 servicepack 4 you can see duplicates of processid, it has to do with parallel processing.
March 13, 2006 at 12:16 pm
this server is still running servicepack 3.
March 13, 2006 at 12:36 pm
is due to parallelism - may or may not be a problem - depends if you have lots of cxpacket waits.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply