Monitoring your MDWH
Monitoring your workloads with different services on Azure might be a challenging idea when you consider the isolated service. But as mentioned in other chapters already, all Azure services that we have touched on integrate with Azure Monitor. Their logs and metrics can be sent to Log Analytics and can be analyzed together with other services at a higher level.
When we check the Azure Synapse-dedicated SQL pools, for example, you will have the option to select and push from the following log information to Log Analytics (and two other options; see the following):
- SQLRequests: These are insights about the queries run in the pool, especially the distribution of the steps.
- RequestSteps: Here, you will find the details about the query steps.
- ExecRequests: High-level information about the queries.
- DmsWorkers: Insights about the worker nodes that are executing steps during query execution.
- Waits: Wait states during query runs; you will also...
