@Raj Singh
Thank you for confirming the error.
You're absolutely right not all DMVs are available in every Synapse Dedicated SQL Pool deployment. The error you're seeing (Invalid object name
) for sys.dm_pdw_memory_distribution
and sys.dm_pdw_resource_stats
typically means:
These specific DMVs are not supported in your current Synapse SKU or region, even if you're connected to the correct Dedicated SQL Pool.
You Can Do Instead:
- Use
sys.dm_pdw_nodes_os_performance_counters
This DMV provides valid and useful OS-level metrics like CPU and memory usage across nodes. - Monitor with Synapse Studio (Recommended)
- Go to the Monitor tab in Synapse Studio
- Use the built-in dashboards for live and historical views of query performance and resource usage
- Optional: Use Azure Monitor / Log Analytics For advanced monitoring, integrate Synapse with Azure Monitor to track long-term trends, set up alerts, and analyze logs.
- Check for Bottlenecks
- Review table distribution (avoid data skew)
- Check query concurrency (monitor queue build-up or slow queries)
Note:
These DMV differences are not well-documented across all SKU versions, so your observation is valid. You are already using the correct pool and context; the issue is most likely due to backend limitations.
If this is helpful, please click Accept Answer and kindly upvote it so that other people who faces similar issue may get benefitted from it.
Let me know if you have any further Queries.