Post reply

Integrity Check hung on RESOURCE_SEMAPHORE wait

  • January 31, 2014 at 9:39 am

    #303970

    Hi,

    I have a server running Microsoft SQL Server 2008 R2 SP2 Standard Edition (64-bit). Whenever I attempt to run a dbcc checkdb the query waits indefinitely on RESOURCE_SEMAPHORE. I can cancel the integrity check and immediately execute full backups without an issue. Has anyone seen this?

  • January 31, 2014 at 9:45 am

    #1685129

    'indefinitely' how long have you left it? How busy is the server?

    Resource Semaphore is a wait for memory grants. (also see this: http://www.sqlskills.com/blogs/jonathan/dbcc-checkdb-execution-memory-grants-not-quite-what-you-expect/)

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • January 31, 2014 at 9:58 am

    #1685133

    It sat for 13+ hours. I don't have trended info on how busy this particular server is yet.

  • January 31, 2014 at 10:09 am

    #1685137

    Try rescheduling for a quieter time, check the link I posted about CheckDB's memory grants and check the server in general for resource contention (execution grants)

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • January 31, 2014 at 10:39 am

    #1685145

    Thanks for that link, it's really interesting. The DBCC in question that was hung was master, and iirc it was on checktable.

    I haven't tried with any others yet.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply