Tempdb

SQL Server 2012 Cluster with TempDB on Local Disk

With the introduction of SQL Server 2012 Microsoft officially supports local disk TempDB in SQL Server cluster configurations. This tip will show you how to configure TempDB on a local disk when installing your SQL Server 2012 cluster.

Recreate a temporary table from TempDB

This Script can be used to pick out a temporary table from tempDB

you might want to Check and drop the table before you create it just in case , but I Haven't included it here

Get space used by queries in tempdb

See what is taking up space in tempdb.

Optimizing tempdb configuration with SQL Server 2012 Extended Events

One of the most obvious bottlenecks in the performance of tempdb is caused by PAGELATCH, in-memory latch contention on the allocation bitmap of each data file used. We can use one of the rules-of-thumb to choose what should be roughly the best number of files, but how then do you check to see whether you've got it right for your data and workload?

How to Performance Tune the Microsoft SQL Server tempdb Database

If your SQL Server’s tempdb database is heavily used by your application(s), consider locating it on an array of its own (such as RAID 1 or RAID 10). This will allow disk I/O to be more evenly distributed, reducing disk I/O contention issues, and speeding up SQL Server’s overall performance.

Tempdb Space Usage in SQL Server

We all know how important tempdb is and know that tempdb gets recreated every time SQL Server is restarted. Here we dig a little deeper to focus on how space is used inside tempdb.

Identify Allocation Contention in TEMPDB

Identifies potential page allocation contention in TEMPDB.

TempDB usage per active session

Lists the TempDB usage per each active session.

TempDB