SQL Server Performance

localize CXPACKET waittype

Discussion in 'SQL Server 2008 T-SQL Performance Tuning' started by dropout, Jul 29, 2009.

  1. dropout New Member

    Hi all,
    Thru sys.dm_os_wait_stats I can see that I have a fair amout of CXPACKET wait-time. A possible solution might be to reduce the degree of parallelisme. But before I do this, I would like to know, which stored procedure is causing this wait-time.
    I think it makes no sense to reduce parallelisme for the hole server if I could use the maxdop setting to cure the (maybe) few problematic procedures.
    Is this a reasonable approach?
    How do I find out, which stored procedure I should optimize? Is there another DMV, that might help?
    Thx a lot
    Reto E.
  2. MohammedU New Member

  3. dropout New Member

    Thx. This was very helpful.

Share This Page