sys-dm-os-stacks-transact-sql.md

title	sys.dm_os_stacks (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/13/2017
ms.prod	sql-non-specified
ms.reviewer
ms.suite
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	JennieHubbard
ms.author	jhubbard
manager	jhubbard

sys.dm_os_stacks (Transact-SQL)

[!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.

Remarks

sys.dm_os_stacks requires that the symbols of the server and other components be present on the server to display the information correctly.

Permissions

On [!INCLUDEssNoVersion_md], requires VIEW SERVER STATE permission.
On [!INCLUDEssSDS_md] Premium Tiers, requires the VIEW DATABASE STATE permission in the database. On [!INCLUDEssSDS_md] Standard and Basic Tiers, requires the Server admin or an Azure Active Directory admin account.

See Also

SQL Server Operating System Related Dynamic Management Views (Transact-SQL)