Bearbeiten

Freigeben über


SynapseSqlPoolSqlRequests

Information about query distributions of the steps of SQL requests/queries 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
Category string The category of the log.
Command string The command of the SQL requests.
DistributionId int The distribution id of the SQL requests.
EndTime datetime The end time (UTC) for the SQL requests.
ErrorId string The error id of the SQL requests.
_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 PdwNodeId of the SQL requests.
RequestId string The request Id of the SQL requests.
ResourceGroup string The azure resourceGroup of the SQL DW.
_ResourceId string A unique identifier for the resource that the record is associated with
RowCount int The row count of the SQL requests.
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
SpId int The sp id of the SQL requests.
StartTime datetime The startTime (UTC) of the SQL requests.
Status string The Status of the SQL requests.
StepIndex int The step index of the SQL requests.
_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 name of the table