Controlling Tempdb Size

The size of my tempdb database is steadily increasing. How can I control its growth?

Tempdb has the auto-grow property set by default. The growth you see signals that SQL Server needs more space allocated to tempdb and is therefore taking it as needed. You can manually configure the maximum size of the database just as you would for another database. You can also turn off the auto-grow property, but Microsoft doesn't recommend this action because some queries could fail if you don't have enough space in tempdb.

Hide comments


  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.