The Premium capacity settings allow to limit queries in terms of memory usage and execution time (timeout). However, there is no such setting to limit CPU footprint for individual queries.
Therefore, a single poorly designed query can eat up all available CPU and cause throttling for an entire capacity. A new “Query CPU limit in %” setting could help reducing noisy neighbor effects caused by overly expensive queries.
1 Comment
- fbcideas_migusrNew MemberStatus added:New
Recent ideas
Enable mirroring of Google BigQuery Views
currently only tables are supported, Please enable mirroring of Google BigQuery Viewsjayantjape41 minutes agoRegular VisitorNew62Views1like1CommentRestore PNG snapshot attachments in Power BI report subscriptions
Microsoft recently migrated Power BI report subscriptions to a new email delivery platform. As part of this change, report snapshots are no longer delivered as separate PNG attachments and are only e...modch3 hours agoNew MemberNew87Views10likes2Comments