Post reply

SQL XML Plan

  • February 7, 2012 at 8:49 am

    #250434

    How to read SQL Query XML Plan?

  • February 7, 2012 at 1:07 pm

    #1444083

    From BOL:

    To open a saved XML query plan in SQL Server Management Studio

    In SQL Server Management Studio, on the File menu, choose Open, and then click File.

    In the Open File dialog box, set Files of type to Execution Plan Files (*.sqlplan) to produce a filtered list of saved XML query plan files.

    Select the XML query plan file that you want to view, and click Open.

    As an alternative, in Windows Explorer, double-click a file with extension .sqlplan. The plan opens in Management Studio.

  • February 7, 2012 at 1:19 pm

    #1444092

    http://www.sqlservercentral.com/articles/books/65831

    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

  • February 7, 2012 at 1:33 pm

    #1444102

    thanks for helpful replies...

    and wonderful book written on sql plans..thanks for share..

Viewing 4 posts - 1 through 3 (of 3 total)

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