November 20, 2008 at 8:46 am
Hi,
In MS Sql Server 2005 a new utility comes, an execution plan can be saved in disk with *.sqlplan extension. But i could not test this porperty in Sql Server 200 profiler.
Is there a different method to take execution plan?
November 20, 2008 at 9:25 am
Have you included Showplan XML EventClass in profiler trace? Include it and then click on that row and right click on it and chose Extract Event Data and save plan with .sqlplan extension...
Hope this helps.
MJ
November 20, 2008 at 9:39 am
in my experience it's a big performance hit on the server being profiled. i prefer to copy the query and run my own execution plan
November 20, 2008 at 9:43 am
I looked at Event-->Performance and i see Show Show Plan All, Statistics, Text. There is not Show Plan XML choice.
Is it relevant with SQl Server edition
Just inquiried @@version
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
November 20, 2008 at 9:52 am
This option is available only 2005 onwards.
MJ
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply