Looking for guidance on compile/re-compile/batches stats from a SQL 2014 instance with one database. One minute sample.
batches/sec = 899
compiles/sec = 3
re-compiles/sec = 0.5
Aligning to that sys.dm_exec_procedure_stats shows sprocs cached_time along with execution_count restarting every few seconds.
(1) I would expect more re-compiles/sec than compiles/sec. Does a greater compiles/sec suggest some config setting that needs adjustment?
(2) Although we are within the 10% rule of thumb (compilations/sec is less than 10% of bathes/sec) it does not seem right to me that a given sproc is being compiled every few seconds.
Any help/guidance much appreciated.