Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags Administration, tempdb Rss

   Items 1 to 8 of 8   
 

Drop Databases

By free mascot 2015/04/24 | Category: tempdb
Rating: (not yet rated) |  Discuss |   Briefcase | 1,820 reads

TempDB usage per active session

Lists the TempDB usage per each active session.   Read more...
Rating: |  Discuss |   Briefcase | 8,356 reads

Tempdb

By free mascot 2014/01/20 | Category: tempdb
Rating: (not yet rated) |  Discuss |   Briefcase | 2,226 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,449 reads

Has tempdb grown since the last restart?

Check tempdb to see if it has been autogrown since the last restart. If it has, there may be an opportunity to improve server performance.  Read more...
By Orlando Colamatteo 2012/11/20 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 8,072 reads

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.  Read more...
By Additional Articles 2011/06/28 | Source: Database Journal | Category: tempdb
Rating: (not yet rated)  Rate this |   Briefcase | 4,268 reads

TempDB usage per active session

Lists the TempDB usage per each active session.   Read more...
Rating: |  Discuss |   Briefcase | 8,356 reads

TempDB

By VM-723206 2010/08/20 | Category: tempdb
Rating: (not yet rated) |  Discuss |   Briefcase | 3,949 reads
   Items 1 to 8 of 8   
 
Tags
dbcc (1)