Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Typically, this metric value is low. A high re-compilation rate may be a sign of excessive re-compilation overhead. Causes of re-compiles include various events including schema changes, statistics updates, and explicit calls to WITH RECOMPILE. Excessive re-compilation impacts you server performance.

...

Scroll pdf ignore
SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >