PerfMonMode Property
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
The PerfMonMode property controls the polling behavior of System Monitor in Microsoft Windows when the monitor is started.
Syntax
object.PerfMonMode [= value]
Parts
object
An expression that evaluates to an object in the Applies To list.value
A long integer that specifies System Monitor polling behavior as described in Settings.
Data Type
Long, enumerated
Modifiable
Read/write
Prototype (C/C++)
HRESULT GetPerfMonMode(SQLDMO_PERFMON_TYPE* pRetVal);
HRESULT SetPerfMonMode(SQLDMO_PERFMON_TYPE NewValue);
Settings
Constant |
Value |
Description |
|---|---|---|
SQLDMOPerfmon_Continuous |
0 |
Configures System Monitor statistics polling using the operating system default time slice. |
SQLDMOPerfmon_None |
1000 |
The value is not valid. |
SQLDMOPerfmon_OnDemand |
1 |
Configures System Monitor to poll for statistics when directed to do so by the user. |
Remarks
The PerfMonMode property determines polling behavior as System Monitor is started. System Monitor polling behavior can be changed in System Monitor when the application has successfully started.