![]() ![]() Note that both the above events have exactly same reasons: SELECT sv.subclass_name, There are two events available in profiler called “SP:Recompile” and “SQL:StmtRecompile”īelow is the query which can identify various possible reasons which is stored in profiler related catalog views. Easiest way is to capture profiler trace. There are various ways by which recompile can be captured. The query optimizer would detect such situations and would force a recompile.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |