Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Scripts with tag tempdb Rss

Search for any content tagged tempdb

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Add a script

   Items 1 to 8 of 8   

Query details about objects allocated in TEMPDB.

TEMPDB doesn't have to be a black box. Know what objects and processes are causing it to bloat in size.  Read more...
By Eric Russell 2017/01/30 | Source: | Category: tempdb
Rating: |  Discuss |   Briefcase | 1,004 reads

Identify tempdb usage

Identifies SQL and or Jobs that are using tempdb space.  Read more...
By David Kranes 2016/10/07 | Source: | Category: tempdb
Rating: (not yet rated) |  Discuss |   Briefcase | 856 reads

move tempdb

For maximum performance, tempdb should be placed on a seperate disk. This script does all the work for you, except the restart!  Read more...
By Wilfred van Dijk 2014/10/13 | Source: | Category: tempdb
Rating: |  Discuss |   Briefcase | 1,432 reads

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  Read more...
By Tristan Cook 2016/03/01 | Source: | Category: tempdb
Rating: |  Discuss |   Briefcase | 1,752 reads

Find SQL Statements Consuming tempdb Space

You can use the following query to find the currently active requests, their associated T-SQL statement, and the corresponding query plan that is allocating most space resources in tempdb.  Read more...
By Rahul Singh 2012/12/13 | Source: | Category: administration
Rating: |  Discuss |   Briefcase | 2,542 reads

Get space used by queries in tempdb

See what is taking up space in tempdb. 
By Harsha Majety 2012/12/03 | Source: | Category: tempdb
Rating: |  Discuss |   Briefcase | 1,926 reads

Identify Allocation Contention in TEMPDB

Identifies potential page allocation contention in TEMPDB. 
Rating: |  Discuss |   Briefcase | 2,763 reads

TempDB usage per active session

Lists the TempDB usage per each active session.  
Rating: |  Discuss |   Briefcase | 9,684 reads
   Items 1 to 8 of 8