October 10, 2008 at 6:17 am
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.
October 10, 2008 at 7:46 am
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply