You have an enterprise data warehouse in Azure Synapse Analytics.
You need to monitor the data warehouse to identify whether you must scale up to a higher service level to accommodate the current workloads.
Which is the best metric to monitor?
More than one answer choice may achieve the goal. Select the BEST answer.
To monitor an Azure Synapse Analytics data warehouse and decide if you need to scale up, the DWU percentage is the most relevant metric. This metric provides the highest utilization between CPU and Data IO. Monitoring this percentage gives a clear understanding of resource usage and helps identify bottlenecks, thus indicating whether it's necessary to scale up the service level to accommodate workloads.
It is better to monitor DWU %, as it would be a consistent way to monitor independent of the absolute DWU used value (which can increase or decrease over time)
Agree, that would keep consistency in the way of operating regardless the size of Synapse
DWU percentage is the correct answer.
From microsoft docs: Things to consider when viewing metrics and setting alerts: ***DWU used*** represents only a high-level representation of usage across the SQL pool and ***is not meant*** to be a comprehensive indicator of utilization.
Answer is B. DWU used, defined as DWU limit * DWU percentage, represents only a high-level representation of usage across the SQL pool and is not meant to be a comprehensive indicator of utilization. As mentioned, it is not a comprehensive indicator, but is the best in the list. DWU percentage indicates only a maximum value between CPU and Data I/O.
DWU percentage = Maximum between CPU percentage and Data IO percentage DWU used = DWU limit * DWU percentage C is the answer
DWU percentage = Maximum between CPU percentage and Data IO percentage DWU used = DWU limit * DWU percentage C is the answer
Based on referenced link the anwser "DWU used" seems correct.
Really? From the reference link I quote: 'DWU used represents only a high-level representation of usage across the SQL pool and is not meant to be a comprehensive indicator of utilization
From the reference link in the answer: "To determine whether to scale up or down, consider all factors which can be impacted by DWU such as concurrency, memory, tempdb, and adaptive cache capacity."