Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
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 6 of 6   

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,210 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 2013/01/15 | Source: | Category: tempdb
Rating: |  Discuss |   Briefcase | 1,115 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,436 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,814 reads

Identify Allocation Contention in TEMPDB

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

TempDB usage per active session

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