Tutorial by Examples

Following query will provide information about TempDb usage. Analyzing the counts you can identify which thing is impacting TempDb SELECT SUM (user_object_reserved_page_count)*8 as usr_obj_kb, SUM (internal_object_reserved_page_count)*8 as internal_obj_kb, SUM (version_store_reserved_page_cou...

Below query can be used to get TempDB database details: USE [MASTER] SELECT * FROM sys.databases WHERE database_id = 2 OR USE [MASTER] SELECT * FROM sys.master_files WHERE database_id = 2 With the help of below DMV, you can check how much TempDb space does your session is using. This query...