Question: I am using SQL Server 2012. Is there any DMV to verify whether TempDB was `ever` out of space? I am looking for a query that will provide the times on which tempdb was full.

Note: I already know that following query will provide `current` details.

```
USE tempdb
exec sp_spaceused

```

**REFERENCES**

1. [Troubleshooting Insufficient Disk Space in tempdb](http://technet.microsoft.com/en-us/library/ms176029%28v=sql.105%29.aspx)

Answer: 
You can check the error logs for a message saying that tempdb tried to grow but couldn't.

The message should look soemthing like:

> 
> "Could not allocate space for object ... in
>  database ... because the ... filegroup is full. Create
>  disk space by deleting unneeded files, dropping objects in the
>  filegroup, adding additional files to the filegroup, or setting
>  autogrowth on for existing files in the filegroup. "
> 
> 
>
You can check the error logs which will specify you that the temdb is full and you need to increase the space or better manage the space and also check [Troubleshooting Insufficient Disk Space in tempdb](http://technet.microsoft.com/en-us/library/ms176029%28v=sql.105%29.aspx)