sys.dm_os_stacks (Transact-SQL)

This dynamic management view is used internally by SQL Server to do the following:

  • Keep track of debug data such as outstanding allocations.

  • Assume or validate logic that is used by SQL Server 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

Requires VIEW SERVER STATE permission on the server.