Export (0) Print
Expand All

Threads Window

The Threads window displays information about the Database Engine thread that is used by the Database Engine Query Editor session that is being debugged. You must be in debug mode to display the thread information.

To access the Threads window

  • On the Debug menu, click Windows, and then click Threads.

ID

Is a unique identifying number that the Transact-SQL debugger assigns to the thread. You can find more information about the thread by selecting a row from the sys.dm_os_threads dynamic management view.

If you are not running in lightweight pooling mode, select the row in which the value in os_thread_id matches the value in the ID column. If you are running in lightweight pooling mode, select the row in which the value in fiber_context_address matches the value in the ID column.

Name

Displays information about the Database Engine session in the format ComputerName/InstanceName [SPID].

ComputerName

The name of the computer that is running the instance of the Database Engine that the Query Editor session is connected to.

InstanceName

The name of the instance of the Database Engine that the Query Editor session is connected to.

[SPID]

The SQL Server session process ID that uniquely identifies this session. You can obtain more information about the session by selecting the row in the sys.sysprocesses view that has the same value in the spid column.

Location

Displays the name of the script file that is used in the Query Editor session that is being debugged.

Priority

The Transact-SQL debugger does not support this feature.

Suspend

The Transact-SQL debugger does not support this feature.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft