Home All Groups Group Topic Archive Search About

Retrieving a distal query plan

Author
28 Apr 2006 9:22 PM
ionFreeman@gmail.com
Hi!
   I have a consultant onsite at a client, and she's sending back
pictures of the query plan for a script with a performance issue. These
are useful, as they're turning out somewhat different from the
development and test machines. But, is there any way we can pass the
query plan so that I can look at it in Query Analyzer's fine query plan
renderer?
Thanks!
Ion

Author
28 Apr 2006 11:51 PM
Steve Kass
Ion,

SQL Server 2005 has this feature, but not SQL Server 2000.
In SQL Server 2005 Management Studio, you can save and
reopen query plans saved as .sqlplan files (which are XML files).
There might be a third-party tool that can render the graphical plan
from the SHOWPLAN_TEXT text plan - at least it's conceivable -
but I don't know of one.

Steve Kass
Drew University



ionFree***@gmail.com wrote:

Show quote
>Hi!
>   I have a consultant onsite at a client, and she's sending back
>pictures of the query plan for a script with a performance issue. These
>are useful, as they're turning out somewhat different from the
>development and test machines. But, is there any way we can pass the
>query plan so that I can look at it in Query Analyzer's fine query plan
>renderer?
>Thanks!
>Ion
>

>
Author
29 Apr 2006 10:23 PM
Roy Harvey
I think I heard that you can use SQL Server 2005 Management Studio
against a 2000 database, and that it will allow you to save the plan
and send it as with any 2005 database.

Roy Harvey
Beacon Falls, CT

On Fri, 28 Apr 2006 19:51:02 -0400, Steve Kass <sk***@drew.edu> wrote:

Show quote
>Ion,
>
>SQL Server 2005 has this feature, but not SQL Server 2000.
>In SQL Server 2005 Management Studio, you can save and
>reopen query plans saved as .sqlplan files (which are XML files).
>There might be a third-party tool that can render the graphical plan
>from the SHOWPLAN_TEXT text plan - at least it's conceivable -
>but I don't know of one.
>
>Steve Kass
>Drew University
>
>
>
>ionFree***@gmail.com wrote:
>
>>Hi!
>>   I have a consultant onsite at a client, and she's sending back
>>pictures of the query plan for a script with a performance issue. These
>>are useful, as they're turning out somewhat different from the
>>development and test machines. But, is there any way we can pass the
>>query plan so that I can look at it in Query Analyzer's fine query plan
>>renderer?
>>Thanks!
>>Ion
>>
>> 
>>
Author
1 May 2006 3:08 PM
ionFreeman@gmail.com
Thanks, guys. I'll see where this brings me.

AddThis Social Bookmark Button