Drop Table
Support Forum for database administrators and web based access to important newsgroups related to databases
Performance: Execution Plan ~ entry not in drop down list.Hello, I want to capture the texual form of execution plan when using the perfmon utility. From what 've read I need to select the "Performance: Execution Plan". Am unable to find this particluar entry. All the other SQLServer related entries (from 'Access Methods' to 'User Settable') appear - but I cannot see anything for Performance. Is there some setting/switch that needs to be enabled before this entry appears? Cheers! SQLCatz
Post Follow-up to this message
Re: Performance: Execution Plan ~ entry not in drop down list.You can't get that from Perfmon. You need to use Profiler for that. -- Andrew J. Kelly SQL MVP "SQLCatz" <SQLCatz@discussions.microsoft.com> wrote in message news:DAF653DC-62BE-4B8C-95A3- 2DD4781B0038@microso ft.com... > Hello, > I want to capture the texual form of execution plan when using the perfmon > utility. From what 've read I need to select the "Performance: Execution > Plan". Am unable to find this particluar entry. All the other SQLServer > related entries (from 'Access Methods' to 'User Settable') appear - but I > cannot see anything for Performance. Is there some setting/switch that > needs > to be enabled before this entry appears? > Cheers! > SQLCatz
Post Follow-up to this message Re: Performance: Execution Plan ~ entry not in drop down list.PerfMon captures system and software performance data, but not execution plans. Use Profiler and Query Analyzer instead. Profiler: select Show Statistics Profile QA: Run set statistics profile on and your query. Adrian "SQLCatz" <SQLCatz@discussions.microsoft.com> wrote in message news:DAF653DC-62BE-4B8C-95A3- 2DD4781B0038@microso ft.com... > Hello, > I want to capture the texual form of execution plan when using the perfmon > utility. From what 've read I need to select the "Performance: Execution > Plan". Am unable to find this particluar entry. All the other SQLServer > related entries (from 'Access Methods' to 'User Settable') appear - but I > cannot see anything for Performance. Is there some setting/switch that > needs > to be enabled before this entry appears? > Cheers! > SQLCatz
Post Follow-up to this message RE: Performance: Execution Plan ~ entry not in drop down list.Are you talking about profiler.exe or perfmon.exe? AMB "SQLCatz" wrote: > Hello, > I want to capture the texual form of execution plan when using the perfmon > utility. From what 've read I need to select the "Performance: Execution > Plan". Am unable to find this particluar entry. All the other SQLServer > related entries (from 'Access Methods' to 'User Settable') appear - but I > cannot see anything for Performance. Is there some setting/switch that nee ds > to be enabled before this entry appears? > Cheers! > SQLCatz
Post Follow-up to this message
Sponsored Links
Show a Printable Version
Email This Page to Someone!
Receive updates to this thread
