Summary
In this chapter, you learned ways to monitor your Azure Synapse Data Explorer environment.
You started by using control commands with KQL to check and update the capacity of your Data Explorer pools. You investigated how to monitor query execution, look for ongoing queries and commands, and stop a query’s execution if needed. Still on the topic of system monitoring using KQL, you learned how to understand object metadata and the history of metadata changes in objects.
Next, you learned about the Azure Monitor integration with Azure Synapse Data Explorer. We explored ways Azure Monitor can help you with monitoring and observability of your Data Explorer pool. To close, you created an alert that sent notifications to your phone if your Data Explorer pool was started without you having to be in front of a computer.
In the next chapter, you will learn how to configure resource management in your Data Explorer pools to classify and prioritize user queries.