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.