Skip to Main Content
Patch My PC Feature and Application Request

A community where customers and the community can provide feedback to make a better product for everyone! For more details on how we prioritize request, please see:

5 VOTE
Status NOTED
Created by Jordan Benzing
Created on May 27, 2021

Detect SQL version and install different version of reports

Older versions of SQL do not support the legacy cardinality hint methodology.


Microsoft has a reccomendation where any report that times out should use the hint technology, or set the SQL instance to an older compatability mode. All of the queries in the console use this hint now if a newer version is detected.

https://docs.microsoft.com/en-US/troubleshoot/mem/configmgr/sql-query-times-out-or-console-slow-performance


This change would require a rebuild of all reports, and an update to the report installer.


  • Attach files