sys.dm_pdw_sys_info (Transact-SQL)

APPLIES TO: noSQL Server noAzure SQL Database yesAzure SQL Data Warehouse yesParallel Data Warehouse

Provides a set of appliance-level counters that reflect overall activity on the appliance.

Column Name Data Type Description Range
total_sessions int Number of sessions currently in the system. 0 to max_active_sessions (see below).
idle_sessions int Number of sessions currently idle.
active_requests int Number of active requests currently running.
queued_requests int Number of currently queued requests.
active_loads int Number of loads currently running in the system.
queued_loads int Number of queued loads waiting for execution.
active_backups int Number of backups currently running.
active_restores int Number of backup restores currently running.

See Also

SQL Data Warehouse and Parallel Data Warehouse Dynamic Management Views (Transact-SQL)