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.
4,696 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,363 questions
Accepted answer
  1. Olaf Helper 43,246 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