Optimizing the tempdb database in MS SQL Server

tempdb is a system database in MS SQL Server whose main functions are to store temporary tables, cursors, stored procedures, and other internal objects that are created by the database engine.

By default, the database size is set to 8 MB and it can grow by 10% automatically. In large environments, its size can be as large as 15 GB. It is therefore important to optimize the tempdb database because the location and size of this database can negatively affect the performance of the License Metric Tool server.

For information about how to set the database size and how to determine the optimal number of files, see the TechNet article Optimizing tempdb Performance.