PowerShell to fetch a SQL Execution Plan

re: PowerShell to fetch a SQL Execution Plan

SQLvariant — Tue, 07 Dec 2010 01:31:35 GMT

This is Excellent Rob. Thanks for throwing it together!!

Rob Farley — Mon, 03 Jan 2011 05:55:27 GMT

SQL Server is quite remarkable in a bunch of ways. In this post, I’m using the way that the Query Optimizer

juerg — Sun, 04 Nov 2012 16:11:57 GMT

thanks for the script, however e.g. trying to get the plan for AdventureWorks2012.dbo.uspGetBillOfMaterials I get

Error: "Unexpected end of file has occurre

d. The following elements are not closed: OutputList, RelOp, QueryPlan, StmtSimple, Statements, Stor

edProc, StmtSimple, Statements, Batch, BatchSequence, ShowPlanXML. Line 1, position 4001."

At D:\Projekte\Wincasa\QVReporting_home\CreateExecutionPlan.ps1:6 char:109

+ { return ([xml] (invoke-sqlcmd -Server $server -Database $db -Query "set showplan_xml on;`ngo`n$qu

ery").Item <<<< ( 0)) }

+ CategoryInfo : NotSpecified: (:) [], RuntimeException

+ FullyQualifiedErrorId : RuntimeException

any idea?

Thanks

Rob Farley — Tue, 13 Nov 2012 10:46:32 GMT

Hi juerg,

Make sure the file contains the right combinations of brackets, braces and parentheses, and has no extra characters in there.

Rob