Comments (7)

  1. […] The formula for determining the page type is as follows: Note: the formula has been corrected. Please see new post: Breaking Down TempDB Contention Part 2 […]

  2. […] talked a lot in the past about tempdb contention and how to monitor for and identify it in blog posts, a whitepaper, webcasts, and live presentations. Okay, so I tend to get a little […]

  3. […] previously about allocation pages in my posts on dealing with tempdb contention here (part 1) and here (part 2). Allocation pages are special pages in the data files that track and manage extent allocations. […]

  4. […] It just so happens we have a script for that. (more on SGAM contention) […]

  5. Great stuff. Thanks for this!

Leave a Reply

Your email address will not be published. Required fields are marked *