Profiler Events

  • Hi All,

    what is the difference between show plan xml,show plan xml for query compile,show plan xml statistics profile in the context of profiler. How to get query cost.

  • m.rajesh.uk (6/4/2013)


    Hi All,

    what is the difference between show plan xml,show plan xml for query compile,show plan xml statistics profile in the context of profiler. How to get query cost.

    Did you look for any articles related to execution plans in Google?

    If not, please do. You will get loads of information which cannot be covered in forum posts like these.

    There is a book on "SQL Server Execution Plans" by Grant Fritchey, link is given below for your reference

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

    Edit: Added link to a book


    Kingston Dhasian

    How to post data/code on a forum to get the best help - Jeff Moden
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

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

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