SQL Monitor now shows you insights on what's using up space in tempdb. Is it the version store? Internal objects like hash joins or sorts? User objects like temp tables? Which sessions are involved, and how are your tempdb files being used? Join Kendra to look over an example workload. In this video:
00:00 Navigating to the tempdb monitoring data
00:40 The overview graph of tempdb and types of usage you can see
02:14 Top sessions using tempdb and their related queries
03:00 Looking at the program names for tempdb usage
03:19 Finding which databases are using the most Version Store in tempdb
03:50 Viewing tempdb usage by file