0

I am studying Query Store, and while reading sys.query_store_runtime_stats I found these

Average CPU time for the query plan within the aggregation interval (reported in microseconds). Note: Azure SQL Data Warehouse will always return zero (0).

Average number of physical IO reads for the query plan within the aggregation interval (expressed as a number of 8KB pages read). Note: Azure SQL Data Warehouse will always return zero (0).

Average memory grant (reported as the number of 8 KB pages) for the query plan within the aggregation interval. Always 0 for queries using natively compiled memory optimized procedures. Note: Azure SQL Data Warehouse will always return zero (0).

My stuff is all running on prem, so CPU time is valuable information to me. But why would Microsoft, not display CPU time in Azure?

I understand that Microsoft charges Azure by DWU. But Identifying CPU, Memory and I/O uniquely would seem to be more helpful for tuning queries.

Related: What are Data Warehouse Units?

With SQL Data Warehouse CPU, memory, and IO are bundled into units of compute scale called Data Warehouse Units (DWUs). A DWU represents an abstract, normalized measure of compute resources and performance. By changing your service level you alter the number of DWUs that are allocated to the system, which in turn adjusts the performance, and the cost, of your system.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.