In a previous blog post, I discussed two new methods in SQL Server 2019 to determine exactly which page a request might be waiting for when there is contention. One of these new methods involves a new function, fn_pagerescracker. Naturally, I wanted to see how this function operates. Let’s look at the Master database to investigate how it works!
The function consumes a BINARY(8) parameter and returns a table. This parameter represents a hexadecimal value that is constructed from the database ID, page ID, and file ID.