2814
07/17/2025 Product Name Event ID 2814 Event Source MSSQLSERVER Component SQLEngine Symbolic Name PR_POSSIBLE_INFINITE_RECOMPILE Message Text A possibl
Product
Name
Event ID
2814
Event Source
MSSQLSERVER
Component
SQLEngine
Symbolic
Name
PR_POSSIBLE_INFINITE_RECOMPILE
Message Text
A possible infinite recompile was detected for SQLHANDLE %hs, PlanHandle %hs, starting
offset %d, ending offset %d. The last recompile reason was %d.
One or more statements caused the query batch to recompile at least 50 times. The specified
statement should be corrected to avoid further recompilations.
The following table lists the reasons for recompilation.
Description
1
Schema changed
2
Statistics changed
3
Deferred compile
4
Set option change
ﾉ
Expand table
ﾉ
Expand table