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.

Requires VIEW SERVER STATE permission on the server.