October 28, 2010 at 9:37 am
Other than using set statistics time, is there any way to get the parse / compile time for statements?
I'm working with and extremely complex search query (30+ versions and anywhere between 30 and 60 tables) and I think this might be becoming an issue at the moment.
I'm actually considering converting the most commun searches into SPs rather than dynamic sql in asp.net.
I want to confirm my hunches with a full day's trace to figure out the real compile "wait time".
October 29, 2010 at 8:09 am
That might be worth turning into an article at some point...
Use showplan xml. Somewhere near close to the top you'll find this node :
<QueryPlan CachedPlanSize="85" CompileTime="55" CompileCPU="31" CompileMemory="632">
This is the info available from the xml plan in SSMS 2k8, it seems to contain more information... maybe because the profiler plan needs to compatible for 2k5.
<QueryPlan DegreeOfParallelism="1" MemoryGrant="64" CachedPlanSize="25" CompileTime="5" CompileCPU="5" CompileMemory="448">
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply