SQL Server: Database Developer (T-SQL) Interview Questions and Answers (Day-16)
What are the useful DMVs for TempDB? dm_db_file_space_usage: Stores metadata about disk space usage statistics by “user object”, “internal objects” and “version store” dm_db_session_space_usage: Stores metadata about disk space usage, page allocation and deallocation statistics at user session level. dm_db_task_space_usage: Stores metadata about disk space usage, page allocation and deallocation statistics at session task level. […]
About Me!
