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

TempDB usage per active session

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

Tempdb

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

TempDB usage per active session

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

TempDB

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