Home Forums SQL Server 2005 SQL Server 2005 Performance Tuning Server becomes very slow [RESOURCE_SEMAPHORE] waittype. RE: Server becomes very slow [RESOURCE_SEMAPHORE] waittype.

  • September 4, 2008 at 11:26 am

    #867305

    Can you check your error log? Do you have any error messages stating "insufficient memory"?

    Also, just from curiosity: why are using SP1?