question

AshimaGuta-1018 avatar image
0 Votes"
AshimaGuta-1018 asked PRADEEPCHEEKATLA-MSFT commented

Writing queries in Log analytics for Synapse

Hi All,

I've synapse resource on which I've set alerts such as whenever DWU is more than 80%, CPU is more than 80%. Now we are getting many alerts on that.

How can I found out which jobs are consuming more DWU percentage using log analytics.

From last one month only we are continuously receiving alerts from Synapase.

Please provide me with the query which can give results on which jobs are consuming more DWU, CPU percentage.

Regards,
Ashima

azure-synapse-analyticsazure-monitor
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @AshimaGuta-1018,

Welcome to Microsoft Q&A platform.

We are actively investigating and will answer with our findings soon.

0 Votes 0 ·

1 Answer

PRADEEPCHEEKATLA-MSFT avatar image
1 Vote"
PRADEEPCHEEKATLA-MSFT answered PRADEEPCHEEKATLA-MSFT commented

Hello @AshimaGuta-1018,

Apologize for the delay in response.

Query-level detail won’t be visible in Log Analytics unless you configure Auditing.

https://docs.microsoft.com/en-us/azure/azure-sql/database/auditing-overview

To drill down into the query workload, use the Query Store.

https://docs.microsoft.com/en-us/sql/relational-databases/performance/monitoring-performance-by-using-the-query-store?view=sql-server-ver15

Hope this helps. Do let us know if you any further queries.


  • Please accept an answer if correct. Original posters help the community find answers faster by identifying the correct answer. Here is how.

  • Want a reminder to come back and check responses? Here is how to subscribe to a notification.


· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @AshimaGuta-1018,

Just checking in to see if the above answer helped. If this answers your query, do click “Accept Answer” and Up-Vote for the same. And, if you have any further query do let us know.

0 Votes 0 ·

Hello @AshimaGuta-1018,

Following up to see if the above suggestion was helpful. And, if you have any further query do let us know.

Take care & stay safe!

0 Votes 0 ·