| Win32_PerfFormattedData_msftesql_MSFTESQLCatalogs |
| Statistics per catalog |
| NameSpace Path |
| \ROOT\CIMV2 |
| PROPERTY | SMS_REPORT | CIMTYPE | DESCRIPTION |
| Batchesaborted | | UInt32 | Number of batches aborted to date. By definition the state of an aborted batch, how far some or all of its transactions got through the indexing process is unknown. These batches are retried by SQL. |
| Batchescompletedsuccess | | UInt32 | Number of batches completed without warnings or errors, to date. |
| BatchescompletedwPererrors | | UInt32 | Number of batches completed with one or more errors, to date. |
| BatchescompletedwPerwarnings | | UInt32 | Number of batches completed with warnings but no errors, to date. |
| Batchesdone | | UInt32 | Number of all batches completed or aborted to date. This counter is incremented after the completion status is sent to SQL. |
| BatchesFPC | | UInt32 | Number of current batches past filter phase complete. This counter is incremented after all the transactions in the batch are filtered by the filter daemon and given to the plugin(s) for processing. |
| Batchesinprogress | | UInt32 | Number of batches currently being processed. This counter is incremented when a batch of transactions is accepted by the MSFTESQL service and is decremented after the completion is sent or attempted to be sent back to the SQL process. |
| Batchesreceived | | UInt32 | Number of batches received to date. This counter is incremented when a batch of transactions is accepted by the MSFTESQL service. |
| Caption | | String | A short textual description (one-line string) for the statistic or metric. |
| Description | | String | A textual description of the statistic or metric. |
| Frequency_Object | | UInt64 | NA |
| Frequency_PerfTime | | UInt64 | NA |
| Frequency_Sys100NS | | UInt64 | NA |
| Name | | String | The Name property defines the label by which the statistic or metric is known. When subclassed, the property can be overridden to be a Key property. |
| Phasecomplete | | UInt32 | Number of transactions currently in the complete phase. |
| PhaseinHDFD | | UInt32 | Number of transactions currently in the huge document filter daemon phase. |
| PhaseinMTFD | | UInt32 | Number of transactions currently in the multi-threaded filter daemon phase. |
| Phaseinpipeline | | UInt32 | Number of transactions currently in the pipeline phase. |
| Phaseinreadyqueue | | UInt32 | Number of transactions currently in the ready queue phase. |
| PhaseinSTFD | | UInt32 | Number of transactions currently in the single-threaded filter daemon phase. |
| Phaseonhold | | UInt32 | Number of transactions currently in the on-hold phase. |
| Phasependingcompletion | | UInt32 | Number of transactions currently in the pending completion phase. |
| Phaseredundant | | UInt32 | Number of transactions currently in the redundant phase. |
| Requestabort | | UInt32 | Number of abort status change requests to date. |
| Requestasyncflush | | UInt32 | Number of async flush hints to date. |
| RequestflushPerdrain | | UInt32 | Number of flush/drain status change request to date. |
| Requestforcemerge | | UInt32 | Number of force merge async status change requests to date. |
| Requestpause | | UInt32 | Number of pause status change requests to date. |
| Requestreset | | UInt32 | Number of reset status change requests to date. |
| Requestresume | | UInt32 | Number of resume status change requests to date. |
| State | | UInt32 | Current project state. 0=Not Initialized; 1=Available; 2=Available with input queue near limit; 4=Shut down; 5=Paused from Status Change i.e. for backup; 6=Forced paused; 7=Draining; 8=Pipeline flushing; 9=Prepare to pause; 10=Pipline pausing; 11=Prepare to resume; 12=Aborting queues; 13=Draining FDs; 14=Pipeline aborting; 15=Pipeline resetting |
| StateCallerComponent | | UInt32 | Caller Component type identifies the type of component that has changed the project state. 0=n/a; 1=Ready queue; 2=Inprogress map; 3=Memory manager; 4=Plugin; 5=Self; 6=CB Master; 7=Pipeline; 8=Request task; 9=Property Id task; 10=FD manager; 11=Status change |
| StateReasoncode | | UInt32 | Reason code further defines the project state. 0=Clear; 1=Temporary from low resources; 2=Temporary connection problem; 3=Temporary other such as ongoing status change, status change failure, failure to start an FD, failure during merge, see State Caller and State HR; 4=Fatal error; 5=Reset needed |
| StateResultCode | | UInt32 | Result code that led to a change in project state. |
| Timestamp_Object | | UInt64 | NA |
| Timestamp_PerfTime | | UInt64 | NA |
| Timestamp_Sys100NS | | UInt64 | NA |
| Transdeletes | | UInt32 | Number of delete transactions to date |
| Transdone | | UInt32 | Number of transactions finished to date, includes success, warnings, errors, aborted. |
| Transerrored | | UInt32 | Number of transactions completed in error to date. |
| Transinprogress | | UInt32 | Number of transactions currently in progress |
| Transmodifies | | UInt32 | Number of modify transactions to date |
| Transrerouted | | UInt32 | Number of transactions rerouted from the multi-threaded filter daemon to the signle-threaded filter daemon to date. |
| SAMPLE DATA INSTANCE |
Invalid class
|
