InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 22:06:32 GMT20http://www.sqlservercentral.com/Forums/Topic1409257-1550-1.aspxas you will know Tempdb is a special db, available and used by everyone in the instance.General usage of tempdb: [url]http://msdn.microsoft.com/en-us/library/ms190768.aspx[/url]Great post by Gail Shaw which highlights indexing and how operations spill data to tempdb[url]http://sqlinthewild.co.za/index.php/2011/11/07/sql-university-advanced-indexing-sorting-and-grouping/[/url]another nice usage article : [url]http://www.databasejournal.com/features/mssql/tempdb-space-usage-in-sql-server.html[/url]Mon, 21 Jan 2013 01:50:14 GMTALZDBAhttp://www.sqlservercentral.com/Forums/Topic1409257-1550-1.aspx[quote]We don't usually do the manul checkpoint command. SO what else make it to write to disk and cause tempdb space grow?Thanks[/quote]As I wrote in the previous message - Lazywriter will also write TempDB's data to the disk.AdiSun, 20 Jan 2013 22:34:52 GMTAdi Cohn-120898http://www.sqlservercentral.com/Forums/Topic1409257-1550-1.aspx[quote][b]Adi Cohn-120898 (1/20/2013)[/b][hr]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[/quote]We don't usually do the manul checkpoint command. SO what else make it to write to disk and cause tempdb space grow?ThanksSun, 20 Jan 2013 17:31:32 GMTsqlfriendshttp://www.sqlservercentral.com/Forums/Topic1409257-1550-1.aspx[quote][b]ALZDBA (1/20/2013)[/b][hr]it will write tempdb stuff to disk all right, it's just not at checkpoint time, like with regular db.Why: tempdb is re-created every time SQLServer is started, so there is no need with respect to recovery of db.(which is the need with regular db)[/quote]I understand the Why: statement above you mentioned,But i am not sure what it means: when you say it will wirte tempdb stuff to disk all right.Sun, 20 Jan 2013 17:29:44 GMTsqlfriendshttp://www.sqlservercentral.com/Forums/Topic1409257-1550-1.aspxThe 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. AdiSun, 20 Jan 2013 08:21:18 GMTAdi Cohn-120898http://www.sqlservercentral.com/Forums/Topic1409257-1550-1.aspxit will write tempdb stuff to disk all right, it's just not at checkpoint time, like with regular db.Why: tempdb is re-created every time SQLServer is started, so there is no need with respect to recovery of db.(which is the need with regular db)Sun, 20 Jan 2013 06:28:43 GMTALZDBAhttp://www.sqlservercentral.com/Forums/Topic1409257-1550-1.aspxI am reading a tutorial of Randal Paul that says, Checkpoints don't flush tempdb data to disk. Log records are not flushed to disk on transaction commit. Tempdb data pages and log buffers are not written to disk.But how can I explain our tempdb .mdf and PDF files keep getting bigger.ThanksSat, 19 Jan 2013 23:20:57 GMTsqlfriends