Missing Fields Added to Dedicated SQL pool Diagnostic Settings Logs
Published Jun 13 2023 08:00 AM 2,949 Views

Over the past year, customers have informed the team there were a set of key columns missing in the standalone Dedicated SQL pools (formerly SQL DW) and Synapse workspace Dedicated SQL pool Diagnostic Setting logs. After receiving a considerable amount of customer feedback, nine fields have been added to the Dedicated SQL pool logs and are generally available. These values will provide a more effective monitoring experience as customers are now able to identify which session the query belongs to along with other fundamental insights.  


The fields added into the Synapse Diagnostic Settings Logs are the following: 


Azure Monitor Logs reference - SynapseSqlPoolExecRequests: 

  • ClassifierName 
  • Importance 
  • ResourceAllocationPercent 
  • ResultCacheHit 
  • SessionId 
  • SubmitTime [UTC] 
  • SubscriptionId 


Azure Monitor Logs reference - SynapseSqlPoolWaits. 

  • Request_id 
  • Session_id 
  • Lock Type 


There will be more fields added later and we’re working on enabling Basic Logs for Synapse logs as well so please stay tuned! 

1 Comment
Version history
Last update:
‎Jun 13 2023 11:09 AM
Updated by: