Databases Reference
In-Depth Information
The key points from this chapter are as follows:
➤
Three types of objects can be found in tempdb: user-created, internally created, and the
version store.
➤
Latch contention is a common problem even in SQL Server 2012, but it is easy to resolve
and even avoid.
➤
You should familiarize yourself with the following DMVs for help in troubleshooting urgent
tempdb space issues:
➤
sys.dm_db_file_space_usage
➤
sys.dm_db_task_space_usage
➤
sys.dm_db_session_space_usage
➤
Appropriately sizing and coni guring tempdb should be paramount for any SQL Server
installation to avoid performance issues later.
Search WWH ::
Custom Search