Vnode utilization in Query Insights SQL pool insights

See how much compute your SQL pools use, directly in T-SQL. The queryinsights.sql_pool_insights view now includes vnode utilization for all pools: vnodes_used shows how many vnodes a pool used, max_vnodes_available shows the most it can use, and includes_cache_vnodes shows when vnodes kept warm for read caching are counted. Compare usage to the limit to spot pools that are close to full, check whether slow queries ran during busy periods by joining with queryinsights.exec_requests_history, and decide whether to scale capacity, adjust pool resource settings, or tune queries. Available in Fabric Data Warehouse and SQL analytics endpoints with 30 days of history.