Post reply

Parrallel Sort is slowing down

  • January 22, 2003 at 8:13 am

    #58981

    I have a query running on SQL 7 SP4. This query has some sorting and not very complicated query. Used to run fine. Now all of a sudden it takes like 50 times more than what it should take to run. I checked the executtion plan and it uses parrallel sort.

    I checked current activity in EM and I got CXPACKET and EXCHANGE locks for this process. Microsfot says it was a bug in 7.0 and should have been resolved in SP2. I have SP4 applied to it. When I run same query on 2000 server takes only 5 seconds.

    Does anyone know how to solve this?

    Thanks.

  • January 24, 2003 at 2:32 pm

    #447204

    trying one more time!

    Anyone have any ideas?

    Thanks for your help.

  • January 24, 2003 at 3:01 pm

    #447206

    Any configuration changed to 'max degree of parallelism' recently?

  • January 24, 2003 at 3:18 pm

    #447209

    No. But since we were having this problems, we changed settings to 'number of processors to be used by parrallel query" from 4 processor to 1 and it works fine, But I don't think it's a good idea to keep it like that. Also Cost estimate factor for Parralel query is 5.

    Is this set propoerly?

    Thanks.

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply