Automated Parsing of Execution Plan

  • We have the following requirement to be accomplished.

    We are planning for an simple automated system which will help us analyze on some key attributes of the execution plan.

    Say we have 4 different procedure and logic to handle a problem,the tool will save the estimated execution plans for all the four procedure as xml in a table.

    The xmls should be parsed to get the subtree cost, reads, statement, index used and such details and write it to a flat file or excel from which the data will be processed and further analyzed.

    Please suggest to proceed.

  • There's no tool I know of that does that. I had an idea to write something like that a year or so ago, but it never got started.

    The schema is standard, so it's possible to write XQuery queries to fetch stuff out. Isn't trivial though.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply