Home Forums SQL Server 2005 SQL Server 2005 General Discussion 95 GB Transaction Log but Log Backups are much smaller RE: 95 GB Transaction Log but Log Backups are much smaller

  • April 9, 2014 at 8:34 am

    #1704540

    Hope this won't look too garbled. sp_who2 shows a bunch of processes from 10/18. Checking the sql error log, I see that was after a server restart on the same day. The server has been restarted once since then (2/24), but I do not see any processes with that date.

    Would the CHECKPOINT in this list be significant?

    DBNameCommandCPUTimeDiskIOLastBatch

    NULLRESOURCE MONITOR639401010/18/2014 0:18

    NULLXE DISPATCHER 2730010/18/2014 0:18

    NULLXE TIMER 5865010/18/2014 0:18

    NULLLOG WRITER 6666765010/18/2014 0:18

    NULLLAZY WRITER 4931300010/18/2014 0:18

    masterSIGNAL HANDLER 0010/18/2014 0:18

    NULLLOCK MONITOR 842499010/18/2014 0:18

    masterTASK MANAGER 0010/18/2014 0:18

    masterTRACE QUEUE TASK101743010/18/2014 0:18

    masterBRKR TASK 363123110/18/2014 0:18

    masterCHECKPOINT 755857443803907210/18/2014 0:18

    masterTASK MANAGER 0010/18/2014 0:18

    masterBRKR EVENT HNDLR07410/18/2014 0:18

    masterBRKR TASK 0010/18/2014 0:18

    masterBRKR TASK 0010/18/2014 0:18

    masterTASK MANAGER 03310/18/2014 0:18

    masterTASK MANAGER 058410/18/2014 0:18

    masterTASK MANAGER 0757810/18/2014 0:18

    masterTASK MANAGER 0597810/18/2014 0:18

    masterTASK MANAGER 029510/18/2014 0:18

    masterTASK MANAGER 034510/18/2014 0:18

    masterTASK MANAGER 015910/18/2014 0:18

    masterTASK MANAGER 066410/18/2014 0:18

    masterTASK MANAGER 0322010/18/2014 0:18