http://www.sqlservercentral.com/blogs/basits-sql-server-tips/2012/08/06/recovering-from-out-of-disk-space-conditions-for-tempdb/

Printed 2014/10/26 02:10AM

Recovering from out-of-disk space conditions for tempdb

2012/08/06

Another potential problem that you need to tackle as a DBA is running out of disk space on the hard disk that contains tempdb.This is because SQL Server makes extensive use of tempdb when:

Viewing tempdb space usage

The following dynamic management views (DMVs) can be used to report information about tempdb space:

How to move tempdb?

SQL Server creates the tempdb database every time it starts up. Therefore, you only need to change the pointer to move the tempdb database and log files to move it to a new location. To do this:

In this short post, we learned how to troubleshoot and resolve disk space issues with tempdb.



Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.