英文:
Does azure synapse serverless sql pool database support Query store?
问题
尝试在 Synapse 工作区的 Serverless SQL 池数据库上启用查询存储，但出现错误"QUERY_STORE 不支持 ALTER DATABASE"。
我期望查询存储可用于 Serverless SQL 池数据库，但无法使其正常工作。
英文:
Tried turning on Query store on a Serverless SQL pool database in Synapse workspace, but it is throwing error "QUERY_STORE is not supported for ALTER DATABASE."
I expect Query store to be available for serveless sql pool database , but can't make this to work
答案1
得分: 1
不支持查询存储（或大量相关功能，如用户可见的执行计划）。
但它确实具有一个DMV sys.dm_exec_requests_history，其中包含历史查询的日志以及一些与其相关的统计信息。
英文:
No it doesn't support query store (or a large number of related features such as user visible execution plans).
It does have a DMV sys.dm_exec_requests_history with a log of historic queries and a few stats about them though.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论