title: "sys.fn_PageResCracker (Transact-SQL) | Microsoft Docs"

ms.custom: ""

ms.date: "09/18/2018"

ms.prod: sql

ms.prod_service: "database-engine"

ms.component: "system-functions"

ms.reviewer: ""

ms.suite: "sql"

ms.technology: system-objects

ms.tgt_pltfrm: ""

ms.topic: "language-reference"

f1_keywords:

- "fn_PageResCracker"

- "sys.fn_PageResCracker_TSQL"

- "fn_PageResCracker_TSQL"

- "sys.fn_PageResCracker"

- "sys.dm_db_page_info"

dev_langs:

- "TSQL"

helpviewer_keywords:

- "fn_PageResCracker function"

- "page_resource"

- "sys.fn_PageResCracker function"

- "sys.dm_db_page_info"

- "page info"

author: ""

ms.author: "pamela"

manager: "amitban"

[!INCLUDE[tsql-appliesto-ssver15-xxxx-xxxx-xxx](../../includes/tsql-appliesto-ssver15-xxxx-xxxx-xxx.md)]

Returns the `db_id`, `file_id`, and `page_id` for the given `page_resource` value.

 [Transact-SQL Syntax Conventions](../../t-sql/language-elements/transact-sql-syntax-conventions-transact-sql.md)

```

```

*page_resource*

Is the 8-byte hexadecimal format of a database page resource.

|Column name|Data type|Description|

|-----------------|---------------|-----------------|

|db_id|**int**|Database ID|

|file_id|**int**|File ID|

|page_id|**int**|Page ID|

`sys.fn_PageResCracker` is used to convert the 8-byte hexadecimal representation of a database page to a rowset that contains the database ID, file ID and page ID of the page. You can obtain a valid page resource from the `page_resource` column of the [sys.dm_exec_requests (Transact-SQL)](../../relational-databases/system-dynamic-management-views/sys-dm-exec-requests-transact-sql.md) dynamic management view or the [sys.sysprocesses (Transact-SQL)](../../relational-databases/system-compatibility-views/sys-sysprocesses-transact-sql.md) system view. The primary use of `sys.fn_PageResCracker` is to facilitate joins between these views and the [sys.dm_db_page_info (Transact-SQL)](../../relational-databases/system-dynamic-management-views/sys-dm-db-page-info-transact-sql.md) dynamic management function in order to obtain information about the page, such as the object to which it belongs.

The user needs VIEW SERVER STATE permission on the server.

The `sys.fn_PageResCracker` function can be used in conjunction with [sys.dm_db_page_info (Transact-SQL)](../../relational-databases/system-dynamic-management-views/sys-dm-db-page-info-transact-sql.md) to troubleshoot page related waits and blocking in [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)]. The following script is an example of how you can use these functions to gather database page information for all active requests that are currently waiting on some type of page resource.

```sql

SELECT page_info.*

FROM sys.dm_exec_requests AS d

CROSS APPLY sys.fn_PageResCracker (d.page_resource) AS r

CROSS APPLY sys.dm_db_page_info(r.db_id, r.file_id, r.page_id, 1) AS page_info

```

[sys.dm_db_page_info (Transact-SQL)](../../relational-databases/system-dynamic-management-views/sys-dm-db-page-info-transact-sql.md)

[sys.sysprocesses (Transact-SQL)](../../relational-databases/system-compatibility-views/sys-sysprocesses-transact-sql.md)

[sys.dm_exec_requests (Transact-SQL)](../../relational-databases/system-dynamic-management-views/sys-dm-exec-requests-transact-sql.md)