How to Determine if a Stored Procedure is Being Recompiled on Every Execution in SQL Server 2012

6 votes

1 answer

545 views

sql-server sql-server-2012 query-performance recompile

                          What query can I use to determine if a stored procedure is being recompiled every time it is executed in SQL Server 2012? I suspect that some of our stored procedures might be getting recompiled, but I'm not sure how to check. Thanks!
                        

Asked by lifeisajourney (751 rep)

Oct 22, 2024, 01:19 PM
Last activity: Oct 23, 2024, 10:58 AM

How to Determine if a Stored Procedure is Being Recompiled on Every Execution in SQL Server 2012

Related Questions