Share via

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.
5,385 questions
SQL Server | Other
Accepted answer
  1. Olaf Helper 47,516 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
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.