tempdb

How to Resize tempdb

  • Article

When you are setting up a new SQL Server machine you need to determine how big you should make tempdb. To make sure you size tempdb appropriately you should monitor the tempdb space usage. If there are autogrowth events occurring after you have recycled SQL Server than you might want to increase the size of your tempdb data files. If tempdb never uses most of the tempdb space, then you might want to consider decreasing the size of tempdb.

2018-08-21

4,154 reads

Blogs

Creating a New Sequence–#SQLNewBlogger

By

I wrote about sequences in an editorial recently and decided to start using them....

An All Star Lineup for EightKB

By

An online conference is coming on June 17, 2020 that is full of high...

How should I store currency values in SQL Server?

By

On Twitter, Michael Dyrynda writes: ?? Never ever ever ever ever ever ever ever...

Read the latest Blogs

Forums

Explanation of Page Splits

By stevec883

Q1 -- I have read quite a few articles on page splits and am...

(duplicate)

By stevec883

(sorry, this was a duplicate)

Script error

By sizal0234

I am trying to monitor the sql services on couple of instances and found...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers