Home Forums SQL Server 2008 SQL Server 2008 Administration Tempdb and disk RE: Tempdb and disk

  • January 20, 2013 at 5:31 pm

    #1579065

    Adi Cohn-120898 (1/20/2013)

    The automatic checkpoint that SQL Server issues is not the only mechanism that writes the data into the disk. If you issue manual checkpoint command, it will write the TempDB's data to the disk. When Lazywriter writes the data to the disk it will also write the TempDB's data.

    Adi

    We don't usually do the manul checkpoint command.

    SO what else make it to write to disk and cause tempdb space grow?

    Thanks