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: SQLServerCentral.com | Category: tempdb
Rating: |  Discuss |   Briefcase | 1,020 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: SQLServerCentral.com | Category: tempdb
Rating: |  Discuss |   Briefcase | 1,103 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: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,384 reads

Get space used by queries in tempdb

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

Identify Allocation Contention in TEMPDB

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

TempDB usage per active session

Lists the TempDB usage per each active session.   Read more...
Rating: |  Discuss |   Briefcase | 7,602 reads
   Items 1 to 6 of 6