Tag Archives for " Tempdb "

May 03

Alert for Tempdb Growth

By Lori Brown | SQL Administration , SQL Server

Tempdb is a system database used in SQL Server to hold 1) temporary user objects like temp tables and stored procedures, 2) internal objects like work tables used for sorting, and 3) row versions created from data modification transactions. When configuring a new SQL Server, the tempdb should be set to a size that will […]

Jan 11

Inconsistent Tempdb Growth

By Ginger Daniel | SQL Administration , SQL Server , Trace Flags

Tempdb database is a system database that is shared across all databases and all connections in SQL Server. As a general rule, I configure all my client’s servers to have multiple tempdb files with consistent sizes and consistent auto growth set according to best practices. The number of tempdb files created equals the number of […]