Post reply

Checkpoint Background Process

  • April 16, 2013 at 10:15 am

    #271075

    Hi All,

    I'm new to SQL DBA tasks. I noticed in sp_who2 output a database is showing checkpoint as shown below. I had the transaction log fill up for this database and didn't understand why the log would not clear out even though it is running trans log backups.

    Is this process hung since output shows date of 03/08/13? I assume checkpoint is a regular automatic process.

    SPID Status DBName Command CPUTime DiskIO LastBatch

    13 BACKGROUND Micro_AB CHECKPOINT 3861851 123296 2013/03/08 10:43

    Thanks-

    Alison

  • April 16, 2013 at 10:29 am

    #1606908

    Please, do not cross post as it will only fragment any responses you may receive.

    Duplicate post, please post all responses here.

  • April 16, 2013 at 10:54 am

    #1606922

    Sorry I saw there was Newbie section and thought it was better to pose the question in this forum.

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

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