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:44 am

    #867318

    Glen Sidelnikov (9/4/2008)

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

    Also, just from curiosity: why are using SP1?

    Error log is clean, no messages about "insufficient memory".

    As for SP1, we had problems with our erp software with SP2, so we reverted back to SP1 + hotfixes.