SQL Server Performance

Controlling how you write to tempdb

Discussion in 'General DBA Questions' started by Trev256, Nov 18, 2009.

  1. Trev256 New Member

    Hi - I found out that you can write to the tempdb - but even if you have a tempdb of 5GB and only 2MB is used then the tempdb might grow when you write to it because the OS will not control where in the tempdb you write - i.e. it may write at the end of the unallocated spcae and force the tempdb to grow even if it doesn't need to. How can this be controlled to prevent the tempdb from gorwing too quickly???
  2. satya Moderator

  3. Trev256 New Member

    What do you mean 'implicit temp tables '?
  4. atulmar New Member

    Implicit tables are created in tempdb by SQL server for storing the data intermediately from complex or large queries.
  5. Trev256 New Member

    thanks - looks like you had a sunny day for a day trip in your pic!

Share This Page