Monitoring your environment
Azure Synapse Data Explorer offers a series of control commands that you can use to check for system status, ongoing queries, past operations, and more.
Note
All code examples in this chapter can be found in the Chapter 10
\System Monitoring.kql
file of the book repository.
The following examples will walk you through checking and adjusting the capacity of your Data Explorer pool, monitoring query execution, and reviewing the history of metadata changes in database objects.
Checking your Data Explorer pool capacity
If you are experiencing long execution times when executing queries or data ingestion jobs, the first step to take is to look at the overall system usage. The easiest way to check this is by running the .show capacity
command. Simply open a new Kusto Query Language (KQL) script in Azure Synapse Studio and run the following command:
.show capacity
This command produces a result similar to what’s illustrated in Figure...