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.