用数据库引擎优化顾问优化时,会提示“已占有工作负荷的15%具有语法错误,有关详细信息请...”
请问弹出这个提示是什么原因导致的。
证明你这个分析开销好大,DTA本身就是资源占用很大的应用,如果你的数据库处于压力状态,再分析一个大查询,就出现这种“警告”,但是它也不算“错误”。
这是官方白皮书上的:
Question: DTA tunes a workload and displays an error message, “X% of consumed
workload has syntax errors. Check tuning log for more information.” Why is DTA
throwing an error?
Answer: This is not a DTA error. The tool is giving feedback to the user indicating that
X% of the workload it consumed had syntax errors. Syntax errors are logged in the
tuning log. Note that DTA provides a recommendation for the valid statements.