How do I clear data from TempDB?
Answer Question | October 17, 2012 7:59 AM
SQL Server, TempDB
The issue goes as follows, Tempdb size generally remains around 3GB. One day it starts increasing and acquires the whole of the empty disk space of 29 GB within 15 hours. How can we avoid such kind of situations from happening in future? Any specific reason for such thing to happen? Also the .LDF file [...]
Answer Question | November 4, 2011 11:59 AM
Disk space, LDF file size, SIMPLE RECOVERY model, TempDB, Tempdb Size
I have a user running a SAS job that kicks tempdb from 8.5M to 6.6Gig in less than ten minutes. tempdb is on the default C: partition, which is only 16G (I have no control over that ridiculous size)! I’m new at this so I’m thinking my only option is to MOVE tempdb because of [...]
Answer Question | September 11, 2009 2:22 PM
SQL Server, SQL Server 2005, TempDB
Database – MS Sql Server How to estimate the amount of space that a query uses in tempdb? I am trying to join certain transaction tables that are really huge – about 300GB. Is there a way I can compute the space that the query might take in tempdb based on factors like: 1. Columns [...]
Answer Question | August 3, 2009 7:46 PM
Space allocation, SQL Server, SQL Server Data Storage, TempDB
I’ve heard it recommended to place the tempdb on its on own drive. Regarding the tempdb log file specifically, should it be on a different disk than the mdf or ndf files of the tempdb?
Answer Question | April 13, 2009 6:11 PM
MDF, NDF, SQL Server, TempDB