sys.dm_os_workers

#os#dmv

Description

Analytics Platform System (PDW) Returns a row for every worker in the system. For more information about workers, see the Thread and Task Architecture Guide 1 = Worker is running with preemptive scheduling. Any worker that is running external code is run 1 = Worker is running with lightweight pooling. For 1 = Worker is stuck trying to obtain a spin lock.

Syntax

Azure Active Directory admin

Examples

Example 1

VIEW SERVER STATE

Example 2

VIEW DATABASE STATE

Example 3

Server Admin

Example 4

Azure Active Directory admin