August 21, 2012 at 10:20 am
So if i'm in enterprise manager sql server 2008 and i have a stored proc call. for example exec getUsers 'yoyo' and i click show execution plan. Will it show me the cached execution plan if it exists or is it going to generate its own execution plan?
August 21, 2012 at 12:16 pm
is this saying that i'm getting a cache hit? If so then how do i read this. It appears to me it showing a cache miss and a cache hit.
attaching the output from profiler
August 21, 2012 at 12:22 pm
Cached (providing there is a matching cached plan).
As for the miss and the hit: http://sqlinthewild.co.za/index.php/2010/07/27/hit-and-miss/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 21, 2012 at 12:30 pm
are u replying to my first or second comment?
August 21, 2012 at 12:32 pm
Both.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 21, 2012 at 12:38 pm
darnit!!!
August 21, 2012 at 1:04 pm
If you don't wan the cached plan, then EXEC <procedure> WITH RECOMPILE and get one fresh for your execution that doesn't affect the plan in cache.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply