Difference between microsoft.vw_sql_requests and sys.dm_pdw_sql_requests?

Question

Difference between microsoft.vw_sql_requests and sys.dm_pdw_sql_requests?

Anonymous

Based on the guidance in the "Monitor tempdb" section of this documentation https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-manage-monitor

I added the microsoft.vw_sql_requests view from the Microsoft Toolkit for SQL pool. As I was poking around later, I also stumbled across the DMV sys.dm_pdw_sql_requests that seems to store identical information. Is there any difference between these two views?

KranthiPakala-MSFT 46,827 Reputation points Moderator

2023-11-21T01:11:19.74+00:00

@Anonymous Just checking in to see if the below information was helpful. If it answers your query, please do click Accept Answer and Yes for "was this answer helpful", as it might be beneficial to other community members reading this thread. If you have any further query, do let us know.

Thank you
KranthiPakala-MSFT 46,827 Reputation points Moderator

2023-11-21T17:53:17.5233333+00:00

@Anonymous We still have not heard back from you. Just wanted to check if the below information was helpful? If it answers your query, please do click Accept Answer and Yes for "was this answer helpful", as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

Thank you

1 answer

Your answer

KranthiPakala-MSFT 46,827 Reputation points Moderator

2023-11-21T01:11:19.74+00:00

@Anonymous Just checking in to see if the below information was helpful. If it answers your query, please do click Accept Answer and Yes for "was this answer helpful", as it might be beneficial to other community members reading this thread. If you have any further query, do let us know.

Thank you
KranthiPakala-MSFT 46,827 Reputation points Moderator

2023-11-21T17:53:17.5233333+00:00

@Anonymous We still have not heard back from you. Just wanted to check if the below information was helpful? If it answers your query, please do click Accept Answer and Yes for "was this answer helpful", as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

Thank you

Answer 1

For microsoft.vw_sql_requests : This view is part of the Microsoft Toolkit for SQL pool in Azure Synapse Analytics and it is a user-defined view, provided for monitoring. It can aggregate data from multiple DMVs or system views with custom calculations, filters...

For sys.dm_pdw_sql_requests DMV: This is a built-in Dynamic Management View in Azure Synapse Analytics and provides real-time information about all requests currently or recently active in the SQL Data Warehouse. This includes queries, DDL statements, and other SQL operations.Being a native DMV, it provides a direct view into the operational metadata as maintained by the Synapse SQL pool. The information in this DMV is typically raw and unfiltered, presenting data as directly captured by the system. It is useful for monitoring the health and performance of queries and operations within the SQL pool.

I think the toolkit view offer a more enriched data set, with combined data from several sources and could be extended or modified by users, while the DMV is considered as standard component of Azure Synapse Analytics and not modifiable.

The choice between them may depend on specific monitoring or diagnostic needs. For example, the toolkit view might be preferable for higher-level overviews or specific analytical tasks, whereas the DMV might be more suitable for in-depth technical diagnosis

https://github.com/Microsoft/sql-data-warehouse-samples/blob/main/solutions/monitoring/scripts/views/microsoft.vw_sql_requests.sql

https://adsql.in/2022/06/11/monitor-tempdb-utilization-in-azure-sql-synapse-analytics-dedicated-sql-pool/

Share via

Difference between microsoft.vw_sql_requests and sys.dm_pdw_sql_requests?

1 answer

Your answer