sa_diagnostic_cursor table

The sa_diagnostic_cursor table is owned by the dbo user. Each row describes either an internal or external cursor opened during the logging session.

There are two versions of this table: sa_diagnostic_cursor, and sa_tmp_diagnostic_cursor.

Column name	Column type	Description
logging_session_id	UNSIGNED INT	A number uniquely identifying the logging session during which the diagnostic information was gathered.
cursor_id	UNSIGNED BIGINT	A unique number identifying the cursor.
query_id	UNSIGNED BIGINT	Identifies the query over which this cursor ranges.
isolation_level	TINYINT	Isolation level at which this cursor was opened.
flags	UNSIGNED INT	Internal use.
forward_fetches	UNSIGNED INT	Number of forward fetches, including prefetches, done on the cursor.
reverse_fetches	UNSIGNED INT	Number of reverse fetches, including prefetches, done on the cursor.
absolute_fetches	UNSIGNED INT	Number of absolute fetches done on the cursor.
first_fetch_time_ms	UNSIGNED INT	Duration of time spent fetching the first row.
total_fetch_time_ms	UNSIGNED INT	Duration of time spent fetching. This value does not include application processing time between actual fetches (think time).
plan_xml	LONG VARCHAR	Detailed plan for cursors that were dumped at the time the cursor was closed. These plans contain detailed statistics where appropriate.