SynapseSqlPoolDmsWorkers

Information about workers completing DMS steps in an Azure Synapse dedicated SQL pool.

Table attributes

Attribute Value
Resource types microsoft.synapse/workspaces
Categories Azure Resources
Solutions LogManagement
Basic log Yes
Ingestion-time transformation Yes
Sample Queries -

Columns

Column Type Description
_BilledSize real The record size in bytes
BytesProcessed int The bytes processed of the DMS workers.
Category string The category of the log.
CpuTime int The cpu time for the DMS workers.
DestinationInfo string The row count of the DMS workers.
DistributionId int The distribution id of the DMS workers.
DmsCpuId int The DMS cpu Id for the DMS workers.
DmsStepIndex int The DMS step index of the DMS workers.
EndTime datetime The end time (UTC) for the DMS workers.
ErrorId string The errorId of the DMS workers.
_IsBillable string Specifies whether ingesting the data is billable. When _IsBillable is false ingestion isn't billed to your Azure account
LogicalServerName string The logical server name of the SQL DW.
OperationName string The operation associated with log record.
PdwNodeId int The pdw node id of the DMS workers.
RequestId string The requestId of the DMS workers.
ResourceGroup string The azure resourceGroup of the SQL DW.
_ResourceId string A unique identifier for the resource that the record is associated with
RowsProcessed int The rows processed of the DMS workers.
SourceInfo string The row count of the DMS workers.
SourceSystem string The type of agent the event was collected by. For example, OpsManager for Windows agent, either direct connect or Operations Manager, Linux for all Linux agents, or Azure for Azure Diagnostics
SqlSpId int The SQL Sp Id for the DMS workers.
StartTime datetime The startTime (UTC) of the DMS workers.
Status string The status of the DMS workers.
StepIndex int The step index of the DMS workers.
_SubscriptionId string A unique identifier for the subscription that the record is associated with
TenantId string The Log Analytics workspace ID
TimeGenerated datetime The timestamp (UTC) of when the log was generated.
Type string The type of the DMS workers.