var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Is it normal when monitoring via Permon to have instances where the number of batch requests per second is less than the number of recompiles? I am looking at the following stats
It is not impossible, and at this level, I would not be too concerned over it. Do you have a lot of stored procedures that include temp tables, and calls to other stored procedures? Temp tables in stored procedures cause recompiles.
In stored procs I normall use table variables
declare @table1 table
rather than #table1 or ##table1
Is this a better method to avoid recompiles?
It will still recompile. Temp table or table variable, the optimizer does not have any idea what statistics to use until runtime.
Is there a way around that?
Short of not using temp tables/variables...no.