If you are using Win 2003 32 bits with Sql Server 2005 32 bits AND the bigger wait type is "RESOURCE_SEMAPHORE_QUERY_COMPILER" in a multi processor machine, don´t loose your time:...