Share via

View Logs for When a dedicated SQL pool is paused or resumed

WZIAFP 237 Reputation points
2021-12-31T10:58:35.84+00:00

I'm relatively new to Synapse.
I have an Azure Dedicated SQL Pool that is unusually starting up automatically. Can someone assist me in finding the logs that i need to find the activity that is starting the sql pool.
I will also need to establish an alert to let me know when and who/what is starting the pool.

Azure Monitor
Azure Monitor
An Azure service that is used to collect, analyze, and act on telemetry data from Azure and on-premises environments.
3,658 questions
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,378 questions
Microsoft Security | Microsoft Entra | Microsoft Entra ID
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. WZIAFP 237 Reputation points
    2021-12-31T14:29:44.433+00:00

    I have found the answer.

    Azure -> Monitor -> Activity Log -> Filter: "Resume SQL Analytics Pools", "Pause SQL Analytics Pools"

    1 person found this answer helpful.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.