Showing posts with label execution. Show all posts
Showing posts with label execution. Show all posts

Tuesday, March 27, 2012

Copy execution results

Hi,
A small suggestion. Could you make it possible to copy and paste the
contents of the Execution Results tab? Would be useful for comparing
executions.

-Jamie

Jamie, great idea. Can you open a DCR bug for this? We'll track it for V.Next.
Thanks,
K

|||OK. Track ID 976108583

Tuesday, February 14, 2012

Converting text output of execution plans to graphical

Hi Guys,
does anyone know of any nice tools that will take the text output of a
profiler trace (with show execution plan traces on) and turn it into
the graphical version that you see through a query analyser?
Cheers
WillWill (william_pegg@.yahoo.co.uk) writes:
> does anyone know of any nice tools that will take the text output of a
> profiler trace (with show execution plan traces on) and turn it into
> the graphical version that you see through a query analyser?
If you are talking SQL 2000, I don't know any such tool.
However, in SQL 2005 you can capute the even Showplan XML, and as I reacall,
you can save that plan to disk, and then load into Mgmt Studio.
Nevermind that Query Analyzer has a better graphical presentation of
query plans.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx