TempDB Size

Issue description

This check determines whether TempDB database disk space is allocated properly.

Explanation

SharePoint Server uses SQL Server to store configuration and user data. SQL Server stores data over various file types. The TempDB system database is a global resource that is available to all users connected to the instance of SQL Server. It is used to hold the following:

  • Temporary user objects that are explicitly created, such as global or local temporary tables, temporary stored procedures, table variables, or cursors.
  • Internal objects that are created by the SQL Server Database Engine, for example, work tables to store intermediate results for spools or sorting.
  • Row versions that are generated by data modification transactions in a database that uses read-committed row versioning isolation or snapshot isolation transactions.
  • Row versions that are generated by data modification transactions for features, such as online index operations, Multiple Active Result Sets (MARS), and AFTER triggers.

The size of the TempDB should be at least 10% of the largest content database in the farm.

Solution

Check the database file disk space allocation. To do so, open the SQL Server Manager on the database server and check properties for every database. The page File in the Properties window contains the information about physical location of the database files. In case you need to move the database files to another drive or server, please read the articles referenced in the Additional information section.

Additional information

Additional information can be found in the following articles: