During testing we have discovered a potential bug in SQL Server 2017 when using the TEMP DB table. Under sustained load in the tempDB for 12 hours the performance gradually degrades. This tool is able ...

I have a SQL 2000 SP4 server and MOM 2005 is reporting that the tempdb database log file is getting to large. Sure enough, it the templog.ldf file is a little over 9GB in size.<BR><BR>I honestly don't ...

Part of the SQL Server 2022 blog series. The main difference between tempdb and other databases is the workload. With tempdb we are constantly creating and destroying objects such as temp tables. This ...

SUM (user_object_reserved_page_count)*8 as user_obj_kb, SUM (internal_object_reserved_page_count)*8 as internal_obj_kb, SUM (version_store_reserved_page_count)*8 as ...

If your application uses the tempdb database a lot, and causes it to grow larger than its default size, you may want to permanently increase the default size of the tempdb file to a size closer to ...

Abstract: This article discusses the TempDB service object in a relational database management system (RDBMS). The TempDB object is designed to temporarily store information and improve system ...