|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Retrieving a distal query planHi!
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 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 > > > 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 >> >> >> |
|||||||||||||||||||||||