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

Tempdb

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

TempDB usage per active session

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

TempDB

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