SQL Error [15871] [S0009]: DMV (Dynamic Management View) is not supported.

Santosh Hegde 21 Reputation points Microsoft Employee
2022-03-28T09:12:37+00:00

Getting below error when I ran SELECT * from sys.dm_exec_distributed_requests der ; in my synapse workspace. Connected as admin and still getting same error.

SQL Error [15871] [S0009]: DMV (Dynamic Management View) 'dm_exec_distributed_requests' is not supported.

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,566 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,122 questions
{count} votes

Accepted answer
  1. Olaf Helper 42,576 Reputation points
    2022-03-28T09:37:46.077+00:00

    in my synapse workspace

    As the error message says, that DMV exists & is supported on SQL Server on-premise, not on Azure Synapse, see
    https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-distributed-requests-transact-sql?view=sql-server-ver15

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful