title: "sys.dm_os_stacks (Transact-SQL) | Microsoft Docs" ms.custom: "" ms.date: "03/13/2017" ms.prod: "sql" ms.prod_service: "database-engine, sql-database" ms.service: "" ms.component: "dmv's" ms.reviewer: "" ms.suite: "sql" ms.technology:
- "database-engine" ms.tgt_pltfrm: "" ms.topic: "language-reference" f1_keywords:
- "dm_os_stacks"
- "dm_os_stacks_TSQL"
- "sys.dm_os_stacks"
- "sys.dm_os_stacks_TSQL" dev_langs:
- "TSQL" helpviewer_keywords:
- "sys.dm_os_stacks dynamic management view" ms.assetid: a69b06c4-28f0-4535-8fa1-9f132db4d916 caps.latest.revision: 23 author: "stevestein" ms.author: "sstein" manager: "craigg" ms.workload: "Inactive" monikerRange: "= azuresqldb-current || >= sql-server-2016 || = sqlallproducts-allversions"
[!INCLUDEtsql-appliesto-ss2008-asdb-xxxx-xxx-md]
This dynamic management view is used internally by [!INCLUDEssNoVersion] to do the following:
-
Keep track of debug data such as outstanding allocations.
-
Assume or validate logic that is used by [!INCLUDEssNoVersion] components in places where the component assumes that a certain call has been made.
| Column name | Data type | Description |
|---|---|---|
| stack_address | varbinary(8) | Unique address for this stack allocation. Is not nullable. |
| frame_index | int | Each line represents a function call that, when sorted in ascending order by frame index for a particular stack_address, returns the full call stack. Is not nullable. |
| frame_address | varbinary(8) | Address of the function call. Is not nullable. |
sys.dm_os_stacks requires that the symbols of the server and other components be present on the server to display the information correctly.
On [!INCLUDEssNoVersion_md], requires VIEW SERVER STATE permission.
On [!INCLUDEssSDS_md], requires the VIEW DATABASE STATE permission in the database.
SQL Server Operating System Related Dynamic Management Views (Transact-SQL)