Thread: Query memory
View Single Post
  #2 (permalink)  
Old August 29th, 2010, 12:28 PM
Brent Ozar's Avatar
Brent Ozar Brent Ozar is offline
Wrox Author
Join Date: Feb 2010
Location: Chicago, IL, US
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts

Yes, because that particular chapter is about memory, not TempDB. If you'd like to get information on how sessions are using space in TempDB for those operations, check out chapter 7. Page 292 starts discussing how to identify which sessions are using TempDB for sorts, spools, hash joins, and so on.
Author: Professional SQL Server 2008 Internals and Troubleshooting