sys.dm_os_stacks
The document is archived and information here might be outdated

sys.dm_os_stacks

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.

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

Requires VIEW SERVER STATE permission on the server.

Show:
© 2016 Microsoft