英文:

Does azure synapse serverless sql pool database support Query store?

问题 {#heading}

尝试在 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}

得分: 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.