Επεξεργασία

Κοινή χρήση μέσω


sys.dm_pdw_sys_info (Transact-SQL)

Applies to: Azure Synapse Analytics Analytics Platform System (PDW)

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 maximum concurrent sessions
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.

Examples

No filters are needed for this dynamic management view:

SELECT * FROM sys.dm_pdw_sys_info;