Post reply

Checkpoint Background Process?

  • April 16, 2013 at 7:57 am

    #292534

    Hi All,

    I'm new to SQL DBA tasks. I noticed in sp_who2 output a database is showing checkpoint as shown below. Is this process hung since it shows date of 03/08/13? I assume checkpoint is a regular automatic process.

    SPIDStatus DBNameCommand CPUTimeDiskIOLastBatch

    13BACKGROUND Micro_ABCHECKPOINT 38618511232962013/03/08 10:43

    Thanks-

    Alison

  • April 16, 2013 at 9:22 pm

    #1607106

    This is a rather long time to see a checkpoint running. Is it possible something BIG happened on that particular day?

    Checkpoints occur (by default) all the time and are trigger by many internal SQL server operations.

    Please check out this article, it might help you understand what is going on - http://msdn.microsoft.com/en-us/library/ms188748(v=sql.100).aspx

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

  • April 17, 2013 at 9:24 am

    #1607299

    I have had checkpoint process running into hours after nightly restores of some reporting databases. We figured that the issue was related to disk performance and it had to be resolved at that level. you can use perfmon to know the disk performance.

Viewing 3 posts - 1 through 2 (of 2 total)

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