November 17, 2008 at 4:12 am
I played a bit with the profiler and tried to see if I can find a good use to the events "showplan XML", "showplan XML for query compile" and "Showplan XML Statistics Profile". I was thinking about ways to analyze those events later on with xquery. The information that I got included most of the data that I get when I run any statement on SSMS and set statistics xml on, but with the profiler one thing that is missing is the statement itself. It seems to me that it makes it worthless. I can get the query plan, the subtree cost and all kind of information, but I can’t connect it to any of the stored procedures that are running on my server. Am I missing something?
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 18, 2008 at 2:33 am
...
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply