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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy