Post reply

not sure why DBCC CHECKDB is running

  • July 20, 2014 at 2:21 pm

    #309264

    Hi, I have no maintenance plans scheduled to run.. but I can see dbcc check running on all my users DB's why is that?

    Many thanks

  • July 20, 2014 at 2:24 pm

    #1730877

    How do you see CheckDB running? Do you see it when running Activity Monitor?

    Last time I checked CheckDB does not run on its own, it has to be invoked by someone or some scheduled process.

  • July 20, 2014 at 2:44 pm

    #1730878

    Are you sure that it's CheckDB actually running, not SQL just reporting the last known good checkDB date?

    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

  • July 21, 2014 at 1:07 am

    #1730900

    I had a SQL profile trace running and saw

    DBCC CHECKDB([***MYDBNAME***]) WITH PHYSICAL_ONLY

    Running against all the user created DB's , executed by 'sa'

    Many thanks

  • July 21, 2014 at 1:30 am

    #1730907

    Check the agent for any jobs which have been setup to run CheckDB.

    Do you ever perform CheckDB's on your databases manually?

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

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