#tempdb

Want access to all our free webinars? Become a free member at SQLMaestros.com and access all the free webinars. source

In this video we will be answering SQL Server DBA interview Question ” What are the best practice to configure TempDB in SQL … source

Introduction Have you ever wondered what goes on behind the scenes when you run a query in SQL Server? One key piece of the puzzle is the tempdb system database. In this article, we’ll take a peek under the hood to understand how and why SQL Server allocates space in tempdb during query execution. We’ll also explore how enabling read committed snapshot isolation (RCSI) affects tempdb size. By…

It’s all about TempDB

Temporary user objects that are specifically created are stored in the tempdb system database, which is a global resource. They consist of temporary stored procedures, global or local temporary tables and indexes, table variables, tables returned in table-valued functions, and cursors. It only has a lifespan equal to the length of a SQL Server session. When compared to other databases, Tempdb’s…

SQL Server Temporary Tables

This article by “Phil Factor” is a useful description of how to use the Temp Database in SQL Server, with a lot of detail on using temporary tables.

You should read this to better understand the TempDB in SQL Server.

-- Find out who created the temporary table,and when; the culprit and…

Shrinking Tempdb in SQL Server won’t work?

Problem statement

When I was working DML operation on the database, Tempdb has grown  80 GB. After the completion, It is noted that the tempdb has grown significantly larger and I didn’t have much space on this Server. I tried shrinking the mdf file of tempdb. It executes successfully but no space is released to OS. Is restarting the SQL Server the only way to release the space. Can you please…

Importance of Performing DBCC CHECKDB

You absolutely need to be performing a DBCC CHECKDB on all of your databases on a regular schedule. This includes the system databases. One example is Model database corruption leading to a TempDB issue, because the TempDB is created using the Model Database.

In this article by Simon Liew we get a better understanding of the potential issues by example.

The scenario starts with a perfectly…

There are specific tasks you must be prepared to perform to get the best possible performance from your TempDB on your SQL Server instance. I have written about ways to get peak performance from your TempDB before. In this article by Dieter Gobeyn we hear him repeat some of these same tips.

1. Split files according number of CPUs

To fine-tune your tempdb’s performance, you first need to create…