| Author |
Performance: Execution Plan ~ entry not in drop down list.
|
|
| SQLCatz 2005-03-31, 7:01 am |
| 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
| |
| Andrew J. Kelly 2005-03-31, 8:01 pm |
| 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
| |
| Adrian Zajkeskovic 2005-03-31, 8:01 pm |
| 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
| |
| Alejandro Mesa 2005-03-31, 8:01 pm |
| 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 needs
> to be enabled before this entry appears?
> Cheers!
> SQLCatz
|
|
|
|