I have been trying to use the Query Store in SQL Server as an easy way to identify queries running in parallel and the degree of parallelism. However, when I look at the
max_dop field in
sys.query_store_runtime_stats, I am getting some values that are way beyond the number of CPU's the instance has. I have looked at another instance and also found the erroneous information.
Since one instance is running SQL Server 2017 and the other is running 2019, it doesn't seem to be related to a particular version.
Has anyone else seen similar problems? Am I misinterpreting the column definition?