BACK TO INDEX

Win32_PerfFormattedData_DTSPipeline_SQLServerSSISPipeline
The SSIS Pipeline object includes those counters related to the execution fo the pipeline.
NameSpace Path
\ROOT\CIMV2
PROPERTY	SMS_REPORT	CIMTYPE	DESCRIPTION
BLOBbytesread		UInt64	The number of BLOB bytes read from all data sources in total.
BLOBbyteswritten		UInt64	The number of BLOB bytes written to all data sources in total.
BLOBfilesinuse		UInt32	The number of BLOB spooling files in use throughout the pipeline.
Buffermemory		UInt64	The amount of memory allocated to buffers in the pipeline.
Buffersinuse		UInt32	The number of pipeline buffers in use throughout the pipeline.
Buffersspooled		UInt32	The number of buffers spooled to disk.
Caption		String	A short textual description (one-line string) for the statistic or metric.
Description		String	A textual description of the statistic or metric.
Flatbuffermemory		UInt64	The amount of memory allocated to flat memory buffers.
Flatbuffersinuse		UInt32	The number of flat memory buffers in use throughout the pipeline.
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.
Privatebuffermemory		UInt64	The amount of memory allocated to private transformation buffers.
Privatebuffersinuse		UInt32	The number of private transformation buffers in use throughout the pipeline.
Rowsread		UInt64	The number of rows read from all data sources in total.
Rowswritten		UInt64	The number of rows written to all data destinations in total.
Timestamp_Object		UInt64	NA
Timestamp_PerfTime		UInt64	NA
Timestamp_Sys100NS		UInt64	NA
SAMPLE DATA INSTANCE
[Description("The SSIS Pipeline object includes those counters related to the execution fo the pipeline."): ToInstance Amended, DisplayName("SQLServer:SSIS Pipeline"): ToInstance Amended, genericperfctr: ToInstance Amended, locale(1033): ToInstance Amended]    instance of Win32_PerfFormattedData_DTSPipeline_SQLServerSSISPipeline    {     [Description("The number of BLOB bytes read from all data sources in total."): ToInstance Amended, DisplayName("BLOB bytes read"): ToInstance Amended] BLOBbytesread = "0";     [Description("The number of BLOB bytes written to all data sources in total."): ToInstance Amended, DisplayName("BLOB bytes written"): ToInstance Amended] BLOBbyteswritten = "0";     [Description("The number of BLOB spooling files in use throughout the pipeline."): ToInstance Amended, DisplayName("BLOB files in use"): ToInstance Amended] BLOBfilesinuse = 0;     [Description("The amount of memory allocated to buffers in the pipeline."): ToInstance Amended, DisplayName("Buffer memory"): ToInstance Amended] Buffermemory = "0";     [Description("The number of pipeline buffers in use throughout the pipeline."): ToInstance Amended, DisplayName("Buffers in use"): ToInstance Amended] Buffersinuse = 0;     [Description("The number of buffers spooled to disk."): ToInstance Amended, DisplayName("Buffers spooled"): ToInstance Amended] Buffersspooled = 0;     [Description("The amount of memory allocated to flat memory buffers."): ToInstance Amended, DisplayName("Flat buffer memory"): ToInstance Amended] Flatbuffermemory = "0";     [Description("The number of flat memory buffers in use throughout the pipeline."): ToInstance Amended, DisplayName("Flat buffers in use"): ToInstance Amended] Flatbuffersinuse = 0;     [Description("The amount of memory allocated to private transformation buffers."): ToInstance Amended, DisplayName("Private buffer memory"): ToInstance Amended] Privatebuffermemory = "0";     [Description("The number of private transformation buffers in use throughout the pipeline."): ToInstance Amended, DisplayName("Private buffers in use"): ToInstance Amended] Privatebuffersinuse = 0;     [Description("The number of rows read from all data sources in total."): ToInstance Amended, DisplayName("Rows read"): ToInstance Amended] Rowsread = "0";     [Description("The number of rows written to all data destinations in total."): ToInstance Amended, DisplayName("Rows written"): ToInstance Amended] Rowswritten = "0";    };