sys.dm_pdw_sys_info (Transact-SQL)

Applies to: yesAzure Synapse Analytics 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

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