If you’ve ever received an alert that tempdb was running out of space, you probably want to know what session/query is consuming tempdb. There are two ways tempdb gets consumed. User tempdb usage and system tempdb usage. User temdpb usage is related to creating and populating @table variables or #temporary tables and explicitly populating them. […]
Read More![](https://6c9e5a.a2cdn1.secureserver.net/wp-content/uploads/2017/09/blog_header2.png)