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 7 of 7   

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 | 677 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,424 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,746 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,532 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,916 reads

Identify Allocation Contention in TEMPDB

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

TempDB usage per active session

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