ImagesMetro
Table of contents
Search
Database engines
ALEN-PC\SQLSERVER2016
AdventureWorks2016CTP3
Objects by type
Datatypes
AccountNumber
Flag
Name
NameStyle
OrderNumber
Phone
Sales.SalesOrderDetailType_inmem
Sales.SalesOrderDetailType_ondisk
DDL triggers
tr_ddl_AUDIT
Fulltext catalogs
AW2014FullTextCatalog
Functions
AUDIT_fn_HexToStr
AUDIT_fn_SqlVariantToString
Security.customerAccessPredicate
ufnGetAccountingEndDate
ufnGetAccountingEndDate_native
ufnGetAccountingStartDate
ufnGetAccountingStartDate_native
ufnGetContactInformation
ufnGetDocumentStatusText
ufnGetDocumentStatusText_native
ufnGetProductDealerPrice
ufnGetProductListPrice
ufnGetProductStandardCost
ufnGetPurchaseOrderStatusText
ufnGetPurchaseOrderStatusText_native
ufnGetSalesOrderStatusText
ufnGetSalesOrderStatusText_native
ufnGetStock
ufnLeadingZeros
ufnLeadingZeros_native
Sales.vSalesOrderDetail_extended_inmem
Sales.vSalesOrderHeader_extended_inmem
Procedures
AUDIT_prc_AggregateReport
AUDIT_prc_Analyze
AUDIT_prc_DDLReport
AUDIT_prc_DeleteArchitecture
AUDIT_prc_Purge_AUDIT_LOG
AUDIT_prc_ReportingAddFilterValue
AUDIT_prc_ReportingEnd
AUDIT_prc_ReportingStart
AUDIT_prc_StandardReport
uspAddOrderTrackingEvent
uspGetBillOfMaterials
uspGetEmployeeManagers
uspGetManagerEmployees
uspGetOrderTrackingBySalesOrderID
uspGetOrderTrackingByTrackingNumber
uspGetWhereUsedProductID
uspLogError
uspPrintError
uspSearchCandidateResumes
Demo.usp_DemoInitSeed
Demo.usp_DemoReset
HumanResources.sp_GetEmployee_Person_Info_AsOf
HumanResources.sp_UpdateEmployee_Temporal
HumanResources.uspUpdateEmployeeHireInfo
HumanResources.uspUpdateEmployeeLogin
HumanResources.uspUpdateEmployeePersonalInfo
Person.sp_DeletePerson_Temporal
Person.sp_UpdatePerson_Temporal
Sales.usp_InsertSalesOrder_inmem
Sales.usp_InsertSalesOrder_ondisk
Sales.usp_UpdateSalesOrderShipInfo_inmem
Sales.usp_UpdateSalesOrderShipInfo_native
Sales.usp_UpdateSalesOrderShipInfo_ondisk
SQLCop.test
SQLCop.test Ad hoc distributed queries
SQLCop.test Agent Service
SQLCop.test Auto close
SQLCop.test Auto create statistics
SQLCop.test Auto Shrink
SQLCop.test Auto update statistics
SQLCop.test Buffer cache hit ratio
SQLCop.test Column collation does not match database default
SQLCop.test Column data types (Numeric vs. Int)
SQLCop.test Column Name Problems
SQLCop.test Columns of data type Text/nText
SQLCop.test Columns with float data type
SQLCop.test Columns with image data type
SQLCop.test Compatibility Level
SQLCop.test Database and Log files on the same disk
SQLCop.test Database collation
SQLCop.test Database Mail
SQLCop.test Decimal Size Problem
SQLCop.test Forwarded Records
SQLCop.test Fragmented Indexes
SQLCop.test Instant File Initialization
SQLCop.test Login Language
SQLCop.test Max degree of parallelism
SQLCop.test Missing Foreign Key Indexes
SQLCop.test Missing Foreign Keys
SQLCop.test Old Backups
SQLCop.test Ole Automation Procedures
SQLCop.test Orphaned Users
SQLCop.test Page life expectancy
SQLCop.test Procedures Named SP_
SQLCop.test Procedures that call undocumented procedures
SQLCop.test Procedures using dynamic SQL without sp_executesql
SQLCop.test Procedures with @@Identity
SQLCop.test Procedures With SET ROWCOUNT
SQLCop.test Procedures without SET NOCOUNT ON
SQLCop.test Service Account
SQLCop.test SMO and DMO
SQLCop.test Table name problems
SQLCop.test Tables that start with tbl
SQLCop.test Tables without a primary key
SQLCop.test Tables without any data
SQLCop.test UniqueIdentifier with NewId
SQLCop.test Unnamed Constraints
SQLCop.test User Aliases
SQLCop.test Varchar Size Problem
SQLCop.test Views with order by
SQLCop.test Wide Table
SQLCop.test xp_cmdshell is enabled
Roles
db_accessadmin
db_backupoperator
db_datareader
db_datawriter
db_ddladmin
db_denydatareader
db_denydatawriter
db_owner
db_securityadmin
public
SalesManagers
SalesPersons
Schemas
db_accessadmin
db_backupoperator
db_datareader
db_datawriter
db_ddladmin
db_denydatareader
db_denydatawriter
db_owner
db_securityadmin
dbo
Demo
guest
HumanResources
INFORMATION_SCHEMA
Person
Production
Purchasing
Sales
Security
SQLCop
sys
Tables
AUDIT_LOG_DATA
AUDIT_LOG_DDL
AUDIT_LOG_TRANSACTIONS
AWBuildVersion
DatabaseLog
ErrorLog
Demo.DemoSalesOrderDetailSeed
Demo.DemoSalesOrderHeaderSeed
HumanResources.Department
HumanResources.Employee
HumanResources.Employee_Temporal
HumanResources.Employee_Temporal_History
HumanResources.EmployeeDepartmentHistory
HumanResources.EmployeePayHistory
HumanResources.JobCandidate
HumanResources.Shift
Person.Address
Person.AddressType
Person.BusinessEntity
Person.BusinessEntityAddress
Person.BusinessEntityContact
Person.ContactType
Person.CountryRegion
Person.EmailAddress
Person.Password
Person.Person
Person.Person_json
Person.Person_Temporal
Person.Person_Temporal_History
Person.PersonPhone
Person.PhoneNumberType
Person.StateProvince
Production.BillOfMaterials
Production.Culture
Production.Document
Production.Illustration
Production.Location
Production.Product
Production.Product_inmem
Production.Product_ondisk
Production.ProductCategory
Production.ProductCostHistory
Production.ProductDescription
Production.ProductDocument
Production.ProductInventory
Production.ProductListPriceHistory
Production.ProductModel
Production.ProductModelIllustration
Production.ProductModelProductDescriptionCulture
Production.ProductPhoto
Production.ProductProductPhoto
Production.ProductReview
Production.ProductSubcategory
Production.ScrapReason
Production.TransactionHistory
Production.TransactionHistoryArchive
Production.UnitMeasure
Production.WorkOrder
Production.WorkOrderRouting
Purchasing.ProductVendor
Purchasing.PurchaseOrderDetail
Purchasing.PurchaseOrderHeader
Purchasing.ShipMethod
Purchasing.Vendor
Sales.CountryRegionCurrency
Sales.CreditCard
Sales.Currency
Sales.CurrencyRate
Sales.Customer
Sales.CustomerPII
Sales.OrderTracking
Sales.PersonCreditCard
Sales.SalesOrder_json
Sales.SalesOrderDetail
Sales.SalesOrderDetail_inmem
Sales.SalesOrderDetail_ondisk
Sales.SalesOrderHeader
Sales.SalesOrderHeader_inmem
Sales.SalesOrderHeader_ondisk
Sales.SalesOrderHeaderSalesReason
Sales.SalesPerson
Sales.SalesPersonQuotaHistory
Sales.SalesReason
Sales.SalesTaxRate
Sales.SalesTerritory
Sales.SalesTerritoryHistory
Sales.ShoppingCartItem
Sales.SpecialOffer
Sales.SpecialOffer_inmem
Sales.SpecialOffer_ondisk
Sales.SpecialOfferProduct
Sales.SpecialOfferProduct_inmem
Sales.SpecialOfferProduct_ondisk
Sales.Store
Sales.TrackingEvent
Triggers
tr_d_AUDIT_AWBuildVersion
tr_d_AUDIT_DatabaseLog
tr_d_AUDIT_ErrorLog
tr_i_AUDIT_DatabaseLog
tr_i_AUDIT_ErrorLog
tr_u_AUDIT_AWBuildVersion
tr_u_AUDIT_DatabaseLog
HumanResources.dEmployee
HumanResources.tr_d_AUDIT_Department
HumanResources.tr_d_AUDIT_Employee
HumanResources.tr_d_AUDIT_EmployeeDepartmentHistory
HumanResources.tr_d_AUDIT_EmployeePayHistory
HumanResources.tr_i_AUDIT_Department
HumanResources.tr_i_AUDIT_Employee
HumanResources.tr_i_AUDIT_EmployeeDepartmentHistory
HumanResources.tr_i_AUDIT_EmployeePayHistory
HumanResources.tr_u_AUDIT_Department
HumanResources.tr_u_AUDIT_Employee_Temporal
HumanResources.tr_u_AUDIT_EmployeeDepartmentHistory
HumanResources.tr_u_AUDIT_EmployeePayHistory
Person.iuPerson
Production.iWorkOrder
Production.uWorkOrder
Purchasing.dVendor
Purchasing.iPurchaseOrderDetail
Purchasing.uPurchaseOrderDetail
Purchasing.uPurchaseOrderHeader
Sales.iduSalesOrderDetail
Sales.uSalesOrderHeader
Users
amy0
brian3
david8
dbo
garrett1
guest
jae0
jillian0
josé1
linda3
lynn0
michael9
pamela0
rachel0
ranjit0
shu0
stephen0
syed0
tete0
tsvi0
Views
AUDIT_UNDO
AUDIT_VIEW
HumanResources.vEmployee
HumanResources.vEmployeeDepartment
HumanResources.vEmployeeDepartmentHistory
HumanResources.vEmployeePersonTemporalInfo
HumanResources.vJobCandidate
HumanResources.vJobCandidateEducation
HumanResources.vJobCandidateEmployment
Person.vAdditionalContactInfo
Person.vStateProvinceCountryRegion
Production.vProductAndDescription
Production.vProductModelCatalogDescription
Production.vProductModelInstructions
Purchasing.vVendorWithAddresses
Purchasing.vVendorWithContacts
Sales.vIndividualCustomer
Sales.vPersonDemographics
Sales.vSalesPerson
Sales.vSalesPersonSalesByFiscalYears
Sales.vStoreWithAddresses
Sales.vStoreWithContacts
Sales.vStoreWithDemographics
XML schema collections
HumanResources.HRResumeSchemaCollection
Person.AdditionalContactInfoSchemaCollection
Person.IndividualSurveySchemaCollection
Production.ManuInstructionsSchemaCollection
Production.ProductDescriptionSchemaCollection
Sales.StoreSurveySchemaCollection
Objects by schema
dbo
Datatypes
AccountNumber
Flag
Name
NameStyle
OrderNumber
Phone
Functions
AUDIT_fn_HexToStr
AUDIT_fn_SqlVariantToString
ufnGetAccountingEndDate
ufnGetAccountingEndDate_native
ufnGetAccountingStartDate
ufnGetAccountingStartDate_native
ufnGetContactInformation
ufnGetDocumentStatusText
ufnGetDocumentStatusText_native
ufnGetProductDealerPrice
ufnGetProductListPrice
ufnGetProductStandardCost
ufnGetPurchaseOrderStatusText
ufnGetPurchaseOrderStatusText_native
ufnGetSalesOrderStatusText
ufnGetSalesOrderStatusText_native
ufnGetStock
ufnLeadingZeros
ufnLeadingZeros_native
Procedures
AUDIT_prc_AggregateReport
AUDIT_prc_Analyze
AUDIT_prc_DDLReport
AUDIT_prc_DeleteArchitecture
AUDIT_prc_Purge_AUDIT_LOG
AUDIT_prc_ReportingAddFilterValue
AUDIT_prc_ReportingEnd
AUDIT_prc_ReportingStart
AUDIT_prc_StandardReport
uspAddOrderTrackingEvent
uspGetBillOfMaterials
uspGetEmployeeManagers
uspGetManagerEmployees
uspGetOrderTrackingBySalesOrderID
uspGetOrderTrackingByTrackingNumber
uspGetWhereUsedProductID
uspLogError
uspPrintError
uspSearchCandidateResumes
Tables
AUDIT_LOG_DATA
AUDIT_LOG_DDL
AUDIT_LOG_TRANSACTIONS
AWBuildVersion
DatabaseLog
ErrorLog
Triggers
tr_d_AUDIT_AWBuildVersion
tr_d_AUDIT_DatabaseLog
tr_d_AUDIT_ErrorLog
tr_i_AUDIT_DatabaseLog
tr_i_AUDIT_ErrorLog
tr_u_AUDIT_AWBuildVersion
tr_u_AUDIT_DatabaseLog
Views
AUDIT_UNDO
AUDIT_VIEW
Sales
Datatypes
Sales.SalesOrderDetailType_inmem
Sales.SalesOrderDetailType_ondisk
Functions
Sales.vSalesOrderDetail_extended_inmem
Sales.vSalesOrderHeader_extended_inmem
Procedures
Sales.usp_InsertSalesOrder_inmem
Sales.usp_InsertSalesOrder_ondisk
Sales.usp_UpdateSalesOrderShipInfo_inmem
Sales.usp_UpdateSalesOrderShipInfo_native
Sales.usp_UpdateSalesOrderShipInfo_ondisk
Tables
Sales.CountryRegionCurrency
Sales.CreditCard
Sales.Currency
Sales.CurrencyRate
Sales.Customer
Sales.CustomerPII
Sales.OrderTracking
Sales.PersonCreditCard
Sales.SalesOrder_json
Sales.SalesOrderDetail
Sales.SalesOrderDetail_inmem
Sales.SalesOrderDetail_ondisk
Sales.SalesOrderHeader
Sales.SalesOrderHeader_inmem
Sales.SalesOrderHeader_ondisk
Sales.SalesOrderHeaderSalesReason
Sales.SalesPerson
Sales.SalesPersonQuotaHistory
Sales.SalesReason
Sales.SalesTaxRate
Sales.SalesTerritory
Sales.SalesTerritoryHistory
Sales.ShoppingCartItem
Sales.SpecialOffer
Sales.SpecialOffer_inmem
Sales.SpecialOffer_ondisk
Sales.SpecialOfferProduct
Sales.SpecialOfferProduct_inmem
Sales.SpecialOfferProduct_ondisk
Sales.Store
Sales.TrackingEvent
Triggers
Sales.iduSalesOrderDetail
Sales.uSalesOrderHeader
Views
Sales.vIndividualCustomer
Sales.vPersonDemographics
Sales.vSalesPerson
Sales.vSalesPersonSalesByFiscalYears
Sales.vStoreWithAddresses
Sales.vStoreWithContacts
Sales.vStoreWithDemographics
XML schema collections
Sales.StoreSurveySchemaCollection
Security
Functions
Security.customerAccessPredicate
Demo
Procedures
Demo.usp_DemoInitSeed
Demo.usp_DemoReset
Tables
Demo.DemoSalesOrderDetailSeed
Demo.DemoSalesOrderHeaderSeed
HumanResources
Procedures
HumanResources.sp_GetEmployee_Person_Info_AsOf
HumanResources.sp_UpdateEmployee_Temporal
HumanResources.uspUpdateEmployeeHireInfo
HumanResources.uspUpdateEmployeeLogin
HumanResources.uspUpdateEmployeePersonalInfo
Tables
HumanResources.Department
HumanResources.Employee
HumanResources.Employee_Temporal
HumanResources.Employee_Temporal_History
HumanResources.EmployeeDepartmentHistory
HumanResources.EmployeePayHistory
HumanResources.JobCandidate
HumanResources.Shift
Triggers
HumanResources.dEmployee
HumanResources.tr_d_AUDIT_Department
HumanResources.tr_d_AUDIT_Employee
HumanResources.tr_d_AUDIT_EmployeeDepartmentHistory
HumanResources.tr_d_AUDIT_EmployeePayHistory
HumanResources.tr_i_AUDIT_Department
HumanResources.tr_i_AUDIT_Employee
HumanResources.tr_i_AUDIT_EmployeeDepartmentHistory
HumanResources.tr_i_AUDIT_EmployeePayHistory
HumanResources.tr_u_AUDIT_Department
HumanResources.tr_u_AUDIT_Employee_Temporal
HumanResources.tr_u_AUDIT_EmployeeDepartmentHistory
HumanResources.tr_u_AUDIT_EmployeePayHistory
Views
HumanResources.vEmployee
HumanResources.vEmployeeDepartment
HumanResources.vEmployeeDepartmentHistory
HumanResources.vEmployeePersonTemporalInfo
HumanResources.vJobCandidate
HumanResources.vJobCandidateEducation
HumanResources.vJobCandidateEmployment
XML schema collections
HumanResources.HRResumeSchemaCollection
Person
Procedures
Person.sp_DeletePerson_Temporal
Person.sp_UpdatePerson_Temporal
Tables
Person.Address
Person.AddressType
Person.BusinessEntity
Person.BusinessEntityAddress
Person.BusinessEntityContact
Person.ContactType
Person.CountryRegion
Person.EmailAddress
Person.Password
Person.Person
Person.Person_json
Person.Person_Temporal
Person.Person_Temporal_History
Person.PersonPhone
Person.PhoneNumberType
Person.StateProvince
Triggers
Person.iuPerson
Views
Person.vAdditionalContactInfo
Person.vStateProvinceCountryRegion
XML schema collections
Person.AdditionalContactInfoSchemaCollection
Person.IndividualSurveySchemaCollection
SQLCop
Procedures
SQLCop.test
SQLCop.test Ad hoc distributed queries
SQLCop.test Agent Service
SQLCop.test Auto close
SQLCop.test Auto create statistics
SQLCop.test Auto Shrink
SQLCop.test Auto update statistics
SQLCop.test Buffer cache hit ratio
SQLCop.test Column collation does not match database default
SQLCop.test Column data types (Numeric vs. Int)
SQLCop.test Column Name Problems
SQLCop.test Columns of data type Text/nText
SQLCop.test Columns with float data type
SQLCop.test Columns with image data type
SQLCop.test Compatibility Level
SQLCop.test Database and Log files on the same disk
SQLCop.test Database collation
SQLCop.test Database Mail
SQLCop.test Decimal Size Problem
SQLCop.test Forwarded Records
SQLCop.test Fragmented Indexes
SQLCop.test Instant File Initialization
SQLCop.test Login Language
SQLCop.test Max degree of parallelism
SQLCop.test Missing Foreign Key Indexes
SQLCop.test Missing Foreign Keys
SQLCop.test Old Backups
SQLCop.test Ole Automation Procedures
SQLCop.test Orphaned Users
SQLCop.test Page life expectancy
SQLCop.test Procedures Named SP_
SQLCop.test Procedures that call undocumented procedures
SQLCop.test Procedures using dynamic SQL without sp_executesql
SQLCop.test Procedures with @@Identity
SQLCop.test Procedures With SET ROWCOUNT
SQLCop.test Procedures without SET NOCOUNT ON
SQLCop.test Service Account
SQLCop.test SMO and DMO
SQLCop.test Table name problems
SQLCop.test Tables that start with tbl
SQLCop.test Tables without a primary key
SQLCop.test Tables without any data
SQLCop.test UniqueIdentifier with NewId
SQLCop.test Unnamed Constraints
SQLCop.test User Aliases
SQLCop.test Varchar Size Problem
SQLCop.test Views with order by
SQLCop.test Wide Table
SQLCop.test xp_cmdshell is enabled
Production
Tables
Production.BillOfMaterials
Production.Culture
Production.Document
Production.Illustration
Production.Location
Production.Product
Production.Product_inmem
Production.Product_ondisk
Production.ProductCategory
Production.ProductCostHistory
Production.ProductDescription
Production.ProductDocument
Production.ProductInventory
Production.ProductListPriceHistory
Production.ProductModel
Production.ProductModelIllustration
Production.ProductModelProductDescriptionCulture
Production.ProductPhoto
Production.ProductProductPhoto
Production.ProductReview
Production.ProductSubcategory
Production.ScrapReason
Production.TransactionHistory
Production.TransactionHistoryArchive
Production.UnitMeasure
Production.WorkOrder
Production.WorkOrderRouting
Triggers
Production.iWorkOrder
Production.uWorkOrder
Views
Production.vProductAndDescription
Production.vProductModelCatalogDescription
Production.vProductModelInstructions
XML schema collections
Production.ManuInstructionsSchemaCollection
Production.ProductDescriptionSchemaCollection
Purchasing
Tables
Purchasing.ProductVendor
Purchasing.PurchaseOrderDetail
Purchasing.PurchaseOrderHeader
Purchasing.ShipMethod
Purchasing.Vendor
Triggers
Purchasing.dVendor
Purchasing.iPurchaseOrderDetail
Purchasing.uPurchaseOrderDetail
Purchasing.uPurchaseOrderHeader
Views
Purchasing.vVendorWithAddresses
Purchasing.vVendorWithContacts
Database overview
Server info
Jobs
SSIS Server Maintenance Job
Schedules
SSISDB Scheduler
Steps
SSIS Server Operation Records Maintenance
SSIS Server Max Version Per Project Maintenance
syspolicy_purge_history
Schedules
syspolicy_purge_history_schedule
Steps
Verify that automation is enabled.
Purge history.
Erase Phantom System Health Records.
Logins
##MS_AgentSigningCertificate##
##MS_PolicyEventProcessingLogin##
##MS_PolicySigningCertificate##
##MS_PolicyTsqlExecutionLogin##
##MS_SmoExtendedSigningCertificate##
##MS_SQLAuthenticatorCertificate##
##MS_SQLEnableSystemAssemblyLoadingUser##
##MS_SQLReplicationSigningCertificate##
##MS_SQLResourceSigningCertificate##
##MS_SSISServerCleanupJobLogin##
Alen-PC\Alen
l_certSignSmDetach
NT AUTHORITY\NETWORK SERVICE
NT AUTHORITY\SYSTEM
NT Service\MSSQL$SQLSERVER2016
NT SERVICE\ReportServer$SQLSERVER2016
NT SERVICE\SQLAgent$SQLSERVER2016
NT SERVICE\SQLTELEMETRY$SQLSERVER2016
NT SERVICE\SQLWriter
NT SERVICE\Winmgmt
sa
Server roles
bulkadmin
dbcreator
diskadmin
processadmin
public
securityadmin
serveradmin
setupadmin
sysadmin
Server information
Package Files
AnalysisProcessingPackage
Configuration settings
Connection managers
localhost
Event handlers
Executables
Analysis Services Processing Task
Log Entry Information
Diagnostic
DiagnosticEx
Log providers
Project Parameters
Precedence constraints
Variables
BackUpDBTaskPackage
Configuration settings
Connection managers
serverbackup
Event handlers
Executables
Back Up Database Task
ExecuteSQLExecutingQuery
Log Entry Information
Diagnostic
DiagnosticEx
Log providers
Project Parameters
Precedence constraints
Variables
Integration services
ALEN-PC
PerfCountersCollect
Configuration settings
CacheDirectory
CacheWindow
InputParameters
MDWConnectionString
ConfigConnectionString
TargetConnectionString
LoopEventName
ExitEventName
CollectorTypeUID
CollectionSetUID
ItemID
InstanceID
InstanceName
LoggingLevel
LogID
ParentLogID
Connection managers
ConfigConnection
ConnectionString
CacheDirectory
CacheFilename
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
RowCountIn
RowCountOut
TargetConnectionString
TargetProcessID
Event handlers
Executables
LOOP - Aquire performance counters @ collection item frequency
Collect Upload Package Sync Sequence Container
DFT - Retrieve Performance Counters
Perfomance Counters Source
InputParameters
TxPerfCounters Output
path
formatted_value
raw_value_first
raw_value_second
counter_type
collection_time
object_name
counter_name
instance_name
RC - Number of counters collected
VariableName
Row Count Input 1
Row Count Output 1
RFD - Write to cache
AccessMode
FileName
FileNameVariable
WriteOption
Raw File Destination Input
collection_time
path
formatted_value
raw_value_first
raw_value_second
counter_type
object_name
instance_name
counter_name
path
formatted_value
raw_value_first
raw_value_second
counter_type
collection_time
object_name
counter_name
instance_name
BufferSizeTuning
PipelineBufferLeak
PipelineComponentTime
PipelineExecutionPlan
PipelineExecutionTrees
PipelineInitialization
Row Count Output 1
TxPerfCounters Output
SyncRoot
CacheDirectory
CacheFilename
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
RowCountIn
RowCountOut
TargetConnectionString
TargetProcessID
SyncRoot
CacheDirectory
CacheFilename
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
RowCountIn
RowCountOut
TargetConnectionString
TargetProcessID
Get SQL Process ID
ExecuteSQLExecutingQuery
SqlProcessID
CacheDirectory
CacheFilename
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
RowCountIn
RowCountOut
TargetConnectionString
TargetProcessID
No-Op Sequence Container
CacheDirectory
CacheFilename
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
RowCountIn
RowCountOut
TargetConnectionString
TargetProcessID
SQL - Log Package Iteration
ExecuteSQLExecutingQuery
CacheDirectory
CacheFilename
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
RowCountIn
RowCountOut
TargetConnectionString
TargetProcessID
SQL - Log Package Stats
ExecuteSQLExecutingQuery
CacheDirectory
CacheFilename
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
RowCountIn
RowCountOut
TargetConnectionString
TargetProcessID
{710AEAF2-45BD-4AB2-9EAF-FB6268AD10A2}
ExitEventName
LoopEventName
ExitEventName
LoopEventName
Constraint
Constraint 1
Constraint 2
Constraint 3
Constraint 4
CacheDirectory
CacheFilename
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
RowCountIn
RowCountOut
TargetConnectionString
TargetProcessID
Log Entry Information
Diagnostic
DiagnosticEx
Log providers
Project Parameters
Precedence constraints
Variables
CacheDirectory
CacheFilename
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
RowCountIn
RowCountOut
TargetConnectionString
TargetProcessID
PerfCountersUpload
Configuration settings
CacheDirectory
CacheWindow
InputParameters
MDWConnectionString
ConfigConnectionString
TargetConnectionString
LoopEventName
ExitEventName
CollectorTypeUID
CollectionSetUID
ItemID
InstanceID
InstanceName
LoggingLevel
LogID
ParentLogID
DaysUntilExpiration
Connection managers
ConfigConnection
ConnectionString
CacheDirectory
CacheFileName
CacheOutput
CacheUploadFilesPrefixPattern
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopEventName
MDWConnectionString
ParentLogID
SnapshotID
SourceID
TargetConnectionString
MdwConnection
ConnectionString
CacheDirectory
CacheFileName
CacheOutput
CacheUploadFilesPrefixPattern
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopEventName
MDWConnectionString
ParentLogID
SnapshotID
SourceID
TargetConnectionString
TargetConnection
ConnectionString
CacheDirectory
CacheFileName
CacheOutput
CacheUploadFilesPrefixPattern
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopEventName
MDWConnectionString
ParentLogID
SnapshotID
SourceID
TargetConnectionString
Event handlers
Executables
CWM - Delete Old Cache Files
CacheFileNamePrefixVarName
LoopDuration
CacheDirectory
CacheFileName
CacheOutput
CacheUploadFilesPrefixPattern
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopEventName
MDWConnectionString
ParentLogID
SnapshotID
SourceID
TargetConnectionString
FEF - For Each Collected Cache File Remaining, Try to Upload
DFT - Bulk Insert Collected data into MDW
DRV - Add snapshot id
Derived Column Input
collection_time
Derived Column Output
snapshot_id
Expression
FriendlyExpression
collect_time_convert
Expression
FriendlyExpression
Derived Column Error Output
ErrorCode
ErrorColumn
LKU - Lookup into performance_counter_instances to obtain performance_counter_id for all counter paths that get inserted
SqlCommand
SqlCommandParam
CacheType
MaxMemoryUsage
MaxMemoryUsage64
ReferenceMetadataXml
ParameterMap
DefaultCodePage
ConnectionType
NoMatchBehavior
NoMatchCachePercentage
TreatDuplicateKeysAsError
Lookup Input
path
JoinToReferenceColumn
CopyFromReferenceColumn
Lookup Match Output
performance_counter_id
CopyFromReferenceColumn
Lookup No Match Output
Lookup Error Output
ErrorCode
ErrorColumn
OleDbConnection
ODB - Fast upload data to performance_counter_values
CommandTimeout
OpenRowset
OpenRowsetVariable
SqlCommand
DefaultCodePage
AlwaysUseDefaultCodePage
AccessMode
FastLoadKeepIdentity
FastLoadKeepNulls
FastLoadOptions
FastLoadMaxInsertCommitSize
OLE DB Destination Input
performance_counter_instance_id
snapshot_id
collection_time
formatted_value
raw_value_first
raw_value_second
snapshot_id
raw_value_second
raw_value_first
formatted_value
performance_counter_id
collect_time_convert
OLE DB Destination Error Output
ErrorCode
ErrorColumn
OleDbConnection
RAW - Read current tempoary storage
AccessMode
FileName
FileNameVariable
Raw File Source Output
collection_time
path
formatted_value
raw_value_first
raw_value_second
counter_type
object_name
instance_name
counter_name
collection_time
path
formatted_value
raw_value_first
raw_value_second
counter_type
object_name
instance_name
counter_name
RC - Number of rows failed to insert
VariableName
Row Count Input 1
Row Count Output 1
RC - Number of rows from cache
VariableName
Row Count Input 1
Row Count Output 1
RC - Number of rows inserted
VariableName
Row Count Input 1
Row Count Output 1
BufferSizeTuning
PipelineBufferLeak
PipelineComponentTime
PipelineExecutionPlan
PipelineExecutionTrees
PipelineInitialization
Derived Column Output
Failed Rows
Lookup Match Output
Raw File Source Output
Row Count Output 1
Row Count Output 1
CacheFileToUpload
LoopDuration
RowCountError
RowCountIn
RowCountOut
RowCountOutFinal
CacheDirectory
CacheFileName
CacheOutput
CacheUploadFilesPrefixPattern
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopEventName
MDWConnectionString
ParentLogID
SnapshotID
SourceID
TargetConnectionString
DFT - Update perf_counters_instances table with newly discovered instances
ODB - Fast upload data to performance_counters_instances for the new instance path-s that we discovered (together with thier type)
CommandTimeout
OpenRowset
OpenRowsetVariable
SqlCommand
DefaultCodePage
AlwaysUseDefaultCodePage
AccessMode
FastLoadKeepIdentity
FastLoadKeepNulls
FastLoadOptions
FastLoadMaxInsertCommitSize
OLE DB Destination Input
performance_counter_id
path
counter_type
object_name
counter_name
instance_name
path
counter_type
object_name
counter_name
instance_name
OLE DB Destination Error Output
ErrorCode
ErrorColumn
OleDbConnection
RAW - Read current tempoary storage - purpose - obtain counter paths
AccessMode
FileName
FileNameVariable
Raw File Source Output
collection_time
path
formatted_value
raw_value_first
raw_value_second
counter_type
object_name
instance_name
counter_name
collection_time
path
formatted_value
raw_value_first
raw_value_second
counter_type
object_name
instance_name
counter_name
BufferSizeTuning
PipelineBufferLeak
PipelineComponentTime
PipelineExecutionPlan
PipelineExecutionTrees
PipelineInitialization
Raw File Source Output
CacheFileToUpload
LoopDuration
RowCountError
RowCountIn
RowCountOut
RowCountOutFinal
CacheDirectory
CacheFileName
CacheOutput
CacheUploadFilesPrefixPattern
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopEventName
MDWConnectionString
ParentLogID
SnapshotID
SourceID
TargetConnectionString
FST - Cleanup
FileSystemOperation
CacheFileToUpload
LoopDuration
RowCountError
RowCountIn
RowCountOut
RowCountOutFinal
CacheDirectory
CacheFileName
CacheOutput
CacheUploadFilesPrefixPattern
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopEventName
MDWConnectionString
ParentLogID
SnapshotID
SourceID
TargetConnectionString
SQL - Log Package Stats
ExecuteSQLExecutingQuery
CacheFileToUpload
LoopDuration
RowCountError
RowCountIn
RowCountOut
RowCountOutFinal
CacheDirectory
CacheFileName
CacheOutput
CacheUploadFilesPrefixPattern
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopEventName
MDWConnectionString
ParentLogID
SnapshotID
SourceID
TargetConnectionString
{EE8E4F57-1623-455B-B0B2-ABCCA165FFB5}
Directory
FileSpec
Directory
FileSpec
Constraint
Constraint 1
Constraint 2
CacheFileToUpload
LoopDuration
RowCountError
RowCountIn
RowCountOut
RowCountOutFinal
CacheDirectory
CacheFileName
CacheOutput
CacheUploadFilesPrefixPattern
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopEventName
MDWConnectionString
ParentLogID
SnapshotID
SourceID
TargetConnectionString
Sequence Container
FAT - Check Current Cache File Exists
FilePath
Mode
SyncRoot
CacheDirectory
CacheFileName
CacheOutput
CacheUploadFilesPrefixPattern
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopEventName
MDWConnectionString
ParentLogID
SnapshotID
SourceID
TargetConnectionString
FST - Rename Current Cache File
FileSystemOperation
SyncRoot
CacheDirectory
CacheFileName
CacheOutput
CacheUploadFilesPrefixPattern
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopEventName
MDWConnectionString
ParentLogID
SnapshotID
SourceID
TargetConnectionString
Constraint
SyncRoot
CacheDirectory
CacheFileName
CacheOutput
CacheUploadFilesPrefixPattern
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopEventName
MDWConnectionString
ParentLogID
SnapshotID
SourceID
TargetConnectionString
SQL - Create snapshot ID in MDW
ExecuteSQLExecutingQuery
CacheDirectory
CacheFileName
CacheOutput
CacheUploadFilesPrefixPattern
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopEventName
MDWConnectionString
ParentLogID
SnapshotID
SourceID
TargetConnectionString
SQL - Register collection set to MDW
ExecuteSQLExecutingQuery
CacheDirectory
CacheFileName
CacheOutput
CacheUploadFilesPrefixPattern
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopEventName
MDWConnectionString
ParentLogID
SnapshotID
SourceID
TargetConnectionString
Log Entry Information
Diagnostic
DiagnosticEx
Log providers
Project Parameters
Precedence constraints
Constraint 2
Constraint 3
Constraint 4
Constraint 5
Variables
CacheDirectory
CacheFileName
CacheOutput
CacheUploadFilesPrefixPattern
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopEventName
MDWConnectionString
ParentLogID
SnapshotID
SourceID
TargetConnectionString
QueryActivityCollect
Configuration settings
CacheDirectory
CacheWindow
InputParameters
MDWConnectionString
ConfigConnectionString
TargetConnectionString
LoopEventName
ExitEventName
CollectorTypeUID
CollectionSetUID
ItemID
InstanceID
InstanceName
LoggingLevel
LogID
ParentLogID
DaysUntilExpiration
Connection managers
ConfigConnection
ConnectionString
CacheDirectory
CacheFilePrefixPattern
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
SnapshotExecRequestQuery
TargetConnectionString
MdwConnection
ConnectionString
CacheDirectory
CacheFilePrefixPattern
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
SnapshotExecRequestQuery
TargetConnectionString
TargetConnection
ConnectionString
CacheDirectory
CacheFilePrefixPattern
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
SnapshotExecRequestQuery
TargetConnectionString
Event handlers
Executables
LOOP - Query the query statitics DMV at collection frequency
SEQ - Synchronize Access to Cache File
DFT - Collect DMV Data
CNT - Error row count
VariableName
Row Count Input 1
Row Count Output 1
CNT - Input row count
VariableName
Row Count Input 1
Row Count Output 1
ODS - Get snapshot of dm_exec_requests
CommandTimeout
OpenRowset
OpenRowsetVariable
SqlCommand
SqlCommandVariable
DefaultCodePage
AlwaysUseDefaultCodePage
AccessMode
ParameterMapping
OLE DB Source Output
sql_handle
statement_start_offset
statement_end_offset
plan_handle
collection_time
row_id
session_id
request_id
exec_context_id
blocking_session_id
is_blocking
blocking_exec_context_id
scheduler_id
database_name
user_id
task_state
request_status
session_status
executing_managed_code
login_time
is_user_process
host_name
program_name
login_name
wait_type
last_wait_type
wait_duration_ms
wait_resource
resource_description
transaction_id
open_transaction_count
transaction_isolation_level
request_cpu_time
request_logical_reads
request_reads
request_writes
request_total_elapsed_time
request_start_time
memory_usage
session_cpu_time
session_reads
session_writes
session_logical_reads
session_total_scheduled_time
session_total_elapsed_time
open_resultsets
session_row_count
prev_error
pending_io_count
command
last_request_start_time
last_request_end_time
statement_start_offset
statement_end_offset
collection_time
sql_handle
plan_handle
row_id
session_id
request_id
exec_context_id
blocking_session_id
is_blocking
blocking_exec_context_id
scheduler_id
database_name
user_id
task_state
request_status
session_status
executing_managed_code
login_time
is_user_process
host_name
program_name
login_name
wait_type
last_wait_type
wait_duration_ms
wait_resource
resource_description
transaction_id
open_transaction_count
transaction_isolation_level
request_cpu_time
request_logical_reads
request_reads
request_writes
request_total_elapsed_time
request_start_time
memory_usage
session_cpu_time
session_reads
session_writes
session_logical_reads
session_total_scheduled_time
session_total_elapsed_time
open_resultsets
session_row_count
prev_error
pending_io_count
command
last_request_start_time
last_request_end_time
OLE DB Source Error Output
row_id
session_id
request_id
exec_context_id
blocking_session_id
is_blocking
blocking_exec_context_id
scheduler_id
database_name
user_id
task_state
request_status
session_status
executing_managed_code
login_time
is_user_process
host_name
program_name
login_name
wait_type
last_wait_type
wait_duration_ms
wait_resource
resource_description
transaction_id
open_transaction_count
transaction_isolation_level
request_cpu_time
request_logical_reads
request_reads
request_writes
request_total_elapsed_time
request_start_time
memory_usage
session_cpu_time
session_reads
session_writes
session_logical_reads
session_total_scheduled_time
session_total_elapsed_time
last_request_start_time
last_request_end_time
open_resultsets
session_row_count
prev_error
pending_io_count
command
statement_start_offset
statement_end_offset
collection_time
ErrorCode
ErrorColumn
sql_handle
plan_handle
OleDbConnection
RFD - Write data to a cache
AccessMode
FileName
FileNameVariable
WriteOption
Raw File Destination Input
statement_start_offset
statement_end_offset
collection_time
sql_handle
plan_handle
row_id
session_id
request_id
exec_context_id
blocking_session_id
is_blocking
blocking_exec_context_id
scheduler_id
database_name
user_id
task_state
request_status
session_status
executing_managed_code
login_time
is_user_process
host_name
program_name
login_name
wait_type
last_wait_type
wait_duration_ms
wait_resource
resource_description
transaction_id
open_transaction_count
transaction_isolation_level
request_cpu_time
request_logical_reads
request_reads
request_writes
request_total_elapsed_time
request_start_time
memory_usage
session_cpu_time
session_reads
session_writes
session_logical_reads
session_total_scheduled_time
session_total_elapsed_time
session_last_request_start_time
session_last_request_end_time
open_resultsets
session_row_count
prev_error
pending_io_count
command
statement_start_offset
statement_end_offset
collection_time
sql_handle
plan_handle
row_id
session_id
request_id
exec_context_id
blocking_session_id
is_blocking
blocking_exec_context_id
scheduler_id
database_name
user_id
task_state
request_status
session_status
executing_managed_code
login_time
is_user_process
host_name
program_name
login_name
wait_type
last_wait_type
wait_duration_ms
wait_resource
resource_description
transaction_id
open_transaction_count
transaction_isolation_level
request_cpu_time
request_logical_reads
request_reads
request_writes
request_total_elapsed_time
request_start_time
memory_usage
session_cpu_time
session_reads
session_writes
session_logical_reads
session_total_scheduled_time
session_total_elapsed_time
last_request_start_time
last_request_end_time
open_resultsets
session_row_count
prev_error
pending_io_count
command
BufferSizeTuning
PipelineBufferLeak
PipelineComponentTime
PipelineExecutionPlan
PipelineExecutionTrees
PipelineInitialization
OLE DB Source Error Output
OLE DB Source Output
Row Count Output 1
CacheFileName
SyncRoot
DMVErrorRowCount
DMVInOutRowCount
CacheDirectory
CacheFilePrefixPattern
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
SnapshotExecRequestQuery
TargetConnectionString
SyncRoot
DMVErrorRowCount
DMVInOutRowCount
CacheDirectory
CacheFilePrefixPattern
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
SnapshotExecRequestQuery
TargetConnectionString
SQL - Log Package Iteration
ExecuteSQLExecutingQuery
DMVErrorRowCount
DMVInOutRowCount
CacheDirectory
CacheFilePrefixPattern
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
SnapshotExecRequestQuery
TargetConnectionString
SQL - Log Package Stats
ExecuteSQLExecutingQuery
DMVErrorRowCount
DMVInOutRowCount
CacheDirectory
CacheFilePrefixPattern
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
SnapshotExecRequestQuery
TargetConnectionString
{7283E196-D60C-438F-A58A-0EA1F41BBCF4}
ExitEventName
LoopEventName
ExitEventName
LoopEventName
Constraint
Constraint 1
DMVErrorRowCount
DMVInOutRowCount
CacheDirectory
CacheFilePrefixPattern
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
SnapshotExecRequestQuery
TargetConnectionString
Log Entry Information
Diagnostic
DiagnosticEx
Log providers
Project Parameters
Precedence constraints
Variables
CacheDirectory
CacheFilePrefixPattern
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
SnapshotExecRequestQuery
TargetConnectionString
QueryActivityUpload
Configuration settings
CacheDirectory
CacheWindow
InputParameters
MDWConnectionString
ConfigConnectionString
TargetConnectionString
LoopEventName
ExitEventName
CollectorTypeUID
CollectionSetUID
ItemID
InstanceID
InstanceName
LoggingLevel
LogID
ParentLogID
DaysUntilExpiration
Connection managers
ConfigConnection
ConnectionString
CacheDirectory
CacheWindow
CollectionCacheFileName
CollectionCacheFileNameOutput
CollectionCacheFilePrefixPattern
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
InterestingQueries_HighCpuUsage
InterestingQueries_HighIoCount
InterestingQueries_HighMemoryUsage
InterestingQueries_HighTransactionCount
InterestingQueries_LargeResultset
InterestingQueries_LongRunningRequest
InterestingQueries_LongWaitingRequest
InterestingQueriesCount
InterestingQueriesLastSnapshotFileName
InterestingQueriesLastSnapshotFileNameOutput
InterestingQueriesSnapshotFileNamePrefixPattern
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
SnapshotId
SnapshotQueryStatsQuery
SourceId
TargetConnectionString
TopThreshold
ConfigConnection2
ConnectionString
CacheDirectory
CacheWindow
CollectionCacheFileName
CollectionCacheFileNameOutput
CollectionCacheFilePrefixPattern
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
InterestingQueries_HighCpuUsage
InterestingQueries_HighIoCount
InterestingQueries_HighMemoryUsage
InterestingQueries_HighTransactionCount
InterestingQueries_LargeResultset
InterestingQueries_LongRunningRequest
InterestingQueries_LongWaitingRequest
InterestingQueriesCount
InterestingQueriesLastSnapshotFileName
InterestingQueriesLastSnapshotFileNameOutput
InterestingQueriesSnapshotFileNamePrefixPattern
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
SnapshotId
SnapshotQueryStatsQuery
SourceId
TargetConnectionString
TopThreshold
MdwConnection
ConnectionString
CacheDirectory
CacheWindow
CollectionCacheFileName
CollectionCacheFileNameOutput
CollectionCacheFilePrefixPattern
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
InterestingQueries_HighCpuUsage
InterestingQueries_HighIoCount
InterestingQueries_HighMemoryUsage
InterestingQueries_HighTransactionCount
InterestingQueries_LargeResultset
InterestingQueries_LongRunningRequest
InterestingQueries_LongWaitingRequest
InterestingQueriesCount
InterestingQueriesLastSnapshotFileName
InterestingQueriesLastSnapshotFileNameOutput
InterestingQueriesSnapshotFileNamePrefixPattern
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
SnapshotId
SnapshotQueryStatsQuery
SourceId
TargetConnectionString
TopThreshold
TargetConnection
ConnectionString
CacheDirectory
CacheWindow
CollectionCacheFileName
CollectionCacheFileNameOutput
CollectionCacheFilePrefixPattern
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
InterestingQueries_HighCpuUsage
InterestingQueries_HighIoCount
InterestingQueries_HighMemoryUsage
InterestingQueries_HighTransactionCount
InterestingQueries_LargeResultset
InterestingQueries_LongRunningRequest
InterestingQueries_LongWaitingRequest
InterestingQueriesCount
InterestingQueriesLastSnapshotFileName
InterestingQueriesLastSnapshotFileNameOutput
InterestingQueriesSnapshotFileNamePrefixPattern
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
SnapshotId
SnapshotQueryStatsQuery
SourceId
TargetConnectionString
TopThreshold
Event handlers
Executables
CWM - Remove Upload Snapshots Older Than CacheWindow
CacheFileNamePrefixVarName
CacheDirectory
CacheWindow
CollectionCacheFileName
CollectionCacheFileNameOutput
CollectionCacheFilePrefixPattern
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
InterestingQueries_HighCpuUsage
InterestingQueries_HighIoCount
InterestingQueries_HighMemoryUsage
InterestingQueries_HighTransactionCount
InterestingQueries_LargeResultset
InterestingQueries_LongRunningRequest
InterestingQueries_LongWaitingRequest
InterestingQueriesCount
InterestingQueriesLastSnapshotFileName
InterestingQueriesLastSnapshotFileNameOutput
InterestingQueriesSnapshotFileNamePrefixPattern
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
SnapshotId
SnapshotQueryStatsQuery
SourceId
TargetConnectionString
TopThreshold
FAT - Check Cache File Exists
FilePath
Mode
CacheDirectory
CacheWindow
CollectionCacheFileName
CollectionCacheFileNameOutput
CollectionCacheFilePrefixPattern
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
InterestingQueries_HighCpuUsage
InterestingQueries_HighIoCount
InterestingQueries_HighMemoryUsage
InterestingQueries_HighTransactionCount
InterestingQueries_LargeResultset
InterestingQueries_LongRunningRequest
InterestingQueries_LongWaitingRequest
InterestingQueriesCount
InterestingQueriesLastSnapshotFileName
InterestingQueriesLastSnapshotFileNameOutput
InterestingQueriesSnapshotFileNamePrefixPattern
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
SnapshotId
SnapshotQueryStatsQuery
SourceId
TargetConnectionString
TopThreshold
FEF - For each collected cache file try upload
DFT - Upload collection snapshot
DRV - Add snapshot_id column
Derived Column Input
Derived Column Output
snapshot_id
Expression
FriendlyExpression
Derived Column Error Output
ErrorCode
ErrorColumn
ODS - Upload snapshots into active_sessions_and_requests table
CommandTimeout
OpenRowset
OpenRowsetVariable
SqlCommand
DefaultCodePage
AlwaysUseDefaultCodePage
AccessMode
FastLoadKeepIdentity
FastLoadKeepNulls
FastLoadOptions
FastLoadMaxInsertCommitSize
OLE DB Destination Input
row_id
session_id
request_id
exec_context_id
blocking_session_id
is_blocking
blocking_exec_context_id
scheduler_id
database_name
user_id
task_state
request_status
session_status
executing_managed_code
login_time
is_user_process
host_name
program_name
login_name
wait_type
last_wait_type
wait_duration_ms
wait_resource
resource_description
transaction_id
open_transaction_count
transaction_isolation_level
request_cpu_time
request_logical_reads
request_reads
request_writes
request_total_elapsed_time
request_start_time
memory_usage
session_cpu_time
session_reads
session_writes
session_logical_reads
session_total_scheduled_time
session_total_elapsed_time
session_last_request_start_time
session_last_request_end_time
open_resultsets
session_row_count
prev_error
pending_io_count
command
plan_handle
sql_handle
statement_start_offset
statement_end_offset
collection_time
snapshot_id
sql_handle
statement_start_offset
statement_end_offset
plan_handle
collection_time
row_id
session_id
request_id
exec_context_id
blocking_session_id
is_blocking
blocking_exec_context_id
scheduler_id
database_name
user_id
task_state
request_status
session_status
executing_managed_code
login_time
is_user_process
host_name
program_name
login_name
wait_type
last_wait_type
wait_duration_ms
wait_resource
resource_description
transaction_id
open_transaction_count
transaction_isolation_level
request_cpu_time
request_logical_reads
request_reads
request_writes
request_total_elapsed_time
request_start_time
memory_usage
session_cpu_time
session_reads
session_writes
session_logical_reads
session_total_scheduled_time
session_total_elapsed_time
session_last_request_start_time
session_last_request_end_time
open_resultsets
session_row_count
prev_error
pending_io_count
command
snapshot_id
OLE DB Destination Error Output
ErrorCode
ErrorColumn
OleDbConnection
RC - Count output rows
VariableName
Row Count Input 1
Row Count Output 1
RFS - Read Current Upload Data
AccessMode
FileName
FileNameVariable
Raw File Source Output
sql_handle
statement_start_offset
statement_end_offset
plan_handle
collection_time
row_id
session_id
request_id
exec_context_id
blocking_session_id
is_blocking
blocking_exec_context_id
scheduler_id
database_name
user_id
task_state
request_status
session_status
executing_managed_code
login_time
is_user_process
host_name
program_name
login_name
wait_type
last_wait_type
wait_duration_ms
wait_resource
resource_description
transaction_id
open_transaction_count
transaction_isolation_level
request_cpu_time
request_logical_reads
request_reads
request_writes
request_total_elapsed_time
request_start_time
memory_usage
session_cpu_time
session_reads
session_writes
session_logical_reads
session_total_scheduled_time
session_total_elapsed_time
session_last_request_start_time
session_last_request_end_time
open_resultsets
session_row_count
prev_error
pending_io_count
command
sql_handle
statement_start_offset
statement_end_offset
plan_handle
collection_time
row_id
session_id
request_id
exec_context_id
blocking_session_id
is_blocking
blocking_exec_context_id
scheduler_id
database_name
user_id
task_state
request_status
session_status
executing_managed_code
login_time
is_user_process
host_name
program_name
login_name
wait_type
last_wait_type
wait_duration_ms
wait_resource
resource_description
transaction_id
open_transaction_count
transaction_isolation_level
request_cpu_time
request_logical_reads
request_reads
request_writes
request_total_elapsed_time
request_start_time
memory_usage
session_cpu_time
session_reads
session_writes
session_logical_reads
session_total_scheduled_time
session_total_elapsed_time
session_last_request_start_time
session_last_request_end_time
open_resultsets
session_row_count
prev_error
pending_io_count
command
BufferSizeTuning
PipelineBufferLeak
PipelineComponentTime
PipelineExecutionPlan
PipelineExecutionTrees
PipelineInitialization
Derived Column Output
Raw File Source Output
Row Count Output 1
CurrentCollectionCacheFileName
RowCount
CacheDirectory
CacheWindow
CollectionCacheFileName
CollectionCacheFileNameOutput
CollectionCacheFilePrefixPattern
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
InterestingQueries_HighCpuUsage
InterestingQueries_HighIoCount
InterestingQueries_HighMemoryUsage
InterestingQueries_HighTransactionCount
InterestingQueries_LargeResultset
InterestingQueries_LongRunningRequest
InterestingQueries_LongWaitingRequest
InterestingQueriesCount
InterestingQueriesLastSnapshotFileName
InterestingQueriesLastSnapshotFileNameOutput
InterestingQueriesSnapshotFileNamePrefixPattern
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
SnapshotId
SnapshotQueryStatsQuery
SourceId
TargetConnectionString
TopThreshold
FST - Delete uploaded cache file
FileSystemOperation
CurrentCollectionCacheFileName
RowCount
CacheDirectory
CacheWindow
CollectionCacheFileName
CollectionCacheFileNameOutput
CollectionCacheFilePrefixPattern
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
InterestingQueries_HighCpuUsage
InterestingQueries_HighIoCount
InterestingQueries_HighMemoryUsage
InterestingQueries_HighTransactionCount
InterestingQueries_LargeResultset
InterestingQueries_LongRunningRequest
InterestingQueries_LongWaitingRequest
InterestingQueriesCount
InterestingQueriesLastSnapshotFileName
InterestingQueriesLastSnapshotFileNameOutput
InterestingQueriesSnapshotFileNamePrefixPattern
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
SnapshotId
SnapshotQueryStatsQuery
SourceId
TargetConnectionString
TopThreshold
SQL - Log Package Iteration
ExecuteSQLExecutingQuery
CurrentCollectionCacheFileName
RowCount
CacheDirectory
CacheWindow
CollectionCacheFileName
CollectionCacheFileNameOutput
CollectionCacheFilePrefixPattern
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
InterestingQueries_HighCpuUsage
InterestingQueries_HighIoCount
InterestingQueries_HighMemoryUsage
InterestingQueries_HighTransactionCount
InterestingQueries_LargeResultset
InterestingQueries_LongRunningRequest
InterestingQueries_LongWaitingRequest
InterestingQueriesCount
InterestingQueriesLastSnapshotFileName
InterestingQueriesLastSnapshotFileNameOutput
InterestingQueriesSnapshotFileNamePrefixPattern
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
SnapshotId
SnapshotQueryStatsQuery
SourceId
TargetConnectionString
TopThreshold
SQL - Log Package Stats
ExecuteSQLExecutingQuery
CurrentCollectionCacheFileName
RowCount
CacheDirectory
CacheWindow
CollectionCacheFileName
CollectionCacheFileNameOutput
CollectionCacheFilePrefixPattern
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
InterestingQueries_HighCpuUsage
InterestingQueries_HighIoCount
InterestingQueries_HighMemoryUsage
InterestingQueries_HighTransactionCount
InterestingQueries_LargeResultset
InterestingQueries_LongRunningRequest
InterestingQueries_LongWaitingRequest
InterestingQueriesCount
InterestingQueriesLastSnapshotFileName
InterestingQueriesLastSnapshotFileNameOutput
InterestingQueriesSnapshotFileNamePrefixPattern
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
SnapshotId
SnapshotQueryStatsQuery
SourceId
TargetConnectionString
TopThreshold
{BB52AFAE-60A1-42A7-9C13-52B21293D219}
Directory
FileSpec
Directory
FileSpec
Constraint
Constraint 1
Constraint 2
CurrentCollectionCacheFileName
RowCount
CacheDirectory
CacheWindow
CollectionCacheFileName
CollectionCacheFileNameOutput
CollectionCacheFilePrefixPattern
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
InterestingQueries_HighCpuUsage
InterestingQueries_HighIoCount
InterestingQueries_HighMemoryUsage
InterestingQueries_HighTransactionCount
InterestingQueries_LargeResultset
InterestingQueries_LongRunningRequest
InterestingQueries_LongWaitingRequest
InterestingQueriesCount
InterestingQueriesLastSnapshotFileName
InterestingQueriesLastSnapshotFileNameOutput
InterestingQueriesSnapshotFileNamePrefixPattern
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
SnapshotId
SnapshotQueryStatsQuery
SourceId
TargetConnectionString
TopThreshold
SEQ - Capture and analyze query statistics and query plan and text
DFT - Create Interesting Queries Last Snapshot
DC - Add the SnapshotId Column
Derived Column Input
Derived Column Output
snapshot_id
Expression
FriendlyExpression
Derived Column Error Output
ErrorCode
ErrorColumn
OLE DB Source
CommandTimeout
OpenRowset
OpenRowsetVariable
SqlCommand
SqlCommandVariable
DefaultCodePage
AlwaysUseDefaultCodePage
AccessMode
ParameterMapping
OLE DB Source Output
sql_handle
statement_start_offset
statement_end_offset
plan_generation_num
plan_handle
creation_time
last_execution_time
execution_count
total_worker_time
min_worker_time
max_worker_time
total_physical_reads
min_physical_reads
max_physical_reads
total_logical_writes
min_logical_writes
max_logical_writes
total_logical_reads
min_logical_reads
max_logical_reads
total_clr_time
min_clr_time
max_clr_time
total_elapsed_time
min_elapsed_time
max_elapsed_time
collection_time
sql_handle
statement_start_offset
statement_end_offset
plan_generation_num
plan_handle
creation_time
last_execution_time
execution_count
total_worker_time
min_worker_time
max_worker_time
total_physical_reads
min_physical_reads
max_physical_reads
total_logical_writes
min_logical_writes
max_logical_writes
total_logical_reads
min_logical_reads
max_logical_reads
total_clr_time
min_clr_time
max_clr_time
total_elapsed_time
min_elapsed_time
max_elapsed_time
collection_time
OLE DB Source Error Output
sql_handle
statement_start_offset
statement_end_offset
plan_generation_num
plan_handle
creation_time
last_execution_time
execution_count
total_worker_time
min_worker_time
max_worker_time
total_physical_reads
min_physical_reads
max_physical_reads
total_logical_writes
min_logical_writes
max_logical_writes
total_logical_reads
min_logical_reads
max_logical_reads
total_clr_time
min_clr_time
max_clr_time
total_elapsed_time
min_elapsed_time
max_elapsed_time
collection_time
ErrorCode
ErrorColumn
OleDbConnection
RC - Row count from dm_exec_query_stats
VariableName
Row Count Input 1
Row Count Output 1
RFD - Write Last Snapshot
AccessMode
FileName
FileNameVariable
WriteOption
Raw File Destination Input
sql_handle
statement_start_offset
statement_end_offset
plan_generation_num
plan_handle
creation_time
last_execution_time
execution_count
total_worker_time
total_physical_reads
total_logical_writes
total_logical_reads
total_clr_time
total_elapsed_time
max_worker_time
min_worker_time
min_physical_reads
max_physical_reads
min_logical_writes
max_logical_writes
min_logical_reads
max_logical_reads
min_clr_time
max_clr_time
min_elapsed_time
max_elapsed_time
snapshot_id
collection_time
BufferSizeTuning
PipelineBufferLeak
PipelineComponentTime
PipelineExecutionPlan
PipelineExecutionTrees
PipelineInitialization
Derived Column Output
OLE DB Source Output
Row Count Output 1
InterestingQueriesRowCountIn
InterestingQueriesRowCountOut
SqlPlanRowCountError
SqlPlanRowCountIn
SqlPlanRowCountOut
SqlPlanUpdateRowCountError
SqlPlanUpdateRowCountIn
SqlPlanUpdateRowCountOut
SqlTextRowCountError
SqlTextRowCountIn
SqlTextRowCountOut
SqlTextUpdateRowCountError
SqlTextUpdateRowCountIn
SqlTextUpdateRowCountOut
CacheDirectory
CacheWindow
CollectionCacheFileName
CollectionCacheFileNameOutput
CollectionCacheFilePrefixPattern
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
InterestingQueries_HighCpuUsage
InterestingQueries_HighIoCount
InterestingQueries_HighMemoryUsage
InterestingQueries_HighTransactionCount
InterestingQueries_LargeResultset
InterestingQueries_LongRunningRequest
InterestingQueries_LongWaitingRequest
InterestingQueriesCount
InterestingQueriesLastSnapshotFileName
InterestingQueriesLastSnapshotFileNameOutput
InterestingQueriesSnapshotFileNamePrefixPattern
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
SnapshotId
SnapshotQueryStatsQuery
SourceId
TargetConnectionString
TopThreshold
DFT - Create Interesting Queries Upload Batch
DRC - Add SnapshotId column to current snapshot
Derived Column Input
Derived Column Output
snapshot_id
Expression
FriendlyExpression
Derived Column Error Output
ErrorCode
ErrorColumn
DRC - Calculate delta value between last snapshot and current snapshot for every metric
Derived Column Input
old_total_worker_time
old_total_physical_reads
old_total_logical_writes
old_total_logical_reads
old_total_clr_time
old_total_elapsed_time
total_worker_time
total_physical_reads
total_logical_writes
total_logical_reads
total_clr_time
total_elapsed_time
execution_count
old_execution_count
Derived Column Output
snapshot_worker_time
Expression
FriendlyExpression
snapshot_physical_reads
Expression
FriendlyExpression
snapshot_logical_reads
Expression
FriendlyExpression
snapshot_logical_writes
Expression
FriendlyExpression
snapshot_clr_time
Expression
FriendlyExpression
snapshot_elapsed_time
Expression
FriendlyExpression
snapshot_execution_count
Expression
FriendlyExpression
Derived Column Error Output
ErrorCode
ErrorColumn
DRV - Add plan_generation_num column
Derived Column Input
Derived Column Output
plan_generation_num
Expression
FriendlyExpression
creation_time
Expression
FriendlyExpression
Derived Column Error Output
ErrorCode
ErrorColumn
DRV - Add source_id (1)
Derived Column Input
Derived Column Output
source_id
Expression
FriendlyExpression
Derived Column Error Output
ErrorCode
ErrorColumn
DRV - Add source_id (2)
Derived Column Input
Derived Column Output
source_id
Expression
FriendlyExpression
Derived Column Error Output
ErrorCode
ErrorColumn
MLTCST - split current snapshot
Multicast Input 1
Multicast Output 3
Multicast Output 2
Multicast Output 1
Multicast Output 4
MLTCST - Split interesting queries
Multicast Input 1
Multicast Output 2
Multicast Output 3
Multicast Output 1
MLTCST - split last snapshot
Multicast Input 1
Multicast Output 1
Multicast Output 2
Multicast Output 3
MLTCST - Split to upload sql_handle and plan_handle
Multicast Input 1
Multicast Output 4
Multicast Output 2
Multicast Output 1
MRG - Append current stats on interesting queries
JoinType
NumKeyColumns
TreatNullsAsEqual
MaxBuffersPerInput
Merge Join Left Input
Top SQL Handle
Top Plan Handle
Merge Join Right Input
sql_handle
plan_handle
statement_start_offset
statement_end_offset
plan_generation_num
creation_time
last_execution_time
execution_count
total_worker_time
total_physical_reads
total_logical_writes
total_logical_reads
total_clr_time
total_elapsed_time
max_worker_time
min_worker_time
min_physical_reads
max_physical_reads
min_logical_writes
max_logical_writes
min_logical_reads
max_logical_reads
min_clr_time
max_clr_time
min_elapsed_time
max_elapsed_time
collection_time
snapshot_id
Merge Join Output
statement_start_offset
InputColumnID
statement_end_offset
InputColumnID
plan_generation_num
InputColumnID
creation_time
InputColumnID
last_execution_time
InputColumnID
execution_count
InputColumnID
total_worker_time
InputColumnID
total_physical_reads
InputColumnID
total_logical_writes
InputColumnID
total_logical_reads
InputColumnID
total_clr_time
InputColumnID
total_elapsed_time
InputColumnID
max_worker_time
InputColumnID
min_worker_time
InputColumnID
min_physical_reads
InputColumnID
max_physical_reads
InputColumnID
min_logical_writes
InputColumnID
max_logical_writes
InputColumnID
min_logical_reads
InputColumnID
max_logical_reads
InputColumnID
min_clr_time
InputColumnID
max_clr_time
InputColumnID
min_elapsed_time
InputColumnID
max_elapsed_time
InputColumnID
collection_time
InputColumnID
sql_handle
InputColumnID
plan_handle
InputColumnID
snapshot_id
InputColumnID
MRG - Append last stats on interesting queries
JoinType
NumKeyColumns
TreatNullsAsEqual
MaxBuffersPerInput
Merge Join Left Input
statement_start_offset
statement_end_offset
plan_generation_num
sql_handle
plan_handle
creation_time
last_execution_time
execution_count
total_worker_time
total_physical_reads
total_logical_writes
total_logical_reads
total_clr_time
total_elapsed_time
max_worker_time
min_worker_time
min_physical_reads
max_physical_reads
min_logical_writes
max_logical_writes
min_logical_reads
max_logical_reads
min_clr_time
max_clr_time
min_elapsed_time
max_elapsed_time
collection_time
snapshot_id
Merge Join Right Input
statement_start_offset
statement_end_offset
plan_generation_num
sql_handle
plan_handle
total_worker_time
total_physical_reads
total_logical_writes
total_logical_reads
total_clr_time
total_elapsed_time
execution_count
Merge Join Output
statement_start_offset
InputColumnID
statement_end_offset
InputColumnID
plan_generation_num
InputColumnID
creation_time
InputColumnID
last_execution_time
InputColumnID
execution_count
InputColumnID
total_worker_time
InputColumnID
total_physical_reads
InputColumnID
total_logical_writes
InputColumnID
total_logical_reads
InputColumnID
total_clr_time
InputColumnID
total_elapsed_time
InputColumnID
max_worker_time
InputColumnID
min_worker_time
InputColumnID
min_physical_reads
InputColumnID
max_physical_reads
InputColumnID
min_logical_writes
InputColumnID
max_logical_writes
InputColumnID
min_logical_reads
InputColumnID
max_logical_reads
InputColumnID
min_clr_time
InputColumnID
max_clr_time
InputColumnID
min_elapsed_time
InputColumnID
max_elapsed_time
InputColumnID
collection_time
InputColumnID
sql_handle
InputColumnID
plan_handle
InputColumnID
snapshot_id
InputColumnID
old_total_worker_time
InputColumnID
old_total_physical_reads
InputColumnID
old_total_logical_writes
InputColumnID
old_total_logical_reads
InputColumnID
old_total_clr_time
InputColumnID
old_total_elapsed_time
InputColumnID
old_execution_count
InputColumnID
ODD - Save statistics for interesting queries
CommandTimeout
OpenRowset
OpenRowsetVariable
SqlCommand
DefaultCodePage
AlwaysUseDefaultCodePage
AccessMode
FastLoadKeepIdentity
FastLoadKeepNulls
FastLoadOptions
FastLoadMaxInsertCommitSize
OLE DB Destination Input
sql_handle
statement_start_offset
statement_end_offset
plan_generation_num
plan_handle
creation_time
last_execution_time
execution_count
total_worker_time
snapshot_worker_time
min_worker_time
max_worker_time
total_physical_reads
snapshot_physical_reads
min_physical_reads
max_physical_reads
total_logical_writes
snapshot_logical_writes
min_logical_writes
max_logical_writes
total_logical_reads
snapshot_logical_reads
min_logical_reads
max_logical_reads
total_clr_time
snapshot_clr_time
min_clr_time
max_clr_time
total_elapsed_time
snapshot_elapsed_time
min_elapsed_time
max_elapsed_time
collection_time
snapshot_id
snapshot_execution_count
statement_start_offset
statement_end_offset
creation_time
plan_generation_num
last_execution_time
execution_count
total_worker_time
total_physical_reads
total_logical_writes
total_logical_reads
total_clr_time
total_elapsed_time
max_worker_time
min_worker_time
min_physical_reads
max_physical_reads
min_logical_writes
max_logical_writes
min_logical_reads
max_logical_reads
min_clr_time
max_clr_time
min_elapsed_time
max_elapsed_time
collection_time
sql_handle
plan_handle
snapshot_id
snapshot_worker_time
snapshot_physical_reads
snapshot_logical_reads
snapshot_logical_writes
snapshot_clr_time
snapshot_elapsed_time
snapshot_execution_count
OLE DB Destination Error Output
ErrorCode
ErrorColumn
OleDbConnection
ODD - Upload interesting plan handles
CommandTimeout
OpenRowset
OpenRowsetVariable
SqlCommand
DefaultCodePage
AlwaysUseDefaultCodePage
AccessMode
FastLoadKeepIdentity
FastLoadKeepNulls
FastLoadOptions
FastLoadMaxInsertCommitSize
OLE DB Destination Input
sql_handle
plan_handle
statement_start_offset
statement_end_offset
creation_time
database_id
object_id
object_name
query_plan
source_id
plan_generation_num
sql_handle
plan_handle
statement_start_offset
statement_end_offset
creation_time
source_id
plan_generation_num
OLE DB Destination Error Output
ErrorCode
ErrorColumn
OleDbConnection
ODD - Upload interesting sql handles
CommandTimeout
OpenRowset
OpenRowsetVariable
SqlCommand
DefaultCodePage
AlwaysUseDefaultCodePage
AccessMode
FastLoadKeepIdentity
FastLoadKeepNulls
FastLoadOptions
FastLoadMaxInsertCommitSize
OLE DB Destination Input
sql_handle
database_id
object_id
object_name
sql_text
source_id
sql_handle
source_id
OLE DB Destination Error Output
ErrorCode
ErrorColumn
OleDbConnection
ODS - Get current snapshot of dm_exec_query_stats
CommandTimeout
OpenRowset
OpenRowsetVariable
SqlCommand
SqlCommandVariable
DefaultCodePage
AlwaysUseDefaultCodePage
AccessMode
ParameterMapping
OLE DB Source Output
sql_handle
statement_start_offset
statement_end_offset
plan_generation_num
plan_handle
creation_time
last_execution_time
execution_count
total_worker_time
min_worker_time
max_worker_time
total_physical_reads
min_physical_reads
max_physical_reads
total_logical_writes
min_logical_writes
max_logical_writes
total_logical_reads
min_logical_reads
max_logical_reads
total_clr_time
min_clr_time
max_clr_time
total_elapsed_time
min_elapsed_time
max_elapsed_time
collection_time
sql_handle
statement_start_offset
statement_end_offset
plan_generation_num
plan_handle
creation_time
last_execution_time
execution_count
total_worker_time
min_worker_time
max_worker_time
total_physical_reads
min_physical_reads
max_physical_reads
total_logical_writes
min_logical_writes
max_logical_writes
total_logical_reads
min_logical_reads
max_logical_reads
total_clr_time
min_clr_time
max_clr_time
total_elapsed_time
min_elapsed_time
max_elapsed_time
collection_time
OLE DB Source Error Output
sql_handle
statement_start_offset
statement_end_offset
plan_generation_num
plan_handle
creation_time
last_execution_time
execution_count
total_worker_time
min_worker_time
max_worker_time
total_physical_reads
min_physical_reads
max_physical_reads
total_logical_writes
min_logical_writes
max_logical_writes
total_logical_reads
min_logical_reads
max_logical_reads
total_clr_time
min_clr_time
max_clr_time
total_elapsed_time
min_elapsed_time
max_elapsed_time
collection_time
ErrorCode
ErrorColumn
OleDbConnection
RC - Number of interesting plan handles
VariableName
Row Count Input 1
Row Count Output 1
RC - Number of interesting sql handles
VariableName
Row Count Input 1
Row Count Output 1
RC - Number of not inserted plan handles
VariableName
Row Count Input 1
Row Count Output 1
RC - Number of not inserted sql handles
VariableName
Row Count Input 1
Row Count Output 1
RC - Row count after TopN queries
VariableName
Row Count Input 1
Row Count Output 1
RC - Row count from dm_exec_query_stats
VariableName
Row Count Input 1
Row Count Output 1
RFD - Save current snapshot in temp file
AccessMode
FileName
FileNameVariable
WriteOption
Raw File Destination Input
sql_handle
statement_start_offset
statement_end_offset
plan_generation_num
plan_handle
creation_time
last_execution_time
execution_count
total_worker_time
total_physical_reads
total_logical_writes
total_logical_reads
total_clr_time
total_elapsed_time
max_worker_time
min_worker_time
min_physical_reads
max_physical_reads
min_logical_writes
max_logical_writes
min_logical_reads
max_logical_reads
min_clr_time
max_clr_time
min_elapsed_time
max_elapsed_time
snapshot_id
collection_time
RFS - Read current cache with dm_exec_requests
AccessMode
FileName
FileNameVariable
Raw File Source Output
statement_start_offset
statement_end_offset
collection_time
sql_handle
plan_handle
row_id
session_id
request_id
exec_context_id
blocking_session_id
is_blocking
blocking_exec_context_id
scheduler_id
database_name
user_id
task_state
request_status
session_status
executing_managed_code
login_time
is_user_process
host_name
program_name
login_name
wait_type
last_wait_type
wait_duration_ms
wait_resource
resource_description
transaction_id
open_transaction_count
transaction_isolation_level
request_cpu_time
request_logical_reads
request_reads
request_writes
request_total_elapsed_time
request_start_time
memory_usage
session_cpu_time
session_reads
session_writes
session_logical_reads
session_total_scheduled_time
session_total_elapsed_time
session_last_request_start_time
session_last_request_end_time
open_resultsets
session_row_count
prev_error
pending_io_count
command
statement_start_offset
statement_end_offset
collection_time
sql_handle
plan_handle
row_id
session_id
request_id
exec_context_id
blocking_session_id
is_blocking
blocking_exec_context_id
scheduler_id
database_name
user_id
task_state
request_status
session_status
executing_managed_code
login_time
is_user_process
host_name
program_name
login_name
wait_type
last_wait_type
wait_duration_ms
wait_resource
resource_description
transaction_id
open_transaction_count
transaction_isolation_level
request_cpu_time
request_logical_reads
request_reads
request_writes
request_total_elapsed_time
request_start_time
memory_usage
session_cpu_time
session_reads
session_writes
session_logical_reads
session_total_scheduled_time
session_total_elapsed_time
session_last_request_start_time
session_last_request_end_time
open_resultsets
session_row_count
prev_error
pending_io_count
command
RFS - Read last snapshot of dm_exec_query_stats
AccessMode
FileName
FileNameVariable
Raw File Source Output
sql_handle
statement_start_offset
statement_end_offset
plan_generation_num
plan_handle
creation_time
last_execution_time
execution_count
total_worker_time
total_physical_reads
total_logical_writes
total_logical_reads
total_clr_time
total_elapsed_time
max_worker_time
min_worker_time
min_physical_reads
max_physical_reads
min_logical_writes
max_logical_writes
min_logical_reads
max_logical_reads
min_clr_time
max_clr_time
min_elapsed_time
max_elapsed_time
snapshot_id
collection_time
statement_start_offset
statement_end_offset
plan_generation_num
creation_time
last_execution_time
execution_count
total_worker_time
total_physical_reads
total_logical_writes
total_logical_reads
total_clr_time
total_elapsed_time
max_worker_time
min_worker_time
min_physical_reads
max_physical_reads
min_logical_writes
max_logical_writes
min_logical_reads
max_logical_reads
min_clr_time
max_clr_time
min_elapsed_time
max_elapsed_time
snapshot_id
collection_time
sql_handle
plan_handle
SPLT - Identify interesting running requests
Conditional Split Input
blocking_session_id
is_blocking
wait_duration_ms
open_transaction_count
request_total_elapsed_time
request_cpu_time
memory_usage
session_row_count
pending_io_count
Interesting Requests
Expression
FriendlyExpression
EvaluationOrder
Conditional Split Default Output
IsDefaultOut
Conditional Split Error Output
ErrorCode
ErrorColumn
SRT - Add statement_start_offset, statement_end_offset and creation_time to the sort order
EliminateDuplicates
MaximumThreads
Sort Input
statement_start_offset
NewComparisonFlags
NewSortKeyPosition
statement_end_offset
NewComparisonFlags
NewSortKeyPosition
plan_generation_num
NewComparisonFlags
NewSortKeyPosition
creation_time
NewComparisonFlags
NewSortKeyPosition
last_execution_time
NewComparisonFlags
NewSortKeyPosition
execution_count
NewComparisonFlags
NewSortKeyPosition
total_worker_time
NewComparisonFlags
NewSortKeyPosition
total_physical_reads
NewComparisonFlags
NewSortKeyPosition
total_logical_writes
NewComparisonFlags
NewSortKeyPosition
total_logical_reads
NewComparisonFlags
NewSortKeyPosition
total_clr_time
NewComparisonFlags
NewSortKeyPosition
total_elapsed_time
NewComparisonFlags
NewSortKeyPosition
max_worker_time
NewComparisonFlags
NewSortKeyPosition
min_worker_time
NewComparisonFlags
NewSortKeyPosition
min_physical_reads
NewComparisonFlags
NewSortKeyPosition
max_physical_reads
NewComparisonFlags
NewSortKeyPosition
min_logical_writes
NewComparisonFlags
NewSortKeyPosition
max_logical_writes
NewComparisonFlags
NewSortKeyPosition
min_logical_reads
NewComparisonFlags
NewSortKeyPosition
max_logical_reads
NewComparisonFlags
NewSortKeyPosition
min_clr_time
NewComparisonFlags
NewSortKeyPosition
max_clr_time
NewComparisonFlags
NewSortKeyPosition
min_elapsed_time
NewComparisonFlags
NewSortKeyPosition
max_elapsed_time
NewComparisonFlags
NewSortKeyPosition
collection_time
NewComparisonFlags
NewSortKeyPosition
sql_handle
NewComparisonFlags
NewSortKeyPosition
plan_handle
NewComparisonFlags
NewSortKeyPosition
snapshot_id
NewComparisonFlags
NewSortKeyPosition
Sort Output
statement_start_offset
SortColumnId
statement_end_offset
SortColumnId
plan_generation_num
SortColumnId
creation_time
SortColumnId
last_execution_time
SortColumnId
execution_count
SortColumnId
total_worker_time
SortColumnId
total_physical_reads
SortColumnId
total_logical_writes
SortColumnId
total_logical_reads
SortColumnId
total_clr_time
SortColumnId
total_elapsed_time
SortColumnId
max_worker_time
SortColumnId
min_worker_time
SortColumnId
min_physical_reads
SortColumnId
max_physical_reads
SortColumnId
min_logical_writes
SortColumnId
max_logical_writes
SortColumnId
min_logical_reads
SortColumnId
max_logical_reads
SortColumnId
min_clr_time
SortColumnId
max_clr_time
SortColumnId
min_elapsed_time
SortColumnId
max_elapsed_time
SortColumnId
collection_time
SortColumnId
sql_handle
SortColumnId
plan_handle
SortColumnId
snapshot_id
SortColumnId
SRT - Find unique sql_handle and plan_handle combinations
EliminateDuplicates
MaximumThreads
Sort Input
sql_handle
NewComparisonFlags
NewSortKeyPosition
plan_handle
NewComparisonFlags
NewSortKeyPosition
statement_start_offset
NewComparisonFlags
NewSortKeyPosition
statement_end_offset
NewComparisonFlags
NewSortKeyPosition
creation_time
NewComparisonFlags
NewSortKeyPosition
plan_generation_num
NewComparisonFlags
NewSortKeyPosition
Sort Output
sql_handle
SortColumnId
plan_handle
SortColumnId
statement_start_offset
SortColumnId
statement_end_offset
SortColumnId
creation_time
SortColumnId
plan_generation_num
SortColumnId
SRT - Find unique sql_handle values
EliminateDuplicates
MaximumThreads
Sort Input
sql_handle
NewComparisonFlags
NewSortKeyPosition
Sort Output
sql_handle
SortColumnId
SRT - Sort columns by sql_handle, plan_handle
EliminateDuplicates
MaximumThreads
Sort Input
Top Reason
NewComparisonFlags
NewSortKeyPosition
Top SQL Handle
NewComparisonFlags
NewSortKeyPosition
Top Plan Handle
NewComparisonFlags
NewSortKeyPosition
Sort Output
Top Reason
SortColumnId
Top SQL Handle
SortColumnId
Top Plan Handle
SortColumnId
TPQ - Analyze Interesting Queries
TxTopQueries Only Input
snapshot_id
sql_handle
plan_handle
plan_generation_num
execution_count
total_worker_time
min_worker_time
max_worker_time
total_physical_reads
min_physical_reads
max_physical_reads
total_logical_writes
min_logical_writes
max_logical_writes
total_logical_reads
min_logical_reads
max_logical_reads
total_clr_time
min_clr_time
max_clr_time
total_elapsed_time
min_elapsed_time
max_elapsed_time
TxTopQueries Only Output
Top Reason
Top SQL Handle
Top Plan Handle
UNION - Combine interesting requests and interesting stats
Union All Input 1
old_total_worker_time
OutputColumnLineageID
old_total_physical_reads
OutputColumnLineageID
old_total_logical_writes
OutputColumnLineageID
old_total_logical_reads
OutputColumnLineageID
old_total_clr_time
OutputColumnLineageID
old_total_elapsed_time
OutputColumnLineageID
statement_start_offset
OutputColumnLineageID
statement_end_offset
OutputColumnLineageID
creation_time
OutputColumnLineageID
plan_generation_num
OutputColumnLineageID
last_execution_time
OutputColumnLineageID
execution_count
OutputColumnLineageID
total_worker_time
OutputColumnLineageID
total_physical_reads
OutputColumnLineageID
total_logical_writes
OutputColumnLineageID
total_logical_reads
OutputColumnLineageID
total_clr_time
OutputColumnLineageID
total_elapsed_time
OutputColumnLineageID
max_worker_time
OutputColumnLineageID
min_worker_time
OutputColumnLineageID
min_physical_reads
OutputColumnLineageID
max_physical_reads
OutputColumnLineageID
min_logical_writes
OutputColumnLineageID
max_logical_writes
OutputColumnLineageID
min_logical_reads
OutputColumnLineageID
max_logical_reads
OutputColumnLineageID
min_clr_time
OutputColumnLineageID
max_clr_time
OutputColumnLineageID
min_elapsed_time
OutputColumnLineageID
max_elapsed_time
OutputColumnLineageID
sql_handle
OutputColumnLineageID
plan_handle
OutputColumnLineageID
snapshot_id
OutputColumnLineageID
snapshot_worker_time
OutputColumnLineageID
snapshot_physical_reads
OutputColumnLineageID
snapshot_logical_reads
OutputColumnLineageID
snapshot_logical_writes
OutputColumnLineageID
snapshot_clr_time
OutputColumnLineageID
snapshot_elapsed_time
OutputColumnLineageID
collection_time
OutputColumnLineageID
snapshot_execution_count
OutputColumnLineageID
old_execution_count
OutputColumnLineageID
Union All Input 3
statement_start_offset
OutputColumnLineageID
statement_end_offset
OutputColumnLineageID
collection_time
OutputColumnLineageID
sql_handle
OutputColumnLineageID
plan_handle
OutputColumnLineageID
plan_generation_num
OutputColumnLineageID
creation_time
OutputColumnLineageID
Union All Input 2
Union All Output 1
old_total_worker_time
old_total_physical_reads
old_total_logical_writes
old_total_logical_reads
old_total_clr_time
old_total_elapsed_time
statement_start_offset
statement_end_offset
creation_time
plan_generation_num
last_execution_time
execution_count
total_worker_time
total_physical_reads
total_logical_writes
total_logical_reads
total_clr_time
total_elapsed_time
max_worker_time
min_worker_time
min_physical_reads
max_physical_reads
min_logical_writes
max_logical_writes
min_logical_reads
max_logical_reads
min_clr_time
max_clr_time
min_elapsed_time
max_elapsed_time
collection_time
sql_handle
plan_handle
snapshot_id
snapshot_worker_time
snapshot_physical_reads
snapshot_logical_reads
snapshot_logical_writes
snapshot_clr_time
snapshot_elapsed_time
snapshot_execution_count
old_execution_count
UNION - Combine last and current snapshots for TopN processing
Union All Input 2
snapshot_id
OutputColumnLineageID
statement_start_offset
OutputColumnLineageID
statement_end_offset
OutputColumnLineageID
plan_generation_num
OutputColumnLineageID
creation_time
OutputColumnLineageID
last_execution_time
OutputColumnLineageID
execution_count
OutputColumnLineageID
total_worker_time
OutputColumnLineageID
total_physical_reads
OutputColumnLineageID
total_logical_writes
OutputColumnLineageID
total_logical_reads
OutputColumnLineageID
total_clr_time
OutputColumnLineageID
total_elapsed_time
OutputColumnLineageID
max_worker_time
OutputColumnLineageID
min_worker_time
OutputColumnLineageID
min_physical_reads
OutputColumnLineageID
max_physical_reads
OutputColumnLineageID
min_logical_writes
OutputColumnLineageID
max_logical_writes
OutputColumnLineageID
min_logical_reads
OutputColumnLineageID
max_logical_reads
OutputColumnLineageID
min_clr_time
OutputColumnLineageID
max_clr_time
OutputColumnLineageID
min_elapsed_time
OutputColumnLineageID
max_elapsed_time
OutputColumnLineageID
collection_time
OutputColumnLineageID
sql_handle
OutputColumnLineageID
plan_handle
OutputColumnLineageID
Union All Input 3
statement_start_offset
OutputColumnLineageID
statement_end_offset
OutputColumnLineageID
plan_generation_num
OutputColumnLineageID
creation_time
OutputColumnLineageID
last_execution_time
OutputColumnLineageID
execution_count
OutputColumnLineageID
total_worker_time
OutputColumnLineageID
total_physical_reads
OutputColumnLineageID
total_logical_writes
OutputColumnLineageID
total_logical_reads
OutputColumnLineageID
total_clr_time
OutputColumnLineageID
total_elapsed_time
OutputColumnLineageID
max_worker_time
OutputColumnLineageID
min_worker_time
OutputColumnLineageID
min_physical_reads
OutputColumnLineageID
max_physical_reads
OutputColumnLineageID
min_logical_writes
OutputColumnLineageID
max_logical_writes
OutputColumnLineageID
min_logical_reads
OutputColumnLineageID
max_logical_reads
OutputColumnLineageID
min_clr_time
OutputColumnLineageID
max_clr_time
OutputColumnLineageID
min_elapsed_time
OutputColumnLineageID
max_elapsed_time
OutputColumnLineageID
snapshot_id
OutputColumnLineageID
collection_time
OutputColumnLineageID
sql_handle
OutputColumnLineageID
plan_handle
OutputColumnLineageID
Union All Input 1
Union All Output 1
statement_start_offset
statement_end_offset
plan_generation_num
creation_time
last_execution_time
execution_count
total_worker_time
total_physical_reads
total_logical_writes
total_logical_reads
total_clr_time
total_elapsed_time
max_worker_time
min_worker_time
min_physical_reads
max_physical_reads
min_logical_writes
max_logical_writes
min_logical_reads
max_logical_reads
min_clr_time
max_clr_time
min_elapsed_time
max_elapsed_time
snapshot_id
collection_time
sql_handle
plan_handle
BufferSizeTuning
PipelineBufferLeak
PipelineComponentTime
PipelineExecutionPlan
PipelineExecutionTrees
PipelineInitialization
Calculate TopN stats
Calculate TopN stats
Derived Column Output
Derived Column Output
Derived Column Output
Derived Column Output
Derived Column Output
Interesting Requests
Merge Join Output
Merge Join Output
Multicast Output 2
Multicast Output 3
Multicast Output 4
OLE DB Destination Error Output
OLE DB Destination Error Output
OLE DB Source Output
Process TopN
Process TopN
Raw File Source Output
Raw File Source Output
Row Count Output 1
Row Count Output 1
Row Count Output 1
Row Count Output 1
Save
Save
Sort Output
Sort Output
Sort Output
Sort Output
TxTopQueries Only Output
Union All Output 1
Union All Output 1
NotableQueryPlan
NotableQueryText
InterestingQueriesRowCountIn
InterestingQueriesRowCountOut
SqlPlanRowCountError
SqlPlanRowCountIn
SqlPlanRowCountOut
SqlPlanUpdateRowCountError
SqlPlanUpdateRowCountIn
SqlPlanUpdateRowCountOut
SqlTextRowCountError
SqlTextRowCountIn
SqlTextRowCountOut
SqlTextUpdateRowCountError
SqlTextUpdateRowCountIn
SqlTextUpdateRowCountOut
CacheDirectory
CacheWindow
CollectionCacheFileName
CollectionCacheFileNameOutput
CollectionCacheFilePrefixPattern
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
InterestingQueries_HighCpuUsage
InterestingQueries_HighIoCount
InterestingQueries_HighMemoryUsage
InterestingQueries_HighTransactionCount
InterestingQueries_LargeResultset
InterestingQueries_LongRunningRequest
InterestingQueries_LongWaitingRequest
InterestingQueriesCount
InterestingQueriesLastSnapshotFileName
InterestingQueriesLastSnapshotFileNameOutput
InterestingQueriesSnapshotFileNamePrefixPattern
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
SnapshotId
SnapshotQueryStatsQuery
SourceId
TargetConnectionString
TopThreshold
DFT - Find and save plan text
LKUP - Look up query plans on target server
SqlCommand
SqlCommandParam
ConnectionType
CacheType
NoMatchBehavior
NoMatchCachePercentage
MaxMemoryUsage
MaxMemoryUsage64
ReferenceMetadataXml
ParameterMap
DefaultCodePage
TreatDuplicateKeysAsError
Lookup Input
statement_start_offset
JoinToReferenceColumn
CopyFromReferenceColumn
statement_end_offset
JoinToReferenceColumn
CopyFromReferenceColumn
plan_handle
JoinToReferenceColumn
CopyFromReferenceColumn
Lookup Match Output
database_id
CopyFromReferenceColumn
object_id
CopyFromReferenceColumn
object_name
CopyFromReferenceColumn
query_plan
CopyFromReferenceColumn
Lookup No Match Output
Lookup Error Output
ErrorCode
ErrorColumn
OleDbConnection
ODC - Save known plans to warehouse
CommandTimeout
SqlCommand
DefaultCodePage
OLE DB Command Input
@source_id
DBParamInfoFlags
@sql_handle
DBParamInfoFlags
@plan_handle
DBParamInfoFlags
@statement_start_offset
DBParamInfoFlags
@statement_end_offset
DBParamInfoFlags
@plan_generation_num
DBParamInfoFlags
@database_id
DBParamInfoFlags
@object_id
DBParamInfoFlags
@object_name
DBParamInfoFlags
@query_plan
DBParamInfoFlags
source_id
sql_handle
plan_handle
statement_start_offset
statement_end_offset
plan_generation_num
database_id
object_id
object_name
query_plan
OLE DB Command Output
OLE DB Command Error Output
ErrorCode
ErrorColumn
OleDbConnection
ODS - Get all plan handles without saved plan
CommandTimeout
OpenRowset
OpenRowsetVariable
SqlCommand
SqlCommandVariable
DefaultCodePage
AlwaysUseDefaultCodePage
AccessMode
ParameterMapping
OLE DB Source Output
source_id
sql_handle
plan_handle
statement_start_offset
statement_end_offset
plan_generation_num
source_id
sql_handle
plan_handle
statement_start_offset
statement_end_offset
plan_generation_num
OLE DB Source Error Output
source_id
sql_handle
plan_handle
statement_start_offset
statement_end_offset
plan_generation_num
ErrorCode
ErrorColumn
OleDbConnection
RC - Identified query plans count
VariableName
Row Count Input 1
Row Count Output 1
RC - Unidentified query plans count
VariableName
Row Count Input 1
Row Count Output 1
RC - Unknown query plans count
VariableName
Row Count Input 1
Row Count Output 1
BufferSizeTuning
PipelineBufferLeak
PipelineComponentTime
PipelineExecutionPlan
PipelineExecutionTrees
PipelineInitialization
Lookup Match Output
Lookup No Match Output
OLE DB Source Output
Row Count Output 1
Row Count Output 1
SourceSqlQuery
InterestingQueriesRowCountIn
InterestingQueriesRowCountOut
SqlPlanRowCountError
SqlPlanRowCountIn
SqlPlanRowCountOut
SqlPlanUpdateRowCountError
SqlPlanUpdateRowCountIn
SqlPlanUpdateRowCountOut
SqlTextRowCountError
SqlTextRowCountIn
SqlTextRowCountOut
SqlTextUpdateRowCountError
SqlTextUpdateRowCountIn
SqlTextUpdateRowCountOut
CacheDirectory
CacheWindow
CollectionCacheFileName
CollectionCacheFileNameOutput
CollectionCacheFilePrefixPattern
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
InterestingQueries_HighCpuUsage
InterestingQueries_HighIoCount
InterestingQueries_HighMemoryUsage
InterestingQueries_HighTransactionCount
InterestingQueries_LargeResultset
InterestingQueries_LongRunningRequest
InterestingQueries_LongWaitingRequest
InterestingQueriesCount
InterestingQueriesLastSnapshotFileName
InterestingQueriesLastSnapshotFileNameOutput
InterestingQueriesSnapshotFileNamePrefixPattern
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
SnapshotId
SnapshotQueryStatsQuery
SourceId
TargetConnectionString
TopThreshold
DFT - Find and save sql text
LKUP - Look up query text on target server
SqlCommand
SqlCommandParam
ConnectionType
CacheType
NoMatchBehavior
NoMatchCachePercentage
MaxMemoryUsage
MaxMemoryUsage64
ReferenceMetadataXml
ParameterMap
DefaultCodePage
TreatDuplicateKeysAsError
Lookup Input
sql_handle
JoinToReferenceColumn
CopyFromReferenceColumn
Lookup Match Output
database_id
CopyFromReferenceColumn
object_id
CopyFromReferenceColumn
object_name
CopyFromReferenceColumn
sql_text
CopyFromReferenceColumn
Lookup No Match Output
Lookup Error Output
ErrorCode
ErrorColumn
OleDbConnection
ODS - Get all sql handles without saved sql text
CommandTimeout
OpenRowset
OpenRowsetVariable
SqlCommand
SqlCommandVariable
DefaultCodePage
AlwaysUseDefaultCodePage
AccessMode
ParameterMapping
OLE DB Source Output
source_id
sql_handle
source_id
sql_handle
OLE DB Source Error Output
source_id
sql_handle
ErrorCode
ErrorColumn
OleDbConnection
ODS - Save query text to warehouse
CommandTimeout
SqlCommand
DefaultCodePage
OLE DB Command Input
@sql_handle
DBParamInfoFlags
@source_id
DBParamInfoFlags
@database_id
DBParamInfoFlags
@object_id
DBParamInfoFlags
@object_name
DBParamInfoFlags
@sql_text
DBParamInfoFlags
sql_handle
source_id
database_id
object_id
object_name
sql_text
OLE DB Command Output
OLE DB Command Error Output
ErrorCode
ErrorColumn
OleDbConnection
RC - Identified query text count
VariableName
Row Count Input 1
Row Count Output 1
RC - Unidentified query text count
VariableName
Row Count Input 1
Row Count Output 1
RC - Unknown query text count
VariableName
Row Count Input 1
Row Count Output 1
BufferSizeTuning
PipelineBufferLeak
PipelineComponentTime
PipelineExecutionPlan
PipelineExecutionTrees
PipelineInitialization
Lookup Match Output
Lookup No Match Output
OLE DB Source Output
Row Count Output 1
Row Count Output 1
SourceSqlQuery
InterestingQueriesRowCountIn
InterestingQueriesRowCountOut
SqlPlanRowCountError
SqlPlanRowCountIn
SqlPlanRowCountOut
SqlPlanUpdateRowCountError
SqlPlanUpdateRowCountIn
SqlPlanUpdateRowCountOut
SqlTextRowCountError
SqlTextRowCountIn
SqlTextRowCountOut
SqlTextUpdateRowCountError
SqlTextUpdateRowCountIn
SqlTextUpdateRowCountOut
CacheDirectory
CacheWindow
CollectionCacheFileName
CollectionCacheFileNameOutput
CollectionCacheFilePrefixPattern
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
InterestingQueries_HighCpuUsage
InterestingQueries_HighIoCount
InterestingQueries_HighMemoryUsage
InterestingQueries_HighTransactionCount
InterestingQueries_LargeResultset
InterestingQueries_LongRunningRequest
InterestingQueries_LongWaitingRequest
InterestingQueriesCount
InterestingQueriesLastSnapshotFileName
InterestingQueriesLastSnapshotFileNameOutput
InterestingQueriesSnapshotFileNamePrefixPattern
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
SnapshotId
SnapshotQueryStatsQuery
SourceId
TargetConnectionString
TopThreshold
FAT - Check Interesting Queries Last Snapshot exists
FilePath
InterestingQueriesRowCountIn
InterestingQueriesRowCountOut
SqlPlanRowCountError
SqlPlanRowCountIn
SqlPlanRowCountOut
SqlPlanUpdateRowCountError
SqlPlanUpdateRowCountIn
SqlPlanUpdateRowCountOut
SqlTextRowCountError
SqlTextRowCountIn
SqlTextRowCountOut
SqlTextUpdateRowCountError
SqlTextUpdateRowCountIn
SqlTextUpdateRowCountOut
CacheDirectory
CacheWindow
CollectionCacheFileName
CollectionCacheFileNameOutput
CollectionCacheFilePrefixPattern
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
InterestingQueries_HighCpuUsage
InterestingQueries_HighIoCount
InterestingQueries_HighMemoryUsage
InterestingQueries_HighTransactionCount
InterestingQueries_LargeResultset
InterestingQueries_LongRunningRequest
InterestingQueries_LongWaitingRequest
InterestingQueriesCount
InterestingQueriesLastSnapshotFileName
InterestingQueriesLastSnapshotFileNameOutput
InterestingQueriesSnapshotFileNamePrefixPattern
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
SnapshotId
SnapshotQueryStatsQuery
SourceId
TargetConnectionString
TopThreshold
FST - Rename Current Snapshot File as Last Snapshot File
FileSystemOperation
InterestingQueriesRowCountIn
InterestingQueriesRowCountOut
SqlPlanRowCountError
SqlPlanRowCountIn
SqlPlanRowCountOut
SqlPlanUpdateRowCountError
SqlPlanUpdateRowCountIn
SqlPlanUpdateRowCountOut
SqlTextRowCountError
SqlTextRowCountIn
SqlTextRowCountOut
SqlTextUpdateRowCountError
SqlTextUpdateRowCountIn
SqlTextUpdateRowCountOut
CacheDirectory
CacheWindow
CollectionCacheFileName
CollectionCacheFileNameOutput
CollectionCacheFilePrefixPattern
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
InterestingQueries_HighCpuUsage
InterestingQueries_HighIoCount
InterestingQueries_HighMemoryUsage
InterestingQueries_HighTransactionCount
InterestingQueries_LargeResultset
InterestingQueries_LongRunningRequest
InterestingQueries_LongWaitingRequest
InterestingQueriesCount
InterestingQueriesLastSnapshotFileName
InterestingQueriesLastSnapshotFileNameOutput
InterestingQueriesSnapshotFileNamePrefixPattern
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
SnapshotId
SnapshotQueryStatsQuery
SourceId
TargetConnectionString
TopThreshold
SQL - Log stats for Interesting Queries
ExecuteSQLExecutingQuery
InterestingQueriesRowCountIn
InterestingQueriesRowCountOut
SqlPlanRowCountError
SqlPlanRowCountIn
SqlPlanRowCountOut
SqlPlanUpdateRowCountError
SqlPlanUpdateRowCountIn
SqlPlanUpdateRowCountOut
SqlTextRowCountError
SqlTextRowCountIn
SqlTextRowCountOut
SqlTextUpdateRowCountError
SqlTextUpdateRowCountIn
SqlTextUpdateRowCountOut
CacheDirectory
CacheWindow
CollectionCacheFileName
CollectionCacheFileNameOutput
CollectionCacheFilePrefixPattern
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
InterestingQueries_HighCpuUsage
InterestingQueries_HighIoCount
InterestingQueries_HighMemoryUsage
InterestingQueries_HighTransactionCount
InterestingQueries_LargeResultset
InterestingQueries_LongRunningRequest
InterestingQueries_LongWaitingRequest
InterestingQueriesCount
InterestingQueriesLastSnapshotFileName
InterestingQueriesLastSnapshotFileNameOutput
InterestingQueriesSnapshotFileNamePrefixPattern
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
SnapshotId
SnapshotQueryStatsQuery
SourceId
TargetConnectionString
TopThreshold
SQL - Log stats for sql plan
ExecuteSQLExecutingQuery
InterestingQueriesRowCountIn
InterestingQueriesRowCountOut
SqlPlanRowCountError
SqlPlanRowCountIn
SqlPlanRowCountOut
SqlPlanUpdateRowCountError
SqlPlanUpdateRowCountIn
SqlPlanUpdateRowCountOut
SqlTextRowCountError
SqlTextRowCountIn
SqlTextRowCountOut
SqlTextUpdateRowCountError
SqlTextUpdateRowCountIn
SqlTextUpdateRowCountOut
CacheDirectory
CacheWindow
CollectionCacheFileName
CollectionCacheFileNameOutput
CollectionCacheFilePrefixPattern
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
InterestingQueries_HighCpuUsage
InterestingQueries_HighIoCount
InterestingQueries_HighMemoryUsage
InterestingQueries_HighTransactionCount
InterestingQueries_LargeResultset
InterestingQueries_LongRunningRequest
InterestingQueries_LongWaitingRequest
InterestingQueriesCount
InterestingQueriesLastSnapshotFileName
InterestingQueriesLastSnapshotFileNameOutput
InterestingQueriesSnapshotFileNamePrefixPattern
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
SnapshotId
SnapshotQueryStatsQuery
SourceId
TargetConnectionString
TopThreshold
SQL - Log stats for sql text
ExecuteSQLExecutingQuery
InterestingQueriesRowCountIn
InterestingQueriesRowCountOut
SqlPlanRowCountError
SqlPlanRowCountIn
SqlPlanRowCountOut
SqlPlanUpdateRowCountError
SqlPlanUpdateRowCountIn
SqlPlanUpdateRowCountOut
SqlTextRowCountError
SqlTextRowCountIn
SqlTextRowCountOut
SqlTextUpdateRowCountError
SqlTextUpdateRowCountIn
SqlTextUpdateRowCountOut
CacheDirectory
CacheWindow
CollectionCacheFileName
CollectionCacheFileNameOutput
CollectionCacheFilePrefixPattern
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
InterestingQueries_HighCpuUsage
InterestingQueries_HighIoCount
InterestingQueries_HighMemoryUsage
InterestingQueries_HighTransactionCount
InterestingQueries_LargeResultset
InterestingQueries_LongRunningRequest
InterestingQueries_LongWaitingRequest
InterestingQueriesCount
InterestingQueriesLastSnapshotFileName
InterestingQueriesLastSnapshotFileNameOutput
InterestingQueriesSnapshotFileNamePrefixPattern
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
SnapshotId
SnapshotQueryStatsQuery
SourceId
TargetConnectionString
TopThreshold
Constraint
Constraint 1
Constraint 2
Constraint 3
Constraint 5
Constraint 6
Constraint 7
Constraint 8
Last Snapshot Missing
InterestingQueriesRowCountIn
InterestingQueriesRowCountOut
SqlPlanRowCountError
SqlPlanRowCountIn
SqlPlanRowCountOut
SqlPlanUpdateRowCountError
SqlPlanUpdateRowCountIn
SqlPlanUpdateRowCountOut
SqlTextRowCountError
SqlTextRowCountIn
SqlTextRowCountOut
SqlTextUpdateRowCountError
SqlTextUpdateRowCountIn
SqlTextUpdateRowCountOut
CacheDirectory
CacheWindow
CollectionCacheFileName
CollectionCacheFileNameOutput
CollectionCacheFilePrefixPattern
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
InterestingQueries_HighCpuUsage
InterestingQueries_HighIoCount
InterestingQueries_HighMemoryUsage
InterestingQueries_HighTransactionCount
InterestingQueries_LargeResultset
InterestingQueries_LongRunningRequest
InterestingQueries_LongWaitingRequest
InterestingQueriesCount
InterestingQueriesLastSnapshotFileName
InterestingQueriesLastSnapshotFileNameOutput
InterestingQueriesSnapshotFileNamePrefixPattern
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
SnapshotId
SnapshotQueryStatsQuery
SourceId
TargetConnectionString
TopThreshold
SEQ - Rename Collection Cache File
FST - Rename Cache File
FileSystemOperation
SyncRoot
CacheDirectory
CacheWindow
CollectionCacheFileName
CollectionCacheFileNameOutput
CollectionCacheFilePrefixPattern
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
InterestingQueries_HighCpuUsage
InterestingQueries_HighIoCount
InterestingQueries_HighMemoryUsage
InterestingQueries_HighTransactionCount
InterestingQueries_LargeResultset
InterestingQueries_LongRunningRequest
InterestingQueries_LongWaitingRequest
InterestingQueriesCount
InterestingQueriesLastSnapshotFileName
InterestingQueriesLastSnapshotFileNameOutput
InterestingQueriesSnapshotFileNamePrefixPattern
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
SnapshotId
SnapshotQueryStatsQuery
SourceId
TargetConnectionString
TopThreshold
SyncRoot
CacheDirectory
CacheWindow
CollectionCacheFileName
CollectionCacheFileNameOutput
CollectionCacheFilePrefixPattern
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
InterestingQueries_HighCpuUsage
InterestingQueries_HighIoCount
InterestingQueries_HighMemoryUsage
InterestingQueries_HighTransactionCount
InterestingQueries_LargeResultset
InterestingQueries_LongRunningRequest
InterestingQueries_LongWaitingRequest
InterestingQueriesCount
InterestingQueriesLastSnapshotFileName
InterestingQueriesLastSnapshotFileNameOutput
InterestingQueriesSnapshotFileNamePrefixPattern
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
SnapshotId
SnapshotQueryStatsQuery
SourceId
TargetConnectionString
TopThreshold
SQL - Get SnapshotId
ExecuteSQLExecutingQuery
CacheDirectory
CacheWindow
CollectionCacheFileName
CollectionCacheFileNameOutput
CollectionCacheFilePrefixPattern
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
InterestingQueries_HighCpuUsage
InterestingQueries_HighIoCount
InterestingQueries_HighMemoryUsage
InterestingQueries_HighTransactionCount
InterestingQueries_LargeResultset
InterestingQueries_LongRunningRequest
InterestingQueries_LongWaitingRequest
InterestingQueriesCount
InterestingQueriesLastSnapshotFileName
InterestingQueriesLastSnapshotFileNameOutput
InterestingQueriesSnapshotFileNamePrefixPattern
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
SnapshotId
SnapshotQueryStatsQuery
SourceId
TargetConnectionString
TopThreshold
SQL - Get SourceId
ExecuteSQLExecutingQuery
CacheDirectory
CacheWindow
CollectionCacheFileName
CollectionCacheFileNameOutput
CollectionCacheFilePrefixPattern
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
InterestingQueries_HighCpuUsage
InterestingQueries_HighIoCount
InterestingQueries_HighMemoryUsage
InterestingQueries_HighTransactionCount
InterestingQueries_LargeResultset
InterestingQueries_LongRunningRequest
InterestingQueries_LongWaitingRequest
InterestingQueriesCount
InterestingQueriesLastSnapshotFileName
InterestingQueriesLastSnapshotFileNameOutput
InterestingQueriesSnapshotFileNamePrefixPattern
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
SnapshotId
SnapshotQueryStatsQuery
SourceId
TargetConnectionString
TopThreshold
Log Entry Information
Diagnostic
DiagnosticEx
Log providers
Project Parameters
Precedence constraints
Constraint
Constraint 12
Constraint 3
Constraint 6
Constraint 7
Constraint 8
Variables
CacheDirectory
CacheWindow
CollectionCacheFileName
CollectionCacheFileNameOutput
CollectionCacheFilePrefixPattern
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
InterestingQueries_HighCpuUsage
InterestingQueries_HighIoCount
InterestingQueries_HighMemoryUsage
InterestingQueries_HighTransactionCount
InterestingQueries_LargeResultset
InterestingQueries_LongRunningRequest
InterestingQueries_LongWaitingRequest
InterestingQueriesCount
InterestingQueriesLastSnapshotFileName
InterestingQueriesLastSnapshotFileNameOutput
InterestingQueriesSnapshotFileNamePrefixPattern
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
SnapshotId
SnapshotQueryStatsQuery
SourceId
TargetConnectionString
TopThreshold
SqlTraceCollect
Configuration settings
CacheDirectory
CacheWindow
InputParameters
MDWConnectionString
ConfigConnectionString
TargetConnectionString
LoopEventName
ExitEventName
CollectorTypeUID
CollectionSetUID
ItemID
InstanceID
InstanceName
LoggingLevel
LogID
ParentLogID
Connection managers
ConfigConnection
ConnectionString
CacheDirectory
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
TargetConnectionString
TraceErrorCode
TraceID
TraceLocation
TraceScript
MdwConnection
ConnectionString
CacheDirectory
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
TargetConnectionString
TraceErrorCode
TraceID
TraceLocation
TraceScript
TargetConnection
ConnectionString
CacheDirectory
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
TargetConnectionString
TraceErrorCode
TraceID
TraceLocation
TraceScript
Event handlers
Executables
Foreach Loop - Monitor Trace
SQL - Check if Trace is Running
ExecuteSQLExecutingQuery
CacheDirectory
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
TargetConnectionString
TraceErrorCode
TraceID
TraceLocation
TraceScript
SQL - Log Package Iteration
ExecuteSQLExecutingQuery
CacheDirectory
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
TargetConnectionString
TraceErrorCode
TraceID
TraceLocation
TraceScript
SQL - Log Package Stats
ExecuteSQLExecutingQuery
CacheDirectory
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
TargetConnectionString
TraceErrorCode
TraceID
TraceLocation
TraceScript
SQL - Recreate Trace
ExecuteSQLExecutingQuery
CacheDirectory
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
TargetConnectionString
TraceErrorCode
TraceID
TraceLocation
TraceScript
{710AEAF2-45BD-4AB2-9EAF-FB6268AD10A2}
ExitEventName
LoopEventName
ExitEventName
LoopEventName
Constraint
Constraint 1
Constraint 2
Constraint 3
CacheDirectory
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
TargetConnectionString
TraceErrorCode
TraceID
TraceLocation
TraceScript
SQL - Close trace if running
ExecuteSQLExecutingQuery
CacheDirectory
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
TargetConnectionString
TraceErrorCode
TraceID
TraceLocation
TraceScript
SQL - Execute Trace Start Script
ExecuteSQLExecutingQuery
CacheDirectory
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
TargetConnectionString
TraceErrorCode
TraceID
TraceLocation
TraceScript
SQL - Stop Trace
ExecuteSQLExecutingQuery
CacheDirectory
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
TargetConnectionString
TraceErrorCode
TraceID
TraceLocation
TraceScript
TRC - Generate Trace Start Script
InputParameters
TraceFileLocation
CacheDirectory
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
TargetConnectionString
TraceErrorCode
TraceID
TraceLocation
TraceScript
Log Entry Information
Diagnostic
DiagnosticEx
Log providers
Project Parameters
Precedence constraints
Constraint
Constraint 1
Constraint 2
Constraint 5
Variables
CacheDirectory
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
TargetConnectionString
TraceErrorCode
TraceID
TraceLocation
TraceScript
SqlTraceUpload
Configuration settings
CacheDirectory
CacheWindow
InputParameters
MDWConnectionString
ConfigConnectionString
TargetConnectionString
LoopEventName
ExitEventName
CollectorTypeUID
CollectionSetUID
ItemID
InstanceID
InstanceName
LoggingLevel
LogID
ParentLogID
DaysUntilExpiration
Connection managers
ConfigConnection
ConnectionString
CacheDirectory
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
Counter
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopEventName
MDWConnectionString
ParentLogID
RowCountIn
SnapshotID
SourceID
TargetConnectionString
TraceCurrentEventTime
TraceCurrentFile
TraceDroppedEventCount
TraceID
TraceInfoID
TraceIsRunning
TraceLastEventSequence
TraceLocation
TraceStartTime
TraceUseDefault
MdwConnection
ConnectionString
CacheDirectory
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
Counter
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopEventName
MDWConnectionString
ParentLogID
RowCountIn
SnapshotID
SourceID
TargetConnectionString
TraceCurrentEventTime
TraceCurrentFile
TraceDroppedEventCount
TraceID
TraceInfoID
TraceIsRunning
TraceLastEventSequence
TraceLocation
TraceStartTime
TraceUseDefault
TargetConnection
ConnectionString
CacheDirectory
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
Counter
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopEventName
MDWConnectionString
ParentLogID
RowCountIn
SnapshotID
SourceID
TargetConnectionString
TraceCurrentEventTime
TraceCurrentFile
TraceDroppedEventCount
TraceID
TraceInfoID
TraceIsRunning
TraceLastEventSequence
TraceLocation
TraceStartTime
TraceUseDefault
Event handlers
Executables
For Loop Container
FEF - For each trace file - regular trace upload
DFT - Upload trace file
AGG - Get max value of EventSequence
KeyScale
Keys
CountDistinctScale
CountDistinctKeys
AutoExtendFactor
Aggregate Input 1
EventSequence
Aggregate Output 1
KeyScale
Keys
EventSequence_Max
AggregationColumnId
AggregationType
IsBig
AggregationComparisonFlags
event_count
AggregationColumnId
AggregationType
IsBig
AggregationComparisonFlags
CNT - Error row count source
VariableName
Row Count Input 1
Row Count Output 1
CNT - Input row count
VariableName
Row Count Input 1
Row Count Output 1
CNT - Output row count
VariableName
Row Count Input 1
Row Count Output 1
Data Conversion
Data Conversion Input
SqlHandle
PlanHandle
Data Conversion Output
SqlHandle64
SourceInputColumnLineageID
FastParse
PlanHandle64
SourceInputColumnLineageID
FastParse
Data Conversion Error Output
ErrorCode
ErrorColumn
DRV - Add columns
Derived Column Input
EventSequence_Max
Derived Column Output
trace_info_id
Expression
FriendlyExpression
snapshot_id
Expression
FriendlyExpression
is_running
Expression
FriendlyExpression
dropped_event_count
Expression
FriendlyExpression
last_event_sequence
Expression
FriendlyExpression
Derived Column Error Output
ErrorCode
ErrorColumn
DRV - Add snapshot_id and trace_info_id
Derived Column Input
Derived Column Output
trace_info_id
Expression
FriendlyExpression
snapshot_id
Expression
FriendlyExpression
Derived Column Error Output
ErrorCode
ErrorColumn
MLT - Split two ways
Multicast Input 1
Multicast Output 1
Multicast Output 2
Multicast Output 3
ODB - Read trace
CommandTimeout
OpenRowset
OpenRowsetVariable
SqlCommand
SqlCommandVariable
DefaultCodePage
AlwaysUseDefaultCodePage
AccessMode
ParameterMapping
OLE DB Source Output
TextData
BinaryData
DatabaseID
TransactionID
LineNumber
NTUserName
NTDomainName
HostName
ClientProcessID
ApplicationName
LoginName
SPID
Duration
StartTime
EndTime
Reads
Writes
CPU
Permissions
Severity
EventSubClass
ObjectID
Success
IndexID
IntegerData
ServerName
EventClass
ObjectType
NestLevel
State
Error
Mode
Handle
ObjectName
DatabaseName
FileName
OwnerName
RoleName
TargetUserName
DBUserName
LoginSid
TargetLoginName
TargetLoginSid
ColumnPermissions
LinkedServerName
ProviderName
MethodName
RowCounts
RequestID
XactSequence
EventSequence
BigintData1
BigintData2
GUID
IntegerData2
ObjectID2
Type
OwnerID
ParentName
IsSystem
Offset
SourceDatabaseID
SqlHandle
SessionLoginName
PlanHandle
GroupID
TextData
BinaryData
DatabaseID
TransactionID
LineNumber
NTUserName
NTDomainName
HostName
ClientProcessID
ApplicationName
LoginName
SPID
Duration
StartTime
EndTime
Reads
Writes
CPU
Permissions
Severity
EventSubClass
ObjectID
Success
IndexID
IntegerData
ServerName
EventClass
ObjectType
NestLevel
State
Error
Mode
Handle
ObjectName
DatabaseName
FileName
OwnerName
RoleName
TargetUserName
DBUserName
LoginSid
TargetLoginName
TargetLoginSid
ColumnPermissions
LinkedServerName
ProviderName
MethodName
RowCounts
RequestID
XactSequence
EventSequence
BigintData1
BigintData2
GUID
IntegerData2
ObjectID2
Type
OwnerID
ParentName
IsSystem
Offset
SourceDatabaseID
SqlHandle
SessionLoginName
PlanHandle
GroupID
OLE DB Source Error Output
TextData
BinaryData
DatabaseID
TransactionID
LineNumber
NTUserName
NTDomainName
HostName
ClientProcessID
ApplicationName
LoginName
SPID
Duration
StartTime
EndTime
Reads
Writes
CPU
Permissions
Severity
EventSubClass
ObjectID
Success
IndexID
IntegerData
ServerName
EventClass
ObjectType
NestLevel
State
Error
Mode
Handle
ObjectName
DatabaseName
FileName
OwnerName
RoleName
TargetUserName
DBUserName
LoginSid
TargetLoginName
TargetLoginSid
ColumnPermissions
LinkedServerName
ProviderName
MethodName
RowCounts
RequestID
XactSequence
EventSequence
BigintData1
BigintData2
GUID
IntegerData2
ObjectID2
Type
OwnerID
ParentName
IsSystem
Offset
SourceDatabaseID
SqlHandle
SessionLoginName
PlanHandle
GroupID
ErrorCode
ErrorColumn
OleDbConnection
ODB - Update trace_info
CommandTimeout
SqlCommand
DefaultCodePage
OLE DB Command Input
@trace_info_id
DBParamInfoFlags
@snapshot_id
DBParamInfoFlags
@is_running
DBParamInfoFlags
@event_count
DBParamInfoFlags
@dropped_event_count
DBParamInfoFlags
@last_event_sequence
DBParamInfoFlags
trace_info_id
snapshot_id
is_running
event_count
dropped_event_count
last_event_sequence
OLE DB Command Output
OLE DB Command Error Output
ErrorCode
ErrorColumn
OleDbConnection
ODB - Write to output table
CommandTimeout
OpenRowset
OpenRowsetVariable
SqlCommand
DefaultCodePage
AlwaysUseDefaultCodePage
AccessMode
FastLoadKeepIdentity
FastLoadKeepNulls
FastLoadOptions
FastLoadMaxInsertCommitSize
OLE DB Destination Input
trace_info_id
snapshot_id
TextData
BinaryData
DatabaseID
TransactionID
LineNumber
NTUserName
NTDomainName
HostName
ClientProcessID
ApplicationName
LoginName
SPID
Duration
StartTime
EndTime
Reads
Writes
CPU
Permissions
Severity
EventSubClass
ObjectID
Success
IndexID
IntegerData
ServerName
EventClass
ObjectType
NestLevel
State
Error
Mode
Handle
ObjectName
DatabaseName
FileName
OwnerName
RoleName
TargetUserName
DBUserName
LoginSid
TargetLoginName
TargetLoginSid
ColumnPermissions
LinkedServerName
ProviderName
MethodName
RowCounts
RequestID
XactSequence
EventSequence
BigintData1
BigintData2
GUID
IntegerData2
ObjectID2
Type
OwnerID
ParentName
IsSystem
Offset
SourceDatabaseID
SqlHandle
SessionLoginName
PlanHandle
GroupID
TextData
BinaryData
DatabaseID
TransactionID
LineNumber
NTUserName
NTDomainName
HostName
ClientProcessID
ApplicationName
LoginName
SPID
Duration
StartTime
EndTime
Reads
Writes
CPU
Permissions
Severity
EventSubClass
ObjectID
Success
IndexID
IntegerData
ServerName
EventClass
ObjectType
NestLevel
State
Error
Mode
Handle
ObjectName
DatabaseName
FileName
OwnerName
RoleName
TargetUserName
DBUserName
LoginSid
TargetLoginName
TargetLoginSid
ColumnPermissions
LinkedServerName
ProviderName
MethodName
RowCounts
RequestID
XactSequence
EventSequence
BigintData1
BigintData2
GUID
IntegerData2
ObjectID2
Type
OwnerID
ParentName
IsSystem
Offset
SourceDatabaseID
SessionLoginName
trace_info_id
snapshot_id
GroupID
SqlHandle64
PlanHandle64
OLE DB Destination Error Output
ErrorCode
ErrorColumn
OleDbConnection
BufferSizeTuning
PipelineBufferLeak
PipelineComponentTime
PipelineExecutionPlan
PipelineExecutionTrees
PipelineInitialization
Aggregate Output 1
Data Conversion Output
Derived Column Output
Derived Column Output
Multicast Output 1
Multicast Output 2
OLE DB Source Error Output
OLE DB Source Output
Row Count Output 1
Row Count Output 1
TraceLoadScript
RowCountError
RowCountIn
RowCountOut
CacheDirectory
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
Counter
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopEventName
MDWConnectionString
ParentLogID
RowCountIn
SnapshotID
SourceID
TargetConnectionString
TraceCurrentEventTime
TraceCurrentFile
TraceDroppedEventCount
TraceID
TraceInfoID
TraceIsRunning
TraceLastEventSequence
TraceLocation
TraceStartTime
TraceUseDefault
FAT - Check if trace file is accessible
FilePath
Mode
RowCountError
RowCountIn
RowCountOut
CacheDirectory
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
Counter
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopEventName
MDWConnectionString
ParentLogID
RowCountIn
SnapshotID
SourceID
TargetConnectionString
TraceCurrentEventTime
TraceCurrentFile
TraceDroppedEventCount
TraceID
TraceInfoID
TraceIsRunning
TraceLastEventSequence
TraceLocation
TraceStartTime
TraceUseDefault
FAT - Precheck if trace file is accessible
FilePath
Mode
RowCountError
RowCountIn
RowCountOut
CacheDirectory
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
Counter
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopEventName
MDWConnectionString
ParentLogID
RowCountIn
SnapshotID
SourceID
TargetConnectionString
TraceCurrentEventTime
TraceCurrentFile
TraceDroppedEventCount
TraceID
TraceInfoID
TraceIsRunning
TraceLastEventSequence
TraceLocation
TraceStartTime
TraceUseDefault
FST - Delete trace file
OnError
RowCountError
RowCountIn
RowCountOut
CacheDirectory
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
Counter
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopEventName
MDWConnectionString
ParentLogID
RowCountIn
SnapshotID
SourceID
TargetConnectionString
TraceCurrentEventTime
TraceCurrentFile
TraceDroppedEventCount
TraceID
TraceInfoID
TraceIsRunning
TraceLastEventSequence
TraceLocation
TraceStartTime
TraceUseDefault
FileSystemOperation
RowCountError
RowCountIn
RowCountOut
CacheDirectory
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
Counter
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopEventName
MDWConnectionString
ParentLogID
RowCountIn
SnapshotID
SourceID
TargetConnectionString
TraceCurrentEventTime
TraceCurrentFile
TraceDroppedEventCount
TraceID
TraceInfoID
TraceIsRunning
TraceLastEventSequence
TraceLocation
TraceStartTime
TraceUseDefault
SQL - Log package stats
ExecuteSQLExecutingQuery
LoopDuration
RowCountError
RowCountIn
RowCountOut
CacheDirectory
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
Counter
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopEventName
MDWConnectionString
ParentLogID
RowCountIn
SnapshotID
SourceID
TargetConnectionString
TraceCurrentEventTime
TraceCurrentFile
TraceDroppedEventCount
TraceID
TraceInfoID
TraceIsRunning
TraceLastEventSequence
TraceLocation
TraceStartTime
TraceUseDefault
SQL - logs uploaded file name
ExecuteSQLExecutingQuery
RowCountError
RowCountIn
RowCountOut
CacheDirectory
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
Counter
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopEventName
MDWConnectionString
ParentLogID
RowCountIn
SnapshotID
SourceID
TargetConnectionString
TraceCurrentEventTime
TraceCurrentFile
TraceDroppedEventCount
TraceID
TraceInfoID
TraceIsRunning
TraceLastEventSequence
TraceLocation
TraceStartTime
TraceUseDefault
{821B0536-E431-458F-8EAE-028BE667F142}
Directory
FileSpec
Directory
FileSpec
Constraint
Constraint 1
Constraint 2
Constraint 3
Constraint 4
RowCountError
RowCountIn
RowCountOut
CacheDirectory
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
Counter
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopEventName
MDWConnectionString
ParentLogID
RowCountIn
SnapshotID
SourceID
TargetConnectionString
TraceCurrentEventTime
TraceCurrentFile
TraceDroppedEventCount
TraceID
TraceInfoID
TraceIsRunning
TraceLastEventSequence
TraceLocation
TraceStartTime
TraceUseDefault
SQL - Check trace info
ExecuteSQLExecutingQuery
CacheDirectory
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
Counter
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopEventName
MDWConnectionString
ParentLogID
RowCountIn
SnapshotID
SourceID
TargetConnectionString
TraceCurrentEventTime
TraceCurrentFile
TraceDroppedEventCount
TraceID
TraceInfoID
TraceIsRunning
TraceLastEventSequence
TraceLocation
TraceStartTime
TraceUseDefault
SQL - Close trace
ExecuteSQLExecutingQuery
CacheDirectory
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
Counter
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopEventName
MDWConnectionString
ParentLogID
RowCountIn
SnapshotID
SourceID
TargetConnectionString
TraceCurrentEventTime
TraceCurrentFile
TraceDroppedEventCount
TraceID
TraceInfoID
TraceIsRunning
TraceLastEventSequence
TraceLocation
TraceStartTime
TraceUseDefault
SQL - Get Last_Event_Sequence
ExecuteSQLExecutingQuery
CacheDirectory
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
Counter
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopEventName
MDWConnectionString
ParentLogID
RowCountIn
SnapshotID
SourceID
TargetConnectionString
TraceCurrentEventTime
TraceCurrentFile
TraceDroppedEventCount
TraceID
TraceInfoID
TraceIsRunning
TraceLastEventSequence
TraceLocation
TraceStartTime
TraceUseDefault
Constraint
Constraint 1
Constraint 2
CacheDirectory
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
Counter
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopEventName
MDWConnectionString
ParentLogID
RowCountIn
SnapshotID
SourceID
TargetConnectionString
TraceCurrentEventTime
TraceCurrentFile
TraceDroppedEventCount
TraceID
TraceInfoID
TraceIsRunning
TraceLastEventSequence
TraceLocation
TraceStartTime
TraceUseDefault
SEQ - Default trace upload
DFT - Upload default trace file
AGG - Get max value of EventSequence
KeyScale
Keys
CountDistinctScale
CountDistinctKeys
AutoExtendFactor
Aggregate Input 1
EventSequence
Aggregate Output 1
KeyScale
Keys
EventSequence_Max
AggregationColumnId
AggregationType
IsBig
AggregationComparisonFlags
event_count
AggregationColumnId
AggregationType
IsBig
AggregationComparisonFlags
CNT - Error row count source
VariableName
Row Count Input 1
Row Count Output 1
CNT - Input row count
VariableName
Row Count Input 1
Row Count Output 1
CNT - Output row count
VariableName
Row Count Input 1
Row Count Output 1
Data Conversion
Data Conversion Input
SqlHandle
PlanHandle
Data Conversion Output
SqlHandle64
SourceInputColumnLineageID
FastParse
PlanHandle64
SourceInputColumnLineageID
FastParse
Data Conversion Error Output
ErrorCode
ErrorColumn
DRV - Add columns
Derived Column Input
EventSequence_Max
Derived Column Output
trace_info_id
Expression
FriendlyExpression
snapshot_id
Expression
FriendlyExpression
is_running
Expression
FriendlyExpression
dropped_event_count
Expression
FriendlyExpression
last_event_sequence
Expression
FriendlyExpression
Derived Column Error Output
ErrorCode
ErrorColumn
DRV - Add snapshot_id and trace_info_id
Derived Column Input
Derived Column Output
trace_info_id
Expression
FriendlyExpression
snapshot_id
Expression
FriendlyExpression
Derived Column Error Output
ErrorCode
ErrorColumn
MLT - Split two ways
Multicast Input 1
Multicast Output 1
Multicast Output 2
Multicast Output 3
ODB - Read trace
CommandTimeout
OpenRowset
OpenRowsetVariable
SqlCommand
SqlCommandVariable
DefaultCodePage
AlwaysUseDefaultCodePage
AccessMode
ParameterMapping
OLE DB Source Output
TextData
BinaryData
DatabaseID
TransactionID
LineNumber
NTUserName
NTDomainName
HostName
ClientProcessID
ApplicationName
LoginName
SPID
Duration
StartTime
EndTime
Reads
Writes
CPU
Permissions
Severity
EventSubClass
ObjectID
Success
IndexID
IntegerData
ServerName
EventClass
ObjectType
NestLevel
State
Error
Mode
Handle
ObjectName
DatabaseName
FileName
OwnerName
RoleName
TargetUserName
DBUserName
LoginSid
TargetLoginName
TargetLoginSid
ColumnPermissions
LinkedServerName
ProviderName
MethodName
RowCounts
RequestID
XactSequence
EventSequence
BigintData1
BigintData2
GUID
IntegerData2
ObjectID2
Type
OwnerID
ParentName
IsSystem
Offset
SourceDatabaseID
SqlHandle
SessionLoginName
PlanHandle
GroupID
TextData
BinaryData
DatabaseID
TransactionID
LineNumber
NTUserName
NTDomainName
HostName
ClientProcessID
ApplicationName
LoginName
SPID
Duration
StartTime
EndTime
Reads
Writes
CPU
Permissions
Severity
EventSubClass
ObjectID
Success
IndexID
IntegerData
ServerName
EventClass
ObjectType
NestLevel
State
Error
Mode
Handle
ObjectName
DatabaseName
FileName
OwnerName
RoleName
TargetUserName
DBUserName
LoginSid
TargetLoginName
TargetLoginSid
ColumnPermissions
LinkedServerName
ProviderName
MethodName
RowCounts
RequestID
XactSequence
EventSequence
BigintData1
BigintData2
GUID
IntegerData2
ObjectID2
Type
OwnerID
ParentName
IsSystem
Offset
SourceDatabaseID
SqlHandle
SessionLoginName
PlanHandle
GroupID
OLE DB Source Error Output
TextData
BinaryData
DatabaseID
TransactionID
LineNumber
NTUserName
NTDomainName
HostName
ClientProcessID
ApplicationName
LoginName
SPID
Duration
StartTime
EndTime
Reads
Writes
CPU
Permissions
Severity
EventSubClass
ObjectID
Success
IndexID
IntegerData
ServerName
EventClass
ObjectType
NestLevel
State
Error
Mode
Handle
ObjectName
DatabaseName
FileName
OwnerName
RoleName
TargetUserName
DBUserName
LoginSid
TargetLoginName
TargetLoginSid
ColumnPermissions
LinkedServerName
ProviderName
MethodName
RowCounts
RequestID
XactSequence
EventSequence
BigintData1
BigintData2
GUID
IntegerData2
ObjectID2
Type
OwnerID
ParentName
IsSystem
Offset
SourceDatabaseID
SqlHandle
SessionLoginName
PlanHandle
GroupID
ErrorCode
ErrorColumn
OleDbConnection
ODB - Update trace_info
CommandTimeout
SqlCommand
DefaultCodePage
OLE DB Command Input
@trace_info_id
DBParamInfoFlags
@snapshot_id
DBParamInfoFlags
@is_running
DBParamInfoFlags
@event_count
DBParamInfoFlags
@dropped_event_count
DBParamInfoFlags
@last_event_sequence
DBParamInfoFlags
trace_info_id
snapshot_id
is_running
event_count
dropped_event_count
last_event_sequence
OLE DB Command Output
OLE DB Command Error Output
ErrorCode
ErrorColumn
OleDbConnection
ODB - Write to output table
CommandTimeout
OpenRowset
OpenRowsetVariable
SqlCommand
DefaultCodePage
AlwaysUseDefaultCodePage
AccessMode
FastLoadKeepIdentity
FastLoadKeepNulls
FastLoadOptions
FastLoadMaxInsertCommitSize
OLE DB Destination Input
trace_info_id
snapshot_id
TextData
BinaryData
DatabaseID
TransactionID
LineNumber
NTUserName
NTDomainName
HostName
ClientProcessID
ApplicationName
LoginName
SPID
Duration
StartTime
EndTime
Reads
Writes
CPU
Permissions
Severity
EventSubClass
ObjectID
Success
IndexID
IntegerData
ServerName
EventClass
ObjectType
NestLevel
State
Error
Mode
Handle
ObjectName
DatabaseName
FileName
OwnerName
RoleName
TargetUserName
DBUserName
LoginSid
TargetLoginName
TargetLoginSid
ColumnPermissions
LinkedServerName
ProviderName
MethodName
RowCounts
RequestID
XactSequence
EventSequence
BigintData1
BigintData2
GUID
IntegerData2
ObjectID2
Type
OwnerID
ParentName
IsSystem
Offset
SourceDatabaseID
SqlHandle
SessionLoginName
PlanHandle
GroupID
TextData
BinaryData
DatabaseID
TransactionID
LineNumber
NTUserName
NTDomainName
HostName
ClientProcessID
ApplicationName
LoginName
SPID
Duration
StartTime
EndTime
Reads
Writes
CPU
Permissions
Severity
EventSubClass
ObjectID
Success
IndexID
IntegerData
ServerName
EventClass
ObjectType
NestLevel
State
Error
Mode
Handle
ObjectName
DatabaseName
FileName
OwnerName
RoleName
TargetUserName
DBUserName
LoginSid
TargetLoginName
TargetLoginSid
ColumnPermissions
LinkedServerName
ProviderName
MethodName
RowCounts
RequestID
XactSequence
EventSequence
BigintData1
BigintData2
GUID
IntegerData2
ObjectID2
Type
OwnerID
ParentName
IsSystem
Offset
SourceDatabaseID
SessionLoginName
trace_info_id
snapshot_id
GroupID
SqlHandle64
PlanHandle64
OLE DB Destination Error Output
ErrorCode
ErrorColumn
OleDbConnection
BufferSizeTuning
PipelineBufferLeak
PipelineComponentTime
PipelineExecutionPlan
PipelineExecutionTrees
PipelineInitialization
Aggregate Output 1
Data Conversion Output
Derived Column Output
Derived Column Output
Multicast Output 1
Multicast Output 2
OLE DB Source Error Output
OLE DB Source Output
Row Count Output 1
Row Count Output 1
TraceLoadScript
RowCountError
RowCountIn
RowCountOut
CacheDirectory
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
Counter
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopEventName
MDWConnectionString
ParentLogID
RowCountIn
SnapshotID
SourceID
TargetConnectionString
TraceCurrentEventTime
TraceCurrentFile
TraceDroppedEventCount
TraceID
TraceInfoID
TraceIsRunning
TraceLastEventSequence
TraceLocation
TraceStartTime
TraceUseDefault
SQL - Log package stats
ExecuteSQLExecutingQuery
LoopDuration
RowCountError
RowCountIn
RowCountOut
CacheDirectory
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
Counter
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopEventName
MDWConnectionString
ParentLogID
RowCountIn
SnapshotID
SourceID
TargetConnectionString
TraceCurrentEventTime
TraceCurrentFile
TraceDroppedEventCount
TraceID
TraceInfoID
TraceIsRunning
TraceLastEventSequence
TraceLocation
TraceStartTime
TraceUseDefault
Constraint
RowCountError
RowCountIn
RowCountOut
CacheDirectory
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
Counter
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopEventName
MDWConnectionString
ParentLogID
RowCountIn
SnapshotID
SourceID
TargetConnectionString
TraceCurrentEventTime
TraceCurrentFile
TraceDroppedEventCount
TraceID
TraceInfoID
TraceIsRunning
TraceLastEventSequence
TraceLocation
TraceStartTime
TraceUseDefault
SQL - Close trace
ExecuteSQLExecutingQuery
CacheDirectory
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
Counter
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopEventName
MDWConnectionString
ParentLogID
RowCountIn
SnapshotID
SourceID
TargetConnectionString
TraceCurrentEventTime
TraceCurrentFile
TraceDroppedEventCount
TraceID
TraceInfoID
TraceIsRunning
TraceLastEventSequence
TraceLocation
TraceStartTime
TraceUseDefault
SQL - Get last upload time
ExecuteSQLExecutingQuery
CacheDirectory
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
Counter
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopEventName
MDWConnectionString
ParentLogID
RowCountIn
SnapshotID
SourceID
TargetConnectionString
TraceCurrentEventTime
TraceCurrentFile
TraceDroppedEventCount
TraceID
TraceInfoID
TraceIsRunning
TraceLastEventSequence
TraceLocation
TraceStartTime
TraceUseDefault
SQL - Get snapshot id
ExecuteSQLExecutingQuery
CacheDirectory
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
Counter
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopEventName
MDWConnectionString
ParentLogID
RowCountIn
SnapshotID
SourceID
TargetConnectionString
TraceCurrentEventTime
TraceCurrentFile
TraceDroppedEventCount
TraceID
TraceInfoID
TraceIsRunning
TraceLastEventSequence
TraceLocation
TraceStartTime
TraceUseDefault
SQL - Get trace info
ExecuteSQLExecutingQuery
CacheDirectory
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
Counter
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopEventName
MDWConnectionString
ParentLogID
RowCountIn
SnapshotID
SourceID
TargetConnectionString
TraceCurrentEventTime
TraceCurrentFile
TraceDroppedEventCount
TraceID
TraceInfoID
TraceIsRunning
TraceLastEventSequence
TraceLocation
TraceStartTime
TraceUseDefault
SQL - Update data source
ExecuteSQLExecutingQuery
CacheDirectory
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
Counter
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopEventName
MDWConnectionString
ParentLogID
RowCountIn
SnapshotID
SourceID
TargetConnectionString
TraceCurrentEventTime
TraceCurrentFile
TraceDroppedEventCount
TraceID
TraceInfoID
TraceIsRunning
TraceLastEventSequence
TraceLocation
TraceStartTime
TraceUseDefault
XML - Check use_default attribute
XMLOperation
CacheDirectory
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
Counter
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopEventName
MDWConnectionString
ParentLogID
RowCountIn
SnapshotID
SourceID
TargetConnectionString
TraceCurrentEventTime
TraceCurrentFile
TraceDroppedEventCount
TraceID
TraceInfoID
TraceIsRunning
TraceLastEventSequence
TraceLocation
TraceStartTime
TraceUseDefault
Log Entry Information
Diagnostic
DiagnosticEx
Log providers
Project Parameters
Precedence constraints
Constraint
Constraint 1
Constraint 2
Constraint 3
Constraint 5
Constraint 6
Constraint 8
Variables
CacheDirectory
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
Counter
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopEventName
MDWConnectionString
ParentLogID
RowCountIn
SnapshotID
SourceID
TargetConnectionString
TraceCurrentEventTime
TraceCurrentFile
TraceDroppedEventCount
TraceID
TraceInfoID
TraceIsRunning
TraceLastEventSequence
TraceLocation
TraceStartTime
TraceUseDefault
SQL Server storages
ALEN-PC\SQLSERVER2016
PerfCountersCollect
Configuration settings
CacheDirectory
CacheWindow
InputParameters
MDWConnectionString
ConfigConnectionString
TargetConnectionString
LoopEventName
ExitEventName
CollectorTypeUID
CollectionSetUID
ItemID
InstanceID
InstanceName
LoggingLevel
LogID
ParentLogID
Connection managers
ConfigConnection
ConnectionString
CacheDirectory
CacheFilename
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
RowCountIn
RowCountOut
TargetConnectionString
TargetProcessID
Event handlers
Executables
LOOP - Aquire performance counters @ collection item frequency
Collect Upload Package Sync Sequence Container
DFT - Retrieve Performance Counters
Perfomance Counters Source
InputParameters
TxPerfCounters Output
path
formatted_value
raw_value_first
raw_value_second
counter_type
collection_time
object_name
counter_name
instance_name
RC - Number of counters collected
VariableName
Row Count Input 1
Row Count Output 1
RFD - Write to cache
AccessMode
FileName
FileNameVariable
WriteOption
Raw File Destination Input
collection_time
path
formatted_value
raw_value_first
raw_value_second
counter_type
object_name
instance_name
counter_name
path
formatted_value
raw_value_first
raw_value_second
counter_type
collection_time
object_name
counter_name
instance_name
BufferSizeTuning
PipelineBufferLeak
PipelineComponentTime
PipelineExecutionPlan
PipelineExecutionTrees
PipelineInitialization
Row Count Output 1
TxPerfCounters Output
SyncRoot
CacheDirectory
CacheFilename
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
RowCountIn
RowCountOut
TargetConnectionString
TargetProcessID
SyncRoot
CacheDirectory
CacheFilename
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
RowCountIn
RowCountOut
TargetConnectionString
TargetProcessID
Get SQL Process ID
ExecuteSQLExecutingQuery
SqlProcessID
CacheDirectory
CacheFilename
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
RowCountIn
RowCountOut
TargetConnectionString
TargetProcessID
No-Op Sequence Container
CacheDirectory
CacheFilename
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
RowCountIn
RowCountOut
TargetConnectionString
TargetProcessID
SQL - Log Package Iteration
ExecuteSQLExecutingQuery
CacheDirectory
CacheFilename
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
RowCountIn
RowCountOut
TargetConnectionString
TargetProcessID
SQL - Log Package Stats
ExecuteSQLExecutingQuery
CacheDirectory
CacheFilename
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
RowCountIn
RowCountOut
TargetConnectionString
TargetProcessID
{710AEAF2-45BD-4AB2-9EAF-FB6268AD10A2}
ExitEventName
LoopEventName
ExitEventName
LoopEventName
Constraint
Constraint 1
Constraint 2
Constraint 3
Constraint 4
CacheDirectory
CacheFilename
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
RowCountIn
RowCountOut
TargetConnectionString
TargetProcessID
Log Entry Information
Diagnostic
DiagnosticEx
Log providers
Project Parameters
Precedence constraints
Variables
CacheDirectory
CacheFilename
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
RowCountIn
RowCountOut
TargetConnectionString
TargetProcessID
PerfCountersUpload
Configuration settings
CacheDirectory
CacheWindow
InputParameters
MDWConnectionString
ConfigConnectionString
TargetConnectionString
LoopEventName
ExitEventName
CollectorTypeUID
CollectionSetUID
ItemID
InstanceID
InstanceName
LoggingLevel
LogID
ParentLogID
DaysUntilExpiration
Connection managers
ConfigConnection
ConnectionString
CacheDirectory
CacheFileName
CacheOutput
CacheUploadFilesPrefixPattern
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopEventName
MDWConnectionString
ParentLogID
SnapshotID
SourceID
TargetConnectionString
MdwConnection
ConnectionString
CacheDirectory
CacheFileName
CacheOutput
CacheUploadFilesPrefixPattern
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopEventName
MDWConnectionString
ParentLogID
SnapshotID
SourceID
TargetConnectionString
TargetConnection
ConnectionString
CacheDirectory
CacheFileName
CacheOutput
CacheUploadFilesPrefixPattern
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopEventName
MDWConnectionString
ParentLogID
SnapshotID
SourceID
TargetConnectionString
Event handlers
Executables
CWM - Delete Old Cache Files
CacheFileNamePrefixVarName
LoopDuration
CacheDirectory
CacheFileName
CacheOutput
CacheUploadFilesPrefixPattern
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopEventName
MDWConnectionString
ParentLogID
SnapshotID
SourceID
TargetConnectionString
FEF - For Each Collected Cache File Remaining, Try to Upload
DFT - Bulk Insert Collected data into MDW
DRV - Add snapshot id
Derived Column Input
collection_time
Derived Column Output
snapshot_id
Expression
FriendlyExpression
collect_time_convert
Expression
FriendlyExpression
Derived Column Error Output
ErrorCode
ErrorColumn
LKU - Lookup into performance_counter_instances to obtain performance_counter_id for all counter paths that get inserted
SqlCommand
SqlCommandParam
CacheType
MaxMemoryUsage
MaxMemoryUsage64
ReferenceMetadataXml
ParameterMap
DefaultCodePage
ConnectionType
NoMatchBehavior
NoMatchCachePercentage
TreatDuplicateKeysAsError
Lookup Input
path
JoinToReferenceColumn
CopyFromReferenceColumn
Lookup Match Output
performance_counter_id
CopyFromReferenceColumn
Lookup No Match Output
Lookup Error Output
ErrorCode
ErrorColumn
OleDbConnection
ODB - Fast upload data to performance_counter_values
CommandTimeout
OpenRowset
OpenRowsetVariable
SqlCommand
DefaultCodePage
AlwaysUseDefaultCodePage
AccessMode
FastLoadKeepIdentity
FastLoadKeepNulls
FastLoadOptions
FastLoadMaxInsertCommitSize
OLE DB Destination Input
performance_counter_instance_id
snapshot_id
collection_time
formatted_value
raw_value_first
raw_value_second
snapshot_id
raw_value_second
raw_value_first
formatted_value
performance_counter_id
collect_time_convert
OLE DB Destination Error Output
ErrorCode
ErrorColumn
OleDbConnection
RAW - Read current tempoary storage
AccessMode
FileName
FileNameVariable
Raw File Source Output
collection_time
path
formatted_value
raw_value_first
raw_value_second
counter_type
object_name
instance_name
counter_name
collection_time
path
formatted_value
raw_value_first
raw_value_second
counter_type
object_name
instance_name
counter_name
RC - Number of rows failed to insert
VariableName
Row Count Input 1
Row Count Output 1
RC - Number of rows from cache
VariableName
Row Count Input 1
Row Count Output 1
RC - Number of rows inserted
VariableName
Row Count Input 1
Row Count Output 1
BufferSizeTuning
PipelineBufferLeak
PipelineComponentTime
PipelineExecutionPlan
PipelineExecutionTrees
PipelineInitialization
Derived Column Output
Failed Rows
Lookup Match Output
Raw File Source Output
Row Count Output 1
Row Count Output 1
CacheFileToUpload
LoopDuration
RowCountError
RowCountIn
RowCountOut
RowCountOutFinal
CacheDirectory
CacheFileName
CacheOutput
CacheUploadFilesPrefixPattern
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopEventName
MDWConnectionString
ParentLogID
SnapshotID
SourceID
TargetConnectionString
DFT - Update perf_counters_instances table with newly discovered instances
ODB - Fast upload data to performance_counters_instances for the new instance path-s that we discovered (together with thier type)
CommandTimeout
OpenRowset
OpenRowsetVariable
SqlCommand
DefaultCodePage
AlwaysUseDefaultCodePage
AccessMode
FastLoadKeepIdentity
FastLoadKeepNulls
FastLoadOptions
FastLoadMaxInsertCommitSize
OLE DB Destination Input
performance_counter_id
path
counter_type
object_name
counter_name
instance_name
path
counter_type
object_name
counter_name
instance_name
OLE DB Destination Error Output
ErrorCode
ErrorColumn
OleDbConnection
RAW - Read current tempoary storage - purpose - obtain counter paths
AccessMode
FileName
FileNameVariable
Raw File Source Output
collection_time
path
formatted_value
raw_value_first
raw_value_second
counter_type
object_name
instance_name
counter_name
collection_time
path
formatted_value
raw_value_first
raw_value_second
counter_type
object_name
instance_name
counter_name
BufferSizeTuning
PipelineBufferLeak
PipelineComponentTime
PipelineExecutionPlan
PipelineExecutionTrees
PipelineInitialization
Raw File Source Output
CacheFileToUpload
LoopDuration
RowCountError
RowCountIn
RowCountOut
RowCountOutFinal
CacheDirectory
CacheFileName
CacheOutput
CacheUploadFilesPrefixPattern
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopEventName
MDWConnectionString
ParentLogID
SnapshotID
SourceID
TargetConnectionString
FST - Cleanup
FileSystemOperation
CacheFileToUpload
LoopDuration
RowCountError
RowCountIn
RowCountOut
RowCountOutFinal
CacheDirectory
CacheFileName
CacheOutput
CacheUploadFilesPrefixPattern
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopEventName
MDWConnectionString
ParentLogID
SnapshotID
SourceID
TargetConnectionString
SQL - Log Package Stats
ExecuteSQLExecutingQuery
CacheFileToUpload
LoopDuration
RowCountError
RowCountIn
RowCountOut
RowCountOutFinal
CacheDirectory
CacheFileName
CacheOutput
CacheUploadFilesPrefixPattern
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopEventName
MDWConnectionString
ParentLogID
SnapshotID
SourceID
TargetConnectionString
{EE8E4F57-1623-455B-B0B2-ABCCA165FFB5}
Directory
FileSpec
Directory
FileSpec
Constraint
Constraint 1
Constraint 2
CacheFileToUpload
LoopDuration
RowCountError
RowCountIn
RowCountOut
RowCountOutFinal
CacheDirectory
CacheFileName
CacheOutput
CacheUploadFilesPrefixPattern
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopEventName
MDWConnectionString
ParentLogID
SnapshotID
SourceID
TargetConnectionString
Sequence Container
FAT - Check Current Cache File Exists
FilePath
Mode
SyncRoot
CacheDirectory
CacheFileName
CacheOutput
CacheUploadFilesPrefixPattern
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopEventName
MDWConnectionString
ParentLogID
SnapshotID
SourceID
TargetConnectionString
FST - Rename Current Cache File
FileSystemOperation
SyncRoot
CacheDirectory
CacheFileName
CacheOutput
CacheUploadFilesPrefixPattern
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopEventName
MDWConnectionString
ParentLogID
SnapshotID
SourceID
TargetConnectionString
Constraint
SyncRoot
CacheDirectory
CacheFileName
CacheOutput
CacheUploadFilesPrefixPattern
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopEventName
MDWConnectionString
ParentLogID
SnapshotID
SourceID
TargetConnectionString
SQL - Create snapshot ID in MDW
ExecuteSQLExecutingQuery
CacheDirectory
CacheFileName
CacheOutput
CacheUploadFilesPrefixPattern
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopEventName
MDWConnectionString
ParentLogID
SnapshotID
SourceID
TargetConnectionString
SQL - Register collection set to MDW
ExecuteSQLExecutingQuery
CacheDirectory
CacheFileName
CacheOutput
CacheUploadFilesPrefixPattern
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopEventName
MDWConnectionString
ParentLogID
SnapshotID
SourceID
TargetConnectionString
Log Entry Information
Diagnostic
DiagnosticEx
Log providers
Project Parameters
Precedence constraints
Constraint 2
Constraint 3
Constraint 4
Constraint 5
Variables
CacheDirectory
CacheFileName
CacheOutput
CacheUploadFilesPrefixPattern
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopEventName
MDWConnectionString
ParentLogID
SnapshotID
SourceID
TargetConnectionString
QueryActivityCollect
Configuration settings
CacheDirectory
CacheWindow
InputParameters
MDWConnectionString
ConfigConnectionString
TargetConnectionString
LoopEventName
ExitEventName
CollectorTypeUID
CollectionSetUID
ItemID
InstanceID
InstanceName
LoggingLevel
LogID
ParentLogID
DaysUntilExpiration
Connection managers
ConfigConnection
ConnectionString
CacheDirectory
CacheFilePrefixPattern
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
SnapshotExecRequestQuery
TargetConnectionString
MdwConnection
ConnectionString
CacheDirectory
CacheFilePrefixPattern
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
SnapshotExecRequestQuery
TargetConnectionString
TargetConnection
ConnectionString
CacheDirectory
CacheFilePrefixPattern
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
SnapshotExecRequestQuery
TargetConnectionString
Event handlers
Executables
LOOP - Query the query statitics DMV at collection frequency
SEQ - Synchronize Access to Cache File
DFT - Collect DMV Data
CNT - Error row count
VariableName
Row Count Input 1
Row Count Output 1
CNT - Input row count
VariableName
Row Count Input 1
Row Count Output 1
ODS - Get snapshot of dm_exec_requests
CommandTimeout
OpenRowset
OpenRowsetVariable
SqlCommand
SqlCommandVariable
DefaultCodePage
AlwaysUseDefaultCodePage
AccessMode
ParameterMapping
OLE DB Source Output
sql_handle
statement_start_offset
statement_end_offset
plan_handle
collection_time
row_id
session_id
request_id
exec_context_id
blocking_session_id
is_blocking
blocking_exec_context_id
scheduler_id
database_name
user_id
task_state
request_status
session_status
executing_managed_code
login_time
is_user_process
host_name
program_name
login_name
wait_type
last_wait_type
wait_duration_ms
wait_resource
resource_description
transaction_id
open_transaction_count
transaction_isolation_level
request_cpu_time
request_logical_reads
request_reads
request_writes
request_total_elapsed_time
request_start_time
memory_usage
session_cpu_time
session_reads
session_writes
session_logical_reads
session_total_scheduled_time
session_total_elapsed_time
open_resultsets
session_row_count
prev_error
pending_io_count
command
last_request_start_time
last_request_end_time
statement_start_offset
statement_end_offset
collection_time
sql_handle
plan_handle
row_id
session_id
request_id
exec_context_id
blocking_session_id
is_blocking
blocking_exec_context_id
scheduler_id
database_name
user_id
task_state
request_status
session_status
executing_managed_code
login_time
is_user_process
host_name
program_name
login_name
wait_type
last_wait_type
wait_duration_ms
wait_resource
resource_description
transaction_id
open_transaction_count
transaction_isolation_level
request_cpu_time
request_logical_reads
request_reads
request_writes
request_total_elapsed_time
request_start_time
memory_usage
session_cpu_time
session_reads
session_writes
session_logical_reads
session_total_scheduled_time
session_total_elapsed_time
open_resultsets
session_row_count
prev_error
pending_io_count
command
last_request_start_time
last_request_end_time
OLE DB Source Error Output
row_id
session_id
request_id
exec_context_id
blocking_session_id
is_blocking
blocking_exec_context_id
scheduler_id
database_name
user_id
task_state
request_status
session_status
executing_managed_code
login_time
is_user_process
host_name
program_name
login_name
wait_type
last_wait_type
wait_duration_ms
wait_resource
resource_description
transaction_id
open_transaction_count
transaction_isolation_level
request_cpu_time
request_logical_reads
request_reads
request_writes
request_total_elapsed_time
request_start_time
memory_usage
session_cpu_time
session_reads
session_writes
session_logical_reads
session_total_scheduled_time
session_total_elapsed_time
last_request_start_time
last_request_end_time
open_resultsets
session_row_count
prev_error
pending_io_count
command
statement_start_offset
statement_end_offset
collection_time
ErrorCode
ErrorColumn
sql_handle
plan_handle
OleDbConnection
RFD - Write data to a cache
AccessMode
FileName
FileNameVariable
WriteOption
Raw File Destination Input
statement_start_offset
statement_end_offset
collection_time
sql_handle
plan_handle
row_id
session_id
request_id
exec_context_id
blocking_session_id
is_blocking
blocking_exec_context_id
scheduler_id
database_name
user_id
task_state
request_status
session_status
executing_managed_code
login_time
is_user_process
host_name
program_name
login_name
wait_type
last_wait_type
wait_duration_ms
wait_resource
resource_description
transaction_id
open_transaction_count
transaction_isolation_level
request_cpu_time
request_logical_reads
request_reads
request_writes
request_total_elapsed_time
request_start_time
memory_usage
session_cpu_time
session_reads
session_writes
session_logical_reads
session_total_scheduled_time
session_total_elapsed_time
session_last_request_start_time
session_last_request_end_time
open_resultsets
session_row_count
prev_error
pending_io_count
command
statement_start_offset
statement_end_offset
collection_time
sql_handle
plan_handle
row_id
session_id
request_id
exec_context_id
blocking_session_id
is_blocking
blocking_exec_context_id
scheduler_id
database_name
user_id
task_state
request_status
session_status
executing_managed_code
login_time
is_user_process
host_name
program_name
login_name
wait_type
last_wait_type
wait_duration_ms
wait_resource
resource_description
transaction_id
open_transaction_count
transaction_isolation_level
request_cpu_time
request_logical_reads
request_reads
request_writes
request_total_elapsed_time
request_start_time
memory_usage
session_cpu_time
session_reads
session_writes
session_logical_reads
session_total_scheduled_time
session_total_elapsed_time
last_request_start_time
last_request_end_time
open_resultsets
session_row_count
prev_error
pending_io_count
command
BufferSizeTuning
PipelineBufferLeak
PipelineComponentTime
PipelineExecutionPlan
PipelineExecutionTrees
PipelineInitialization
OLE DB Source Error Output
OLE DB Source Output
Row Count Output 1
CacheFileName
SyncRoot
DMVErrorRowCount
DMVInOutRowCount
CacheDirectory
CacheFilePrefixPattern
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
SnapshotExecRequestQuery
TargetConnectionString
SyncRoot
DMVErrorRowCount
DMVInOutRowCount
CacheDirectory
CacheFilePrefixPattern
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
SnapshotExecRequestQuery
TargetConnectionString
SQL - Log Package Iteration
ExecuteSQLExecutingQuery
DMVErrorRowCount
DMVInOutRowCount
CacheDirectory
CacheFilePrefixPattern
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
SnapshotExecRequestQuery
TargetConnectionString
SQL - Log Package Stats
ExecuteSQLExecutingQuery
DMVErrorRowCount
DMVInOutRowCount
CacheDirectory
CacheFilePrefixPattern
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
SnapshotExecRequestQuery
TargetConnectionString
{7283E196-D60C-438F-A58A-0EA1F41BBCF4}
ExitEventName
LoopEventName
ExitEventName
LoopEventName
Constraint
Constraint 1
DMVErrorRowCount
DMVInOutRowCount
CacheDirectory
CacheFilePrefixPattern
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
SnapshotExecRequestQuery
TargetConnectionString
Log Entry Information
Diagnostic
DiagnosticEx
Log providers
Project Parameters
Precedence constraints
Variables
CacheDirectory
CacheFilePrefixPattern
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
SnapshotExecRequestQuery
TargetConnectionString
QueryActivityUpload
Configuration settings
CacheDirectory
CacheWindow
InputParameters
MDWConnectionString
ConfigConnectionString
TargetConnectionString
LoopEventName
ExitEventName
CollectorTypeUID
CollectionSetUID
ItemID
InstanceID
InstanceName
LoggingLevel
LogID
ParentLogID
DaysUntilExpiration
Connection managers
ConfigConnection
ConnectionString
CacheDirectory
CacheWindow
CollectionCacheFileName
CollectionCacheFileNameOutput
CollectionCacheFilePrefixPattern
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
InterestingQueries_HighCpuUsage
InterestingQueries_HighIoCount
InterestingQueries_HighMemoryUsage
InterestingQueries_HighTransactionCount
InterestingQueries_LargeResultset
InterestingQueries_LongRunningRequest
InterestingQueries_LongWaitingRequest
InterestingQueriesCount
InterestingQueriesLastSnapshotFileName
InterestingQueriesLastSnapshotFileNameOutput
InterestingQueriesSnapshotFileNamePrefixPattern
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
SnapshotId
SnapshotQueryStatsQuery
SourceId
TargetConnectionString
TopThreshold
ConfigConnection2
ConnectionString
CacheDirectory
CacheWindow
CollectionCacheFileName
CollectionCacheFileNameOutput
CollectionCacheFilePrefixPattern
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
InterestingQueries_HighCpuUsage
InterestingQueries_HighIoCount
InterestingQueries_HighMemoryUsage
InterestingQueries_HighTransactionCount
InterestingQueries_LargeResultset
InterestingQueries_LongRunningRequest
InterestingQueries_LongWaitingRequest
InterestingQueriesCount
InterestingQueriesLastSnapshotFileName
InterestingQueriesLastSnapshotFileNameOutput
InterestingQueriesSnapshotFileNamePrefixPattern
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
SnapshotId
SnapshotQueryStatsQuery
SourceId
TargetConnectionString
TopThreshold
MdwConnection
ConnectionString
CacheDirectory
CacheWindow
CollectionCacheFileName
CollectionCacheFileNameOutput
CollectionCacheFilePrefixPattern
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
InterestingQueries_HighCpuUsage
InterestingQueries_HighIoCount
InterestingQueries_HighMemoryUsage
InterestingQueries_HighTransactionCount
InterestingQueries_LargeResultset
InterestingQueries_LongRunningRequest
InterestingQueries_LongWaitingRequest
InterestingQueriesCount
InterestingQueriesLastSnapshotFileName
InterestingQueriesLastSnapshotFileNameOutput
InterestingQueriesSnapshotFileNamePrefixPattern
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
SnapshotId
SnapshotQueryStatsQuery
SourceId
TargetConnectionString
TopThreshold
TargetConnection
ConnectionString
CacheDirectory
CacheWindow
CollectionCacheFileName
CollectionCacheFileNameOutput
CollectionCacheFilePrefixPattern
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
InterestingQueries_HighCpuUsage
InterestingQueries_HighIoCount
InterestingQueries_HighMemoryUsage
InterestingQueries_HighTransactionCount
InterestingQueries_LargeResultset
InterestingQueries_LongRunningRequest
InterestingQueries_LongWaitingRequest
InterestingQueriesCount
InterestingQueriesLastSnapshotFileName
InterestingQueriesLastSnapshotFileNameOutput
InterestingQueriesSnapshotFileNamePrefixPattern
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
SnapshotId
SnapshotQueryStatsQuery
SourceId
TargetConnectionString
TopThreshold
Event handlers
Executables
CWM - Remove Upload Snapshots Older Than CacheWindow
CacheFileNamePrefixVarName
CacheDirectory
CacheWindow
CollectionCacheFileName
CollectionCacheFileNameOutput
CollectionCacheFilePrefixPattern
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
InterestingQueries_HighCpuUsage
InterestingQueries_HighIoCount
InterestingQueries_HighMemoryUsage
InterestingQueries_HighTransactionCount
InterestingQueries_LargeResultset
InterestingQueries_LongRunningRequest
InterestingQueries_LongWaitingRequest
InterestingQueriesCount
InterestingQueriesLastSnapshotFileName
InterestingQueriesLastSnapshotFileNameOutput
InterestingQueriesSnapshotFileNamePrefixPattern
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
SnapshotId
SnapshotQueryStatsQuery
SourceId
TargetConnectionString
TopThreshold
FAT - Check Cache File Exists
FilePath
Mode
CacheDirectory
CacheWindow
CollectionCacheFileName
CollectionCacheFileNameOutput
CollectionCacheFilePrefixPattern
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
InterestingQueries_HighCpuUsage
InterestingQueries_HighIoCount
InterestingQueries_HighMemoryUsage
InterestingQueries_HighTransactionCount
InterestingQueries_LargeResultset
InterestingQueries_LongRunningRequest
InterestingQueries_LongWaitingRequest
InterestingQueriesCount
InterestingQueriesLastSnapshotFileName
InterestingQueriesLastSnapshotFileNameOutput
InterestingQueriesSnapshotFileNamePrefixPattern
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
SnapshotId
SnapshotQueryStatsQuery
SourceId
TargetConnectionString
TopThreshold
FEF - For each collected cache file try upload
DFT - Upload collection snapshot
DRV - Add snapshot_id column
Derived Column Input
Derived Column Output
snapshot_id
Expression
FriendlyExpression
Derived Column Error Output
ErrorCode
ErrorColumn
ODS - Upload snapshots into active_sessions_and_requests table
CommandTimeout
OpenRowset
OpenRowsetVariable
SqlCommand
DefaultCodePage
AlwaysUseDefaultCodePage
AccessMode
FastLoadKeepIdentity
FastLoadKeepNulls
FastLoadOptions
FastLoadMaxInsertCommitSize
OLE DB Destination Input
row_id
session_id
request_id
exec_context_id
blocking_session_id
is_blocking
blocking_exec_context_id
scheduler_id
database_name
user_id
task_state
request_status
session_status
executing_managed_code
login_time
is_user_process
host_name
program_name
login_name
wait_type
last_wait_type
wait_duration_ms
wait_resource
resource_description
transaction_id
open_transaction_count
transaction_isolation_level
request_cpu_time
request_logical_reads
request_reads
request_writes
request_total_elapsed_time
request_start_time
memory_usage
session_cpu_time
session_reads
session_writes
session_logical_reads
session_total_scheduled_time
session_total_elapsed_time
session_last_request_start_time
session_last_request_end_time
open_resultsets
session_row_count
prev_error
pending_io_count
command
plan_handle
sql_handle
statement_start_offset
statement_end_offset
collection_time
snapshot_id
sql_handle
statement_start_offset
statement_end_offset
plan_handle
collection_time
row_id
session_id
request_id
exec_context_id
blocking_session_id
is_blocking
blocking_exec_context_id
scheduler_id
database_name
user_id
task_state
request_status
session_status
executing_managed_code
login_time
is_user_process
host_name
program_name
login_name
wait_type
last_wait_type
wait_duration_ms
wait_resource
resource_description
transaction_id
open_transaction_count
transaction_isolation_level
request_cpu_time
request_logical_reads
request_reads
request_writes
request_total_elapsed_time
request_start_time
memory_usage
session_cpu_time
session_reads
session_writes
session_logical_reads
session_total_scheduled_time
session_total_elapsed_time
session_last_request_start_time
session_last_request_end_time
open_resultsets
session_row_count
prev_error
pending_io_count
command
snapshot_id
OLE DB Destination Error Output
ErrorCode
ErrorColumn
OleDbConnection
RC - Count output rows
VariableName
Row Count Input 1
Row Count Output 1
RFS - Read Current Upload Data
AccessMode
FileName
FileNameVariable
Raw File Source Output
sql_handle
statement_start_offset
statement_end_offset
plan_handle
collection_time
row_id
session_id
request_id
exec_context_id
blocking_session_id
is_blocking
blocking_exec_context_id
scheduler_id
database_name
user_id
task_state
request_status
session_status
executing_managed_code
login_time
is_user_process
host_name
program_name
login_name
wait_type
last_wait_type
wait_duration_ms
wait_resource
resource_description
transaction_id
open_transaction_count
transaction_isolation_level
request_cpu_time
request_logical_reads
request_reads
request_writes
request_total_elapsed_time
request_start_time
memory_usage
session_cpu_time
session_reads
session_writes
session_logical_reads
session_total_scheduled_time
session_total_elapsed_time
session_last_request_start_time
session_last_request_end_time
open_resultsets
session_row_count
prev_error
pending_io_count
command
sql_handle
statement_start_offset
statement_end_offset
plan_handle
collection_time
row_id
session_id
request_id
exec_context_id
blocking_session_id
is_blocking
blocking_exec_context_id
scheduler_id
database_name
user_id
task_state
request_status
session_status
executing_managed_code
login_time
is_user_process
host_name
program_name
login_name
wait_type
last_wait_type
wait_duration_ms
wait_resource
resource_description
transaction_id
open_transaction_count
transaction_isolation_level
request_cpu_time
request_logical_reads
request_reads
request_writes
request_total_elapsed_time
request_start_time
memory_usage
session_cpu_time
session_reads
session_writes
session_logical_reads
session_total_scheduled_time
session_total_elapsed_time
session_last_request_start_time
session_last_request_end_time
open_resultsets
session_row_count
prev_error
pending_io_count
command
BufferSizeTuning
PipelineBufferLeak
PipelineComponentTime
PipelineExecutionPlan
PipelineExecutionTrees
PipelineInitialization
Derived Column Output
Raw File Source Output
Row Count Output 1
CurrentCollectionCacheFileName
RowCount
CacheDirectory
CacheWindow
CollectionCacheFileName
CollectionCacheFileNameOutput
CollectionCacheFilePrefixPattern
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
InterestingQueries_HighCpuUsage
InterestingQueries_HighIoCount
InterestingQueries_HighMemoryUsage
InterestingQueries_HighTransactionCount
InterestingQueries_LargeResultset
InterestingQueries_LongRunningRequest
InterestingQueries_LongWaitingRequest
InterestingQueriesCount
InterestingQueriesLastSnapshotFileName
InterestingQueriesLastSnapshotFileNameOutput
InterestingQueriesSnapshotFileNamePrefixPattern
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
SnapshotId
SnapshotQueryStatsQuery
SourceId
TargetConnectionString
TopThreshold
FST - Delete uploaded cache file
FileSystemOperation
CurrentCollectionCacheFileName
RowCount
CacheDirectory
CacheWindow
CollectionCacheFileName
CollectionCacheFileNameOutput
CollectionCacheFilePrefixPattern
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
InterestingQueries_HighCpuUsage
InterestingQueries_HighIoCount
InterestingQueries_HighMemoryUsage
InterestingQueries_HighTransactionCount
InterestingQueries_LargeResultset
InterestingQueries_LongRunningRequest
InterestingQueries_LongWaitingRequest
InterestingQueriesCount
InterestingQueriesLastSnapshotFileName
InterestingQueriesLastSnapshotFileNameOutput
InterestingQueriesSnapshotFileNamePrefixPattern
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
SnapshotId
SnapshotQueryStatsQuery
SourceId
TargetConnectionString
TopThreshold
SQL - Log Package Iteration
ExecuteSQLExecutingQuery
CurrentCollectionCacheFileName
RowCount
CacheDirectory
CacheWindow
CollectionCacheFileName
CollectionCacheFileNameOutput
CollectionCacheFilePrefixPattern
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
InterestingQueries_HighCpuUsage
InterestingQueries_HighIoCount
InterestingQueries_HighMemoryUsage
InterestingQueries_HighTransactionCount
InterestingQueries_LargeResultset
InterestingQueries_LongRunningRequest
InterestingQueries_LongWaitingRequest
InterestingQueriesCount
InterestingQueriesLastSnapshotFileName
InterestingQueriesLastSnapshotFileNameOutput
InterestingQueriesSnapshotFileNamePrefixPattern
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
SnapshotId
SnapshotQueryStatsQuery
SourceId
TargetConnectionString
TopThreshold
SQL - Log Package Stats
ExecuteSQLExecutingQuery
CurrentCollectionCacheFileName
RowCount
CacheDirectory
CacheWindow
CollectionCacheFileName
CollectionCacheFileNameOutput
CollectionCacheFilePrefixPattern
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
InterestingQueries_HighCpuUsage
InterestingQueries_HighIoCount
InterestingQueries_HighMemoryUsage
InterestingQueries_HighTransactionCount
InterestingQueries_LargeResultset
InterestingQueries_LongRunningRequest
InterestingQueries_LongWaitingRequest
InterestingQueriesCount
InterestingQueriesLastSnapshotFileName
InterestingQueriesLastSnapshotFileNameOutput
InterestingQueriesSnapshotFileNamePrefixPattern
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
SnapshotId
SnapshotQueryStatsQuery
SourceId
TargetConnectionString
TopThreshold
{BB52AFAE-60A1-42A7-9C13-52B21293D219}
Directory
FileSpec
Directory
FileSpec
Constraint
Constraint 1
Constraint 2
CurrentCollectionCacheFileName
RowCount
CacheDirectory
CacheWindow
CollectionCacheFileName
CollectionCacheFileNameOutput
CollectionCacheFilePrefixPattern
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
InterestingQueries_HighCpuUsage
InterestingQueries_HighIoCount
InterestingQueries_HighMemoryUsage
InterestingQueries_HighTransactionCount
InterestingQueries_LargeResultset
InterestingQueries_LongRunningRequest
InterestingQueries_LongWaitingRequest
InterestingQueriesCount
InterestingQueriesLastSnapshotFileName
InterestingQueriesLastSnapshotFileNameOutput
InterestingQueriesSnapshotFileNamePrefixPattern
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
SnapshotId
SnapshotQueryStatsQuery
SourceId
TargetConnectionString
TopThreshold
SEQ - Capture and analyze query statistics and query plan and text
DFT - Create Interesting Queries Last Snapshot
DC - Add the SnapshotId Column
Derived Column Input
Derived Column Output
snapshot_id
Expression
FriendlyExpression
Derived Column Error Output
ErrorCode
ErrorColumn
OLE DB Source
CommandTimeout
OpenRowset
OpenRowsetVariable
SqlCommand
SqlCommandVariable
DefaultCodePage
AlwaysUseDefaultCodePage
AccessMode
ParameterMapping
OLE DB Source Output
sql_handle
statement_start_offset
statement_end_offset
plan_generation_num
plan_handle
creation_time
last_execution_time
execution_count
total_worker_time
min_worker_time
max_worker_time
total_physical_reads
min_physical_reads
max_physical_reads
total_logical_writes
min_logical_writes
max_logical_writes
total_logical_reads
min_logical_reads
max_logical_reads
total_clr_time
min_clr_time
max_clr_time
total_elapsed_time
min_elapsed_time
max_elapsed_time
collection_time
sql_handle
statement_start_offset
statement_end_offset
plan_generation_num
plan_handle
creation_time
last_execution_time
execution_count
total_worker_time
min_worker_time
max_worker_time
total_physical_reads
min_physical_reads
max_physical_reads
total_logical_writes
min_logical_writes
max_logical_writes
total_logical_reads
min_logical_reads
max_logical_reads
total_clr_time
min_clr_time
max_clr_time
total_elapsed_time
min_elapsed_time
max_elapsed_time
collection_time
OLE DB Source Error Output
sql_handle
statement_start_offset
statement_end_offset
plan_generation_num
plan_handle
creation_time
last_execution_time
execution_count
total_worker_time
min_worker_time
max_worker_time
total_physical_reads
min_physical_reads
max_physical_reads
total_logical_writes
min_logical_writes
max_logical_writes
total_logical_reads
min_logical_reads
max_logical_reads
total_clr_time
min_clr_time
max_clr_time
total_elapsed_time
min_elapsed_time
max_elapsed_time
collection_time
ErrorCode
ErrorColumn
OleDbConnection
RC - Row count from dm_exec_query_stats
VariableName
Row Count Input 1
Row Count Output 1
RFD - Write Last Snapshot
AccessMode
FileName
FileNameVariable
WriteOption
Raw File Destination Input
sql_handle
statement_start_offset
statement_end_offset
plan_generation_num
plan_handle
creation_time
last_execution_time
execution_count
total_worker_time
total_physical_reads
total_logical_writes
total_logical_reads
total_clr_time
total_elapsed_time
max_worker_time
min_worker_time
min_physical_reads
max_physical_reads
min_logical_writes
max_logical_writes
min_logical_reads
max_logical_reads
min_clr_time
max_clr_time
min_elapsed_time
max_elapsed_time
snapshot_id
collection_time
BufferSizeTuning
PipelineBufferLeak
PipelineComponentTime
PipelineExecutionPlan
PipelineExecutionTrees
PipelineInitialization
Derived Column Output
OLE DB Source Output
Row Count Output 1
InterestingQueriesRowCountIn
InterestingQueriesRowCountOut
SqlPlanRowCountError
SqlPlanRowCountIn
SqlPlanRowCountOut
SqlPlanUpdateRowCountError
SqlPlanUpdateRowCountIn
SqlPlanUpdateRowCountOut
SqlTextRowCountError
SqlTextRowCountIn
SqlTextRowCountOut
SqlTextUpdateRowCountError
SqlTextUpdateRowCountIn
SqlTextUpdateRowCountOut
CacheDirectory
CacheWindow
CollectionCacheFileName
CollectionCacheFileNameOutput
CollectionCacheFilePrefixPattern
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
InterestingQueries_HighCpuUsage
InterestingQueries_HighIoCount
InterestingQueries_HighMemoryUsage
InterestingQueries_HighTransactionCount
InterestingQueries_LargeResultset
InterestingQueries_LongRunningRequest
InterestingQueries_LongWaitingRequest
InterestingQueriesCount
InterestingQueriesLastSnapshotFileName
InterestingQueriesLastSnapshotFileNameOutput
InterestingQueriesSnapshotFileNamePrefixPattern
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
SnapshotId
SnapshotQueryStatsQuery
SourceId
TargetConnectionString
TopThreshold
DFT - Create Interesting Queries Upload Batch
DRC - Add SnapshotId column to current snapshot
Derived Column Input
Derived Column Output
snapshot_id
Expression
FriendlyExpression
Derived Column Error Output
ErrorCode
ErrorColumn
DRC - Calculate delta value between last snapshot and current snapshot for every metric
Derived Column Input
old_total_worker_time
old_total_physical_reads
old_total_logical_writes
old_total_logical_reads
old_total_clr_time
old_total_elapsed_time
total_worker_time
total_physical_reads
total_logical_writes
total_logical_reads
total_clr_time
total_elapsed_time
execution_count
old_execution_count
Derived Column Output
snapshot_worker_time
Expression
FriendlyExpression
snapshot_physical_reads
Expression
FriendlyExpression
snapshot_logical_reads
Expression
FriendlyExpression
snapshot_logical_writes
Expression
FriendlyExpression
snapshot_clr_time
Expression
FriendlyExpression
snapshot_elapsed_time
Expression
FriendlyExpression
snapshot_execution_count
Expression
FriendlyExpression
Derived Column Error Output
ErrorCode
ErrorColumn
DRV - Add plan_generation_num column
Derived Column Input
Derived Column Output
plan_generation_num
Expression
FriendlyExpression
creation_time
Expression
FriendlyExpression
Derived Column Error Output
ErrorCode
ErrorColumn
DRV - Add source_id (1)
Derived Column Input
Derived Column Output
source_id
Expression
FriendlyExpression
Derived Column Error Output
ErrorCode
ErrorColumn
DRV - Add source_id (2)
Derived Column Input
Derived Column Output
source_id
Expression
FriendlyExpression
Derived Column Error Output
ErrorCode
ErrorColumn
MLTCST - split current snapshot
Multicast Input 1
Multicast Output 3
Multicast Output 2
Multicast Output 1
Multicast Output 4
MLTCST - Split interesting queries
Multicast Input 1
Multicast Output 2
Multicast Output 3
Multicast Output 1
MLTCST - split last snapshot
Multicast Input 1
Multicast Output 1
Multicast Output 2
Multicast Output 3
MLTCST - Split to upload sql_handle and plan_handle
Multicast Input 1
Multicast Output 4
Multicast Output 2
Multicast Output 1
MRG - Append current stats on interesting queries
JoinType
NumKeyColumns
TreatNullsAsEqual
MaxBuffersPerInput
Merge Join Left Input
Top SQL Handle
Top Plan Handle
Merge Join Right Input
sql_handle
plan_handle
statement_start_offset
statement_end_offset
plan_generation_num
creation_time
last_execution_time
execution_count
total_worker_time
total_physical_reads
total_logical_writes
total_logical_reads
total_clr_time
total_elapsed_time
max_worker_time
min_worker_time
min_physical_reads
max_physical_reads
min_logical_writes
max_logical_writes
min_logical_reads
max_logical_reads
min_clr_time
max_clr_time
min_elapsed_time
max_elapsed_time
collection_time
snapshot_id
Merge Join Output
statement_start_offset
InputColumnID
statement_end_offset
InputColumnID
plan_generation_num
InputColumnID
creation_time
InputColumnID
last_execution_time
InputColumnID
execution_count
InputColumnID
total_worker_time
InputColumnID
total_physical_reads
InputColumnID
total_logical_writes
InputColumnID
total_logical_reads
InputColumnID
total_clr_time
InputColumnID
total_elapsed_time
InputColumnID
max_worker_time
InputColumnID
min_worker_time
InputColumnID
min_physical_reads
InputColumnID
max_physical_reads
InputColumnID
min_logical_writes
InputColumnID
max_logical_writes
InputColumnID
min_logical_reads
InputColumnID
max_logical_reads
InputColumnID
min_clr_time
InputColumnID
max_clr_time
InputColumnID
min_elapsed_time
InputColumnID
max_elapsed_time
InputColumnID
collection_time
InputColumnID
sql_handle
InputColumnID
plan_handle
InputColumnID
snapshot_id
InputColumnID
MRG - Append last stats on interesting queries
JoinType
NumKeyColumns
TreatNullsAsEqual
MaxBuffersPerInput
Merge Join Left Input
statement_start_offset
statement_end_offset
plan_generation_num
sql_handle
plan_handle
creation_time
last_execution_time
execution_count
total_worker_time
total_physical_reads
total_logical_writes
total_logical_reads
total_clr_time
total_elapsed_time
max_worker_time
min_worker_time
min_physical_reads
max_physical_reads
min_logical_writes
max_logical_writes
min_logical_reads
max_logical_reads
min_clr_time
max_clr_time
min_elapsed_time
max_elapsed_time
collection_time
snapshot_id
Merge Join Right Input
statement_start_offset
statement_end_offset
plan_generation_num
sql_handle
plan_handle
total_worker_time
total_physical_reads
total_logical_writes
total_logical_reads
total_clr_time
total_elapsed_time
execution_count
Merge Join Output
statement_start_offset
InputColumnID
statement_end_offset
InputColumnID
plan_generation_num
InputColumnID
creation_time
InputColumnID
last_execution_time
InputColumnID
execution_count
InputColumnID
total_worker_time
InputColumnID
total_physical_reads
InputColumnID
total_logical_writes
InputColumnID
total_logical_reads
InputColumnID
total_clr_time
InputColumnID
total_elapsed_time
InputColumnID
max_worker_time
InputColumnID
min_worker_time
InputColumnID
min_physical_reads
InputColumnID
max_physical_reads
InputColumnID
min_logical_writes
InputColumnID
max_logical_writes
InputColumnID
min_logical_reads
InputColumnID
max_logical_reads
InputColumnID
min_clr_time
InputColumnID
max_clr_time
InputColumnID
min_elapsed_time
InputColumnID
max_elapsed_time
InputColumnID
collection_time
InputColumnID
sql_handle
InputColumnID
plan_handle
InputColumnID
snapshot_id
InputColumnID
old_total_worker_time
InputColumnID
old_total_physical_reads
InputColumnID
old_total_logical_writes
InputColumnID
old_total_logical_reads
InputColumnID
old_total_clr_time
InputColumnID
old_total_elapsed_time
InputColumnID
old_execution_count
InputColumnID
ODD - Save statistics for interesting queries
CommandTimeout
OpenRowset
OpenRowsetVariable
SqlCommand
DefaultCodePage
AlwaysUseDefaultCodePage
AccessMode
FastLoadKeepIdentity
FastLoadKeepNulls
FastLoadOptions
FastLoadMaxInsertCommitSize
OLE DB Destination Input
sql_handle
statement_start_offset
statement_end_offset
plan_generation_num
plan_handle
creation_time
last_execution_time
execution_count
total_worker_time
snapshot_worker_time
min_worker_time
max_worker_time
total_physical_reads
snapshot_physical_reads
min_physical_reads
max_physical_reads
total_logical_writes
snapshot_logical_writes
min_logical_writes
max_logical_writes
total_logical_reads
snapshot_logical_reads
min_logical_reads
max_logical_reads
total_clr_time
snapshot_clr_time
min_clr_time
max_clr_time
total_elapsed_time
snapshot_elapsed_time
min_elapsed_time
max_elapsed_time
collection_time
snapshot_id
snapshot_execution_count
statement_start_offset
statement_end_offset
creation_time
plan_generation_num
last_execution_time
execution_count
total_worker_time
total_physical_reads
total_logical_writes
total_logical_reads
total_clr_time
total_elapsed_time
max_worker_time
min_worker_time
min_physical_reads
max_physical_reads
min_logical_writes
max_logical_writes
min_logical_reads
max_logical_reads
min_clr_time
max_clr_time
min_elapsed_time
max_elapsed_time
collection_time
sql_handle
plan_handle
snapshot_id
snapshot_worker_time
snapshot_physical_reads
snapshot_logical_reads
snapshot_logical_writes
snapshot_clr_time
snapshot_elapsed_time
snapshot_execution_count
OLE DB Destination Error Output
ErrorCode
ErrorColumn
OleDbConnection
ODD - Upload interesting plan handles
CommandTimeout
OpenRowset
OpenRowsetVariable
SqlCommand
DefaultCodePage
AlwaysUseDefaultCodePage
AccessMode
FastLoadKeepIdentity
FastLoadKeepNulls
FastLoadOptions
FastLoadMaxInsertCommitSize
OLE DB Destination Input
sql_handle
plan_handle
statement_start_offset
statement_end_offset
creation_time
database_id
object_id
object_name
query_plan
source_id
plan_generation_num
sql_handle
plan_handle
statement_start_offset
statement_end_offset
creation_time
source_id
plan_generation_num
OLE DB Destination Error Output
ErrorCode
ErrorColumn
OleDbConnection
ODD - Upload interesting sql handles
CommandTimeout
OpenRowset
OpenRowsetVariable
SqlCommand
DefaultCodePage
AlwaysUseDefaultCodePage
AccessMode
FastLoadKeepIdentity
FastLoadKeepNulls
FastLoadOptions
FastLoadMaxInsertCommitSize
OLE DB Destination Input
sql_handle
database_id
object_id
object_name
sql_text
source_id
sql_handle
source_id
OLE DB Destination Error Output
ErrorCode
ErrorColumn
OleDbConnection
ODS - Get current snapshot of dm_exec_query_stats
CommandTimeout
OpenRowset
OpenRowsetVariable
SqlCommand
SqlCommandVariable
DefaultCodePage
AlwaysUseDefaultCodePage
AccessMode
ParameterMapping
OLE DB Source Output
sql_handle
statement_start_offset
statement_end_offset
plan_generation_num
plan_handle
creation_time
last_execution_time
execution_count
total_worker_time
min_worker_time
max_worker_time
total_physical_reads
min_physical_reads
max_physical_reads
total_logical_writes
min_logical_writes
max_logical_writes
total_logical_reads
min_logical_reads
max_logical_reads
total_clr_time
min_clr_time
max_clr_time
total_elapsed_time
min_elapsed_time
max_elapsed_time
collection_time
sql_handle
statement_start_offset
statement_end_offset
plan_generation_num
plan_handle
creation_time
last_execution_time
execution_count
total_worker_time
min_worker_time
max_worker_time
total_physical_reads
min_physical_reads
max_physical_reads
total_logical_writes
min_logical_writes
max_logical_writes
total_logical_reads
min_logical_reads
max_logical_reads
total_clr_time
min_clr_time
max_clr_time
total_elapsed_time
min_elapsed_time
max_elapsed_time
collection_time
OLE DB Source Error Output
sql_handle
statement_start_offset
statement_end_offset
plan_generation_num
plan_handle
creation_time
last_execution_time
execution_count
total_worker_time
min_worker_time
max_worker_time
total_physical_reads
min_physical_reads
max_physical_reads
total_logical_writes
min_logical_writes
max_logical_writes
total_logical_reads
min_logical_reads
max_logical_reads
total_clr_time
min_clr_time
max_clr_time
total_elapsed_time
min_elapsed_time
max_elapsed_time
collection_time
ErrorCode
ErrorColumn
OleDbConnection
RC - Number of interesting plan handles
VariableName
Row Count Input 1
Row Count Output 1
RC - Number of interesting sql handles
VariableName
Row Count Input 1
Row Count Output 1
RC - Number of not inserted plan handles
VariableName
Row Count Input 1
Row Count Output 1
RC - Number of not inserted sql handles
VariableName
Row Count Input 1
Row Count Output 1
RC - Row count after TopN queries
VariableName
Row Count Input 1
Row Count Output 1
RC - Row count from dm_exec_query_stats
VariableName
Row Count Input 1
Row Count Output 1
RFD - Save current snapshot in temp file
AccessMode
FileName
FileNameVariable
WriteOption
Raw File Destination Input
sql_handle
statement_start_offset
statement_end_offset
plan_generation_num
plan_handle
creation_time
last_execution_time
execution_count
total_worker_time
total_physical_reads
total_logical_writes
total_logical_reads
total_clr_time
total_elapsed_time
max_worker_time
min_worker_time
min_physical_reads
max_physical_reads
min_logical_writes
max_logical_writes
min_logical_reads
max_logical_reads
min_clr_time
max_clr_time
min_elapsed_time
max_elapsed_time
snapshot_id
collection_time
RFS - Read current cache with dm_exec_requests
AccessMode
FileName
FileNameVariable
Raw File Source Output
statement_start_offset
statement_end_offset
collection_time
sql_handle
plan_handle
row_id
session_id
request_id
exec_context_id
blocking_session_id
is_blocking
blocking_exec_context_id
scheduler_id
database_name
user_id
task_state
request_status
session_status
executing_managed_code
login_time
is_user_process
host_name
program_name
login_name
wait_type
last_wait_type
wait_duration_ms
wait_resource
resource_description
transaction_id
open_transaction_count
transaction_isolation_level
request_cpu_time
request_logical_reads
request_reads
request_writes
request_total_elapsed_time
request_start_time
memory_usage
session_cpu_time
session_reads
session_writes
session_logical_reads
session_total_scheduled_time
session_total_elapsed_time
session_last_request_start_time
session_last_request_end_time
open_resultsets
session_row_count
prev_error
pending_io_count
command
statement_start_offset
statement_end_offset
collection_time
sql_handle
plan_handle
row_id
session_id
request_id
exec_context_id
blocking_session_id
is_blocking
blocking_exec_context_id
scheduler_id
database_name
user_id
task_state
request_status
session_status
executing_managed_code
login_time
is_user_process
host_name
program_name
login_name
wait_type
last_wait_type
wait_duration_ms
wait_resource
resource_description
transaction_id
open_transaction_count
transaction_isolation_level
request_cpu_time
request_logical_reads
request_reads
request_writes
request_total_elapsed_time
request_start_time
memory_usage
session_cpu_time
session_reads
session_writes
session_logical_reads
session_total_scheduled_time
session_total_elapsed_time
session_last_request_start_time
session_last_request_end_time
open_resultsets
session_row_count
prev_error
pending_io_count
command
RFS - Read last snapshot of dm_exec_query_stats
AccessMode
FileName
FileNameVariable
Raw File Source Output
sql_handle
statement_start_offset
statement_end_offset
plan_generation_num
plan_handle
creation_time
last_execution_time
execution_count
total_worker_time
total_physical_reads
total_logical_writes
total_logical_reads
total_clr_time
total_elapsed_time
max_worker_time
min_worker_time
min_physical_reads
max_physical_reads
min_logical_writes
max_logical_writes
min_logical_reads
max_logical_reads
min_clr_time
max_clr_time
min_elapsed_time
max_elapsed_time
snapshot_id
collection_time
statement_start_offset
statement_end_offset
plan_generation_num
creation_time
last_execution_time
execution_count
total_worker_time
total_physical_reads
total_logical_writes
total_logical_reads
total_clr_time
total_elapsed_time
max_worker_time
min_worker_time
min_physical_reads
max_physical_reads
min_logical_writes
max_logical_writes
min_logical_reads
max_logical_reads
min_clr_time
max_clr_time
min_elapsed_time
max_elapsed_time
snapshot_id
collection_time
sql_handle
plan_handle
SPLT - Identify interesting running requests
Conditional Split Input
blocking_session_id
is_blocking
wait_duration_ms
open_transaction_count
request_total_elapsed_time
request_cpu_time
memory_usage
session_row_count
pending_io_count
Interesting Requests
Expression
FriendlyExpression
EvaluationOrder
Conditional Split Default Output
IsDefaultOut
Conditional Split Error Output
ErrorCode
ErrorColumn
SRT - Add statement_start_offset, statement_end_offset and creation_time to the sort order
EliminateDuplicates
MaximumThreads
Sort Input
statement_start_offset
NewComparisonFlags
NewSortKeyPosition
statement_end_offset
NewComparisonFlags
NewSortKeyPosition
plan_generation_num
NewComparisonFlags
NewSortKeyPosition
creation_time
NewComparisonFlags
NewSortKeyPosition
last_execution_time
NewComparisonFlags
NewSortKeyPosition
execution_count
NewComparisonFlags
NewSortKeyPosition
total_worker_time
NewComparisonFlags
NewSortKeyPosition
total_physical_reads
NewComparisonFlags
NewSortKeyPosition
total_logical_writes
NewComparisonFlags
NewSortKeyPosition
total_logical_reads
NewComparisonFlags
NewSortKeyPosition
total_clr_time
NewComparisonFlags
NewSortKeyPosition
total_elapsed_time
NewComparisonFlags
NewSortKeyPosition
max_worker_time
NewComparisonFlags
NewSortKeyPosition
min_worker_time
NewComparisonFlags
NewSortKeyPosition
min_physical_reads
NewComparisonFlags
NewSortKeyPosition
max_physical_reads
NewComparisonFlags
NewSortKeyPosition
min_logical_writes
NewComparisonFlags
NewSortKeyPosition
max_logical_writes
NewComparisonFlags
NewSortKeyPosition
min_logical_reads
NewComparisonFlags
NewSortKeyPosition
max_logical_reads
NewComparisonFlags
NewSortKeyPosition
min_clr_time
NewComparisonFlags
NewSortKeyPosition
max_clr_time
NewComparisonFlags
NewSortKeyPosition
min_elapsed_time
NewComparisonFlags
NewSortKeyPosition
max_elapsed_time
NewComparisonFlags
NewSortKeyPosition
collection_time
NewComparisonFlags
NewSortKeyPosition
sql_handle
NewComparisonFlags
NewSortKeyPosition
plan_handle
NewComparisonFlags
NewSortKeyPosition
snapshot_id
NewComparisonFlags
NewSortKeyPosition
Sort Output
statement_start_offset
SortColumnId
statement_end_offset
SortColumnId
plan_generation_num
SortColumnId
creation_time
SortColumnId
last_execution_time
SortColumnId
execution_count
SortColumnId
total_worker_time
SortColumnId
total_physical_reads
SortColumnId
total_logical_writes
SortColumnId
total_logical_reads
SortColumnId
total_clr_time
SortColumnId
total_elapsed_time
SortColumnId
max_worker_time
SortColumnId
min_worker_time
SortColumnId
min_physical_reads
SortColumnId
max_physical_reads
SortColumnId
min_logical_writes
SortColumnId
max_logical_writes
SortColumnId
min_logical_reads
SortColumnId
max_logical_reads
SortColumnId
min_clr_time
SortColumnId
max_clr_time
SortColumnId
min_elapsed_time
SortColumnId
max_elapsed_time
SortColumnId
collection_time
SortColumnId
sql_handle
SortColumnId
plan_handle
SortColumnId
snapshot_id
SortColumnId
SRT - Find unique sql_handle and plan_handle combinations
EliminateDuplicates
MaximumThreads
Sort Input
sql_handle
NewComparisonFlags
NewSortKeyPosition
plan_handle
NewComparisonFlags
NewSortKeyPosition
statement_start_offset
NewComparisonFlags
NewSortKeyPosition
statement_end_offset
NewComparisonFlags
NewSortKeyPosition
creation_time
NewComparisonFlags
NewSortKeyPosition
plan_generation_num
NewComparisonFlags
NewSortKeyPosition
Sort Output
sql_handle
SortColumnId
plan_handle
SortColumnId
statement_start_offset
SortColumnId
statement_end_offset
SortColumnId
creation_time
SortColumnId
plan_generation_num
SortColumnId
SRT - Find unique sql_handle values
EliminateDuplicates
MaximumThreads
Sort Input
sql_handle
NewComparisonFlags
NewSortKeyPosition
Sort Output
sql_handle
SortColumnId
SRT - Sort columns by sql_handle, plan_handle
EliminateDuplicates
MaximumThreads
Sort Input
Top Reason
NewComparisonFlags
NewSortKeyPosition
Top SQL Handle
NewComparisonFlags
NewSortKeyPosition
Top Plan Handle
NewComparisonFlags
NewSortKeyPosition
Sort Output
Top Reason
SortColumnId
Top SQL Handle
SortColumnId
Top Plan Handle
SortColumnId
TPQ - Analyze Interesting Queries
TxTopQueries Only Input
snapshot_id
sql_handle
plan_handle
plan_generation_num
execution_count
total_worker_time
min_worker_time
max_worker_time
total_physical_reads
min_physical_reads
max_physical_reads
total_logical_writes
min_logical_writes
max_logical_writes
total_logical_reads
min_logical_reads
max_logical_reads
total_clr_time
min_clr_time
max_clr_time
total_elapsed_time
min_elapsed_time
max_elapsed_time
TxTopQueries Only Output
Top Reason
Top SQL Handle
Top Plan Handle
UNION - Combine interesting requests and interesting stats
Union All Input 1
old_total_worker_time
OutputColumnLineageID
old_total_physical_reads
OutputColumnLineageID
old_total_logical_writes
OutputColumnLineageID
old_total_logical_reads
OutputColumnLineageID
old_total_clr_time
OutputColumnLineageID
old_total_elapsed_time
OutputColumnLineageID
statement_start_offset
OutputColumnLineageID
statement_end_offset
OutputColumnLineageID
creation_time
OutputColumnLineageID
plan_generation_num
OutputColumnLineageID
last_execution_time
OutputColumnLineageID
execution_count
OutputColumnLineageID
total_worker_time
OutputColumnLineageID
total_physical_reads
OutputColumnLineageID
total_logical_writes
OutputColumnLineageID
total_logical_reads
OutputColumnLineageID
total_clr_time
OutputColumnLineageID
total_elapsed_time
OutputColumnLineageID
max_worker_time
OutputColumnLineageID
min_worker_time
OutputColumnLineageID
min_physical_reads
OutputColumnLineageID
max_physical_reads
OutputColumnLineageID
min_logical_writes
OutputColumnLineageID
max_logical_writes
OutputColumnLineageID
min_logical_reads
OutputColumnLineageID
max_logical_reads
OutputColumnLineageID
min_clr_time
OutputColumnLineageID
max_clr_time
OutputColumnLineageID
min_elapsed_time
OutputColumnLineageID
max_elapsed_time
OutputColumnLineageID
sql_handle
OutputColumnLineageID
plan_handle
OutputColumnLineageID
snapshot_id
OutputColumnLineageID
snapshot_worker_time
OutputColumnLineageID
snapshot_physical_reads
OutputColumnLineageID
snapshot_logical_reads
OutputColumnLineageID
snapshot_logical_writes
OutputColumnLineageID
snapshot_clr_time
OutputColumnLineageID
snapshot_elapsed_time
OutputColumnLineageID
collection_time
OutputColumnLineageID
snapshot_execution_count
OutputColumnLineageID
old_execution_count
OutputColumnLineageID
Union All Input 3
statement_start_offset
OutputColumnLineageID
statement_end_offset
OutputColumnLineageID
collection_time
OutputColumnLineageID
sql_handle
OutputColumnLineageID
plan_handle
OutputColumnLineageID
plan_generation_num
OutputColumnLineageID
creation_time
OutputColumnLineageID
Union All Input 2
Union All Output 1
old_total_worker_time
old_total_physical_reads
old_total_logical_writes
old_total_logical_reads
old_total_clr_time
old_total_elapsed_time
statement_start_offset
statement_end_offset
creation_time
plan_generation_num
last_execution_time
execution_count
total_worker_time
total_physical_reads
total_logical_writes
total_logical_reads
total_clr_time
total_elapsed_time
max_worker_time
min_worker_time
min_physical_reads
max_physical_reads
min_logical_writes
max_logical_writes
min_logical_reads
max_logical_reads
min_clr_time
max_clr_time
min_elapsed_time
max_elapsed_time
collection_time
sql_handle
plan_handle
snapshot_id
snapshot_worker_time
snapshot_physical_reads
snapshot_logical_reads
snapshot_logical_writes
snapshot_clr_time
snapshot_elapsed_time
snapshot_execution_count
old_execution_count
UNION - Combine last and current snapshots for TopN processing
Union All Input 2
snapshot_id
OutputColumnLineageID
statement_start_offset
OutputColumnLineageID
statement_end_offset
OutputColumnLineageID
plan_generation_num
OutputColumnLineageID
creation_time
OutputColumnLineageID
last_execution_time
OutputColumnLineageID
execution_count
OutputColumnLineageID
total_worker_time
OutputColumnLineageID
total_physical_reads
OutputColumnLineageID
total_logical_writes
OutputColumnLineageID
total_logical_reads
OutputColumnLineageID
total_clr_time
OutputColumnLineageID
total_elapsed_time
OutputColumnLineageID
max_worker_time
OutputColumnLineageID
min_worker_time
OutputColumnLineageID
min_physical_reads
OutputColumnLineageID
max_physical_reads
OutputColumnLineageID
min_logical_writes
OutputColumnLineageID
max_logical_writes
OutputColumnLineageID
min_logical_reads
OutputColumnLineageID
max_logical_reads
OutputColumnLineageID
min_clr_time
OutputColumnLineageID
max_clr_time
OutputColumnLineageID
min_elapsed_time
OutputColumnLineageID
max_elapsed_time
OutputColumnLineageID
collection_time
OutputColumnLineageID
sql_handle
OutputColumnLineageID
plan_handle
OutputColumnLineageID
Union All Input 3
statement_start_offset
OutputColumnLineageID
statement_end_offset
OutputColumnLineageID
plan_generation_num
OutputColumnLineageID
creation_time
OutputColumnLineageID
last_execution_time
OutputColumnLineageID
execution_count
OutputColumnLineageID
total_worker_time
OutputColumnLineageID
total_physical_reads
OutputColumnLineageID
total_logical_writes
OutputColumnLineageID
total_logical_reads
OutputColumnLineageID
total_clr_time
OutputColumnLineageID
total_elapsed_time
OutputColumnLineageID
max_worker_time
OutputColumnLineageID
min_worker_time
OutputColumnLineageID
min_physical_reads
OutputColumnLineageID
max_physical_reads
OutputColumnLineageID
min_logical_writes
OutputColumnLineageID
max_logical_writes
OutputColumnLineageID
min_logical_reads
OutputColumnLineageID
max_logical_reads
OutputColumnLineageID
min_clr_time
OutputColumnLineageID
max_clr_time
OutputColumnLineageID
min_elapsed_time
OutputColumnLineageID
max_elapsed_time
OutputColumnLineageID
snapshot_id
OutputColumnLineageID
collection_time
OutputColumnLineageID
sql_handle
OutputColumnLineageID
plan_handle
OutputColumnLineageID
Union All Input 1
Union All Output 1
statement_start_offset
statement_end_offset
plan_generation_num
creation_time
last_execution_time
execution_count
total_worker_time
total_physical_reads
total_logical_writes
total_logical_reads
total_clr_time
total_elapsed_time
max_worker_time
min_worker_time
min_physical_reads
max_physical_reads
min_logical_writes
max_logical_writes
min_logical_reads
max_logical_reads
min_clr_time
max_clr_time
min_elapsed_time
max_elapsed_time
snapshot_id
collection_time
sql_handle
plan_handle
BufferSizeTuning
PipelineBufferLeak
PipelineComponentTime
PipelineExecutionPlan
PipelineExecutionTrees
PipelineInitialization
Calculate TopN stats
Calculate TopN stats
Derived Column Output
Derived Column Output
Derived Column Output
Derived Column Output
Derived Column Output
Interesting Requests
Merge Join Output
Merge Join Output
Multicast Output 2
Multicast Output 3
Multicast Output 4
OLE DB Destination Error Output
OLE DB Destination Error Output
OLE DB Source Output
Process TopN
Process TopN
Raw File Source Output
Raw File Source Output
Row Count Output 1
Row Count Output 1
Row Count Output 1
Row Count Output 1
Save
Save
Sort Output
Sort Output
Sort Output
Sort Output
TxTopQueries Only Output
Union All Output 1
Union All Output 1
NotableQueryPlan
NotableQueryText
InterestingQueriesRowCountIn
InterestingQueriesRowCountOut
SqlPlanRowCountError
SqlPlanRowCountIn
SqlPlanRowCountOut
SqlPlanUpdateRowCountError
SqlPlanUpdateRowCountIn
SqlPlanUpdateRowCountOut
SqlTextRowCountError
SqlTextRowCountIn
SqlTextRowCountOut
SqlTextUpdateRowCountError
SqlTextUpdateRowCountIn
SqlTextUpdateRowCountOut
CacheDirectory
CacheWindow
CollectionCacheFileName
CollectionCacheFileNameOutput
CollectionCacheFilePrefixPattern
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
InterestingQueries_HighCpuUsage
InterestingQueries_HighIoCount
InterestingQueries_HighMemoryUsage
InterestingQueries_HighTransactionCount
InterestingQueries_LargeResultset
InterestingQueries_LongRunningRequest
InterestingQueries_LongWaitingRequest
InterestingQueriesCount
InterestingQueriesLastSnapshotFileName
InterestingQueriesLastSnapshotFileNameOutput
InterestingQueriesSnapshotFileNamePrefixPattern
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
SnapshotId
SnapshotQueryStatsQuery
SourceId
TargetConnectionString
TopThreshold
DFT - Find and save plan text
LKUP - Look up query plans on target server
SqlCommand
SqlCommandParam
ConnectionType
CacheType
NoMatchBehavior
NoMatchCachePercentage
MaxMemoryUsage
MaxMemoryUsage64
ReferenceMetadataXml
ParameterMap
DefaultCodePage
TreatDuplicateKeysAsError
Lookup Input
statement_start_offset
JoinToReferenceColumn
CopyFromReferenceColumn
statement_end_offset
JoinToReferenceColumn
CopyFromReferenceColumn
plan_handle
JoinToReferenceColumn
CopyFromReferenceColumn
Lookup Match Output
database_id
CopyFromReferenceColumn
object_id
CopyFromReferenceColumn
object_name
CopyFromReferenceColumn
query_plan
CopyFromReferenceColumn
Lookup No Match Output
Lookup Error Output
ErrorCode
ErrorColumn
OleDbConnection
ODC - Save known plans to warehouse
CommandTimeout
SqlCommand
DefaultCodePage
OLE DB Command Input
@source_id
DBParamInfoFlags
@sql_handle
DBParamInfoFlags
@plan_handle
DBParamInfoFlags
@statement_start_offset
DBParamInfoFlags
@statement_end_offset
DBParamInfoFlags
@plan_generation_num
DBParamInfoFlags
@database_id
DBParamInfoFlags
@object_id
DBParamInfoFlags
@object_name
DBParamInfoFlags
@query_plan
DBParamInfoFlags
source_id
sql_handle
plan_handle
statement_start_offset
statement_end_offset
plan_generation_num
database_id
object_id
object_name
query_plan
OLE DB Command Output
OLE DB Command Error Output
ErrorCode
ErrorColumn
OleDbConnection
ODS - Get all plan handles without saved plan
CommandTimeout
OpenRowset
OpenRowsetVariable
SqlCommand
SqlCommandVariable
DefaultCodePage
AlwaysUseDefaultCodePage
AccessMode
ParameterMapping
OLE DB Source Output
source_id
sql_handle
plan_handle
statement_start_offset
statement_end_offset
plan_generation_num
source_id
sql_handle
plan_handle
statement_start_offset
statement_end_offset
plan_generation_num
OLE DB Source Error Output
source_id
sql_handle
plan_handle
statement_start_offset
statement_end_offset
plan_generation_num
ErrorCode
ErrorColumn
OleDbConnection
RC - Identified query plans count
VariableName
Row Count Input 1
Row Count Output 1
RC - Unidentified query plans count
VariableName
Row Count Input 1
Row Count Output 1
RC - Unknown query plans count
VariableName
Row Count Input 1
Row Count Output 1
BufferSizeTuning
PipelineBufferLeak
PipelineComponentTime
PipelineExecutionPlan
PipelineExecutionTrees
PipelineInitialization
Lookup Match Output
Lookup No Match Output
OLE DB Source Output
Row Count Output 1
Row Count Output 1
SourceSqlQuery
InterestingQueriesRowCountIn
InterestingQueriesRowCountOut
SqlPlanRowCountError
SqlPlanRowCountIn
SqlPlanRowCountOut
SqlPlanUpdateRowCountError
SqlPlanUpdateRowCountIn
SqlPlanUpdateRowCountOut
SqlTextRowCountError
SqlTextRowCountIn
SqlTextRowCountOut
SqlTextUpdateRowCountError
SqlTextUpdateRowCountIn
SqlTextUpdateRowCountOut
CacheDirectory
CacheWindow
CollectionCacheFileName
CollectionCacheFileNameOutput
CollectionCacheFilePrefixPattern
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
InterestingQueries_HighCpuUsage
InterestingQueries_HighIoCount
InterestingQueries_HighMemoryUsage
InterestingQueries_HighTransactionCount
InterestingQueries_LargeResultset
InterestingQueries_LongRunningRequest
InterestingQueries_LongWaitingRequest
InterestingQueriesCount
InterestingQueriesLastSnapshotFileName
InterestingQueriesLastSnapshotFileNameOutput
InterestingQueriesSnapshotFileNamePrefixPattern
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
SnapshotId
SnapshotQueryStatsQuery
SourceId
TargetConnectionString
TopThreshold
DFT - Find and save sql text
LKUP - Look up query text on target server
SqlCommand
SqlCommandParam
ConnectionType
CacheType
NoMatchBehavior
NoMatchCachePercentage
MaxMemoryUsage
MaxMemoryUsage64
ReferenceMetadataXml
ParameterMap
DefaultCodePage
TreatDuplicateKeysAsError
Lookup Input
sql_handle
JoinToReferenceColumn
CopyFromReferenceColumn
Lookup Match Output
database_id
CopyFromReferenceColumn
object_id
CopyFromReferenceColumn
object_name
CopyFromReferenceColumn
sql_text
CopyFromReferenceColumn
Lookup No Match Output
Lookup Error Output
ErrorCode
ErrorColumn
OleDbConnection
ODS - Get all sql handles without saved sql text
CommandTimeout
OpenRowset
OpenRowsetVariable
SqlCommand
SqlCommandVariable
DefaultCodePage
AlwaysUseDefaultCodePage
AccessMode
ParameterMapping
OLE DB Source Output
source_id
sql_handle
source_id
sql_handle
OLE DB Source Error Output
source_id
sql_handle
ErrorCode
ErrorColumn
OleDbConnection
ODS - Save query text to warehouse
CommandTimeout
SqlCommand
DefaultCodePage
OLE DB Command Input
@sql_handle
DBParamInfoFlags
@source_id
DBParamInfoFlags
@database_id
DBParamInfoFlags
@object_id
DBParamInfoFlags
@object_name
DBParamInfoFlags
@sql_text
DBParamInfoFlags
sql_handle
source_id
database_id
object_id
object_name
sql_text
OLE DB Command Output
OLE DB Command Error Output
ErrorCode
ErrorColumn
OleDbConnection
RC - Identified query text count
VariableName
Row Count Input 1
Row Count Output 1
RC - Unidentified query text count
VariableName
Row Count Input 1
Row Count Output 1
RC - Unknown query text count
VariableName
Row Count Input 1
Row Count Output 1
BufferSizeTuning
PipelineBufferLeak
PipelineComponentTime
PipelineExecutionPlan
PipelineExecutionTrees
PipelineInitialization
Lookup Match Output
Lookup No Match Output
OLE DB Source Output
Row Count Output 1
Row Count Output 1
SourceSqlQuery
InterestingQueriesRowCountIn
InterestingQueriesRowCountOut
SqlPlanRowCountError
SqlPlanRowCountIn
SqlPlanRowCountOut
SqlPlanUpdateRowCountError
SqlPlanUpdateRowCountIn
SqlPlanUpdateRowCountOut
SqlTextRowCountError
SqlTextRowCountIn
SqlTextRowCountOut
SqlTextUpdateRowCountError
SqlTextUpdateRowCountIn
SqlTextUpdateRowCountOut
CacheDirectory
CacheWindow
CollectionCacheFileName
CollectionCacheFileNameOutput
CollectionCacheFilePrefixPattern
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
InterestingQueries_HighCpuUsage
InterestingQueries_HighIoCount
InterestingQueries_HighMemoryUsage
InterestingQueries_HighTransactionCount
InterestingQueries_LargeResultset
InterestingQueries_LongRunningRequest
InterestingQueries_LongWaitingRequest
InterestingQueriesCount
InterestingQueriesLastSnapshotFileName
InterestingQueriesLastSnapshotFileNameOutput
InterestingQueriesSnapshotFileNamePrefixPattern
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
SnapshotId
SnapshotQueryStatsQuery
SourceId
TargetConnectionString
TopThreshold
FAT - Check Interesting Queries Last Snapshot exists
FilePath
InterestingQueriesRowCountIn
InterestingQueriesRowCountOut
SqlPlanRowCountError
SqlPlanRowCountIn
SqlPlanRowCountOut
SqlPlanUpdateRowCountError
SqlPlanUpdateRowCountIn
SqlPlanUpdateRowCountOut
SqlTextRowCountError
SqlTextRowCountIn
SqlTextRowCountOut
SqlTextUpdateRowCountError
SqlTextUpdateRowCountIn
SqlTextUpdateRowCountOut
CacheDirectory
CacheWindow
CollectionCacheFileName
CollectionCacheFileNameOutput
CollectionCacheFilePrefixPattern
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
InterestingQueries_HighCpuUsage
InterestingQueries_HighIoCount
InterestingQueries_HighMemoryUsage
InterestingQueries_HighTransactionCount
InterestingQueries_LargeResultset
InterestingQueries_LongRunningRequest
InterestingQueries_LongWaitingRequest
InterestingQueriesCount
InterestingQueriesLastSnapshotFileName
InterestingQueriesLastSnapshotFileNameOutput
InterestingQueriesSnapshotFileNamePrefixPattern
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
SnapshotId
SnapshotQueryStatsQuery
SourceId
TargetConnectionString
TopThreshold
FST - Rename Current Snapshot File as Last Snapshot File
FileSystemOperation
InterestingQueriesRowCountIn
InterestingQueriesRowCountOut
SqlPlanRowCountError
SqlPlanRowCountIn
SqlPlanRowCountOut
SqlPlanUpdateRowCountError
SqlPlanUpdateRowCountIn
SqlPlanUpdateRowCountOut
SqlTextRowCountError
SqlTextRowCountIn
SqlTextRowCountOut
SqlTextUpdateRowCountError
SqlTextUpdateRowCountIn
SqlTextUpdateRowCountOut
CacheDirectory
CacheWindow
CollectionCacheFileName
CollectionCacheFileNameOutput
CollectionCacheFilePrefixPattern
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
InterestingQueries_HighCpuUsage
InterestingQueries_HighIoCount
InterestingQueries_HighMemoryUsage
InterestingQueries_HighTransactionCount
InterestingQueries_LargeResultset
InterestingQueries_LongRunningRequest
InterestingQueries_LongWaitingRequest
InterestingQueriesCount
InterestingQueriesLastSnapshotFileName
InterestingQueriesLastSnapshotFileNameOutput
InterestingQueriesSnapshotFileNamePrefixPattern
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
SnapshotId
SnapshotQueryStatsQuery
SourceId
TargetConnectionString
TopThreshold
SQL - Log stats for Interesting Queries
ExecuteSQLExecutingQuery
InterestingQueriesRowCountIn
InterestingQueriesRowCountOut
SqlPlanRowCountError
SqlPlanRowCountIn
SqlPlanRowCountOut
SqlPlanUpdateRowCountError
SqlPlanUpdateRowCountIn
SqlPlanUpdateRowCountOut
SqlTextRowCountError
SqlTextRowCountIn
SqlTextRowCountOut
SqlTextUpdateRowCountError
SqlTextUpdateRowCountIn
SqlTextUpdateRowCountOut
CacheDirectory
CacheWindow
CollectionCacheFileName
CollectionCacheFileNameOutput
CollectionCacheFilePrefixPattern
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
InterestingQueries_HighCpuUsage
InterestingQueries_HighIoCount
InterestingQueries_HighMemoryUsage
InterestingQueries_HighTransactionCount
InterestingQueries_LargeResultset
InterestingQueries_LongRunningRequest
InterestingQueries_LongWaitingRequest
InterestingQueriesCount
InterestingQueriesLastSnapshotFileName
InterestingQueriesLastSnapshotFileNameOutput
InterestingQueriesSnapshotFileNamePrefixPattern
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
SnapshotId
SnapshotQueryStatsQuery
SourceId
TargetConnectionString
TopThreshold
SQL - Log stats for sql plan
ExecuteSQLExecutingQuery
InterestingQueriesRowCountIn
InterestingQueriesRowCountOut
SqlPlanRowCountError
SqlPlanRowCountIn
SqlPlanRowCountOut
SqlPlanUpdateRowCountError
SqlPlanUpdateRowCountIn
SqlPlanUpdateRowCountOut
SqlTextRowCountError
SqlTextRowCountIn
SqlTextRowCountOut
SqlTextUpdateRowCountError
SqlTextUpdateRowCountIn
SqlTextUpdateRowCountOut
CacheDirectory
CacheWindow
CollectionCacheFileName
CollectionCacheFileNameOutput
CollectionCacheFilePrefixPattern
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
InterestingQueries_HighCpuUsage
InterestingQueries_HighIoCount
InterestingQueries_HighMemoryUsage
InterestingQueries_HighTransactionCount
InterestingQueries_LargeResultset
InterestingQueries_LongRunningRequest
InterestingQueries_LongWaitingRequest
InterestingQueriesCount
InterestingQueriesLastSnapshotFileName
InterestingQueriesLastSnapshotFileNameOutput
InterestingQueriesSnapshotFileNamePrefixPattern
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
SnapshotId
SnapshotQueryStatsQuery
SourceId
TargetConnectionString
TopThreshold
SQL - Log stats for sql text
ExecuteSQLExecutingQuery
InterestingQueriesRowCountIn
InterestingQueriesRowCountOut
SqlPlanRowCountError
SqlPlanRowCountIn
SqlPlanRowCountOut
SqlPlanUpdateRowCountError
SqlPlanUpdateRowCountIn
SqlPlanUpdateRowCountOut
SqlTextRowCountError
SqlTextRowCountIn
SqlTextRowCountOut
SqlTextUpdateRowCountError
SqlTextUpdateRowCountIn
SqlTextUpdateRowCountOut
CacheDirectory
CacheWindow
CollectionCacheFileName
CollectionCacheFileNameOutput
CollectionCacheFilePrefixPattern
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
InterestingQueries_HighCpuUsage
InterestingQueries_HighIoCount
InterestingQueries_HighMemoryUsage
InterestingQueries_HighTransactionCount
InterestingQueries_LargeResultset
InterestingQueries_LongRunningRequest
InterestingQueries_LongWaitingRequest
InterestingQueriesCount
InterestingQueriesLastSnapshotFileName
InterestingQueriesLastSnapshotFileNameOutput
InterestingQueriesSnapshotFileNamePrefixPattern
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
SnapshotId
SnapshotQueryStatsQuery
SourceId
TargetConnectionString
TopThreshold
Constraint
Constraint 1
Constraint 2
Constraint 3
Constraint 5
Constraint 6
Constraint 7
Constraint 8
Last Snapshot Missing
InterestingQueriesRowCountIn
InterestingQueriesRowCountOut
SqlPlanRowCountError
SqlPlanRowCountIn
SqlPlanRowCountOut
SqlPlanUpdateRowCountError
SqlPlanUpdateRowCountIn
SqlPlanUpdateRowCountOut
SqlTextRowCountError
SqlTextRowCountIn
SqlTextRowCountOut
SqlTextUpdateRowCountError
SqlTextUpdateRowCountIn
SqlTextUpdateRowCountOut
CacheDirectory
CacheWindow
CollectionCacheFileName
CollectionCacheFileNameOutput
CollectionCacheFilePrefixPattern
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
InterestingQueries_HighCpuUsage
InterestingQueries_HighIoCount
InterestingQueries_HighMemoryUsage
InterestingQueries_HighTransactionCount
InterestingQueries_LargeResultset
InterestingQueries_LongRunningRequest
InterestingQueries_LongWaitingRequest
InterestingQueriesCount
InterestingQueriesLastSnapshotFileName
InterestingQueriesLastSnapshotFileNameOutput
InterestingQueriesSnapshotFileNamePrefixPattern
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
SnapshotId
SnapshotQueryStatsQuery
SourceId
TargetConnectionString
TopThreshold
SEQ - Rename Collection Cache File
FST - Rename Cache File
FileSystemOperation
SyncRoot
CacheDirectory
CacheWindow
CollectionCacheFileName
CollectionCacheFileNameOutput
CollectionCacheFilePrefixPattern
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
InterestingQueries_HighCpuUsage
InterestingQueries_HighIoCount
InterestingQueries_HighMemoryUsage
InterestingQueries_HighTransactionCount
InterestingQueries_LargeResultset
InterestingQueries_LongRunningRequest
InterestingQueries_LongWaitingRequest
InterestingQueriesCount
InterestingQueriesLastSnapshotFileName
InterestingQueriesLastSnapshotFileNameOutput
InterestingQueriesSnapshotFileNamePrefixPattern
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
SnapshotId
SnapshotQueryStatsQuery
SourceId
TargetConnectionString
TopThreshold
SyncRoot
CacheDirectory
CacheWindow
CollectionCacheFileName
CollectionCacheFileNameOutput
CollectionCacheFilePrefixPattern
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
InterestingQueries_HighCpuUsage
InterestingQueries_HighIoCount
InterestingQueries_HighMemoryUsage
InterestingQueries_HighTransactionCount
InterestingQueries_LargeResultset
InterestingQueries_LongRunningRequest
InterestingQueries_LongWaitingRequest
InterestingQueriesCount
InterestingQueriesLastSnapshotFileName
InterestingQueriesLastSnapshotFileNameOutput
InterestingQueriesSnapshotFileNamePrefixPattern
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
SnapshotId
SnapshotQueryStatsQuery
SourceId
TargetConnectionString
TopThreshold
SQL - Get SnapshotId
ExecuteSQLExecutingQuery
CacheDirectory
CacheWindow
CollectionCacheFileName
CollectionCacheFileNameOutput
CollectionCacheFilePrefixPattern
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
InterestingQueries_HighCpuUsage
InterestingQueries_HighIoCount
InterestingQueries_HighMemoryUsage
InterestingQueries_HighTransactionCount
InterestingQueries_LargeResultset
InterestingQueries_LongRunningRequest
InterestingQueries_LongWaitingRequest
InterestingQueriesCount
InterestingQueriesLastSnapshotFileName
InterestingQueriesLastSnapshotFileNameOutput
InterestingQueriesSnapshotFileNamePrefixPattern
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
SnapshotId
SnapshotQueryStatsQuery
SourceId
TargetConnectionString
TopThreshold
SQL - Get SourceId
ExecuteSQLExecutingQuery
CacheDirectory
CacheWindow
CollectionCacheFileName
CollectionCacheFileNameOutput
CollectionCacheFilePrefixPattern
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
InterestingQueries_HighCpuUsage
InterestingQueries_HighIoCount
InterestingQueries_HighMemoryUsage
InterestingQueries_HighTransactionCount
InterestingQueries_LargeResultset
InterestingQueries_LongRunningRequest
InterestingQueries_LongWaitingRequest
InterestingQueriesCount
InterestingQueriesLastSnapshotFileName
InterestingQueriesLastSnapshotFileNameOutput
InterestingQueriesSnapshotFileNamePrefixPattern
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
SnapshotId
SnapshotQueryStatsQuery
SourceId
TargetConnectionString
TopThreshold
Log Entry Information
Diagnostic
DiagnosticEx
Log providers
Project Parameters
Precedence constraints
Constraint
Constraint 12
Constraint 3
Constraint 6
Constraint 7
Constraint 8
Variables
CacheDirectory
CacheWindow
CollectionCacheFileName
CollectionCacheFileNameOutput
CollectionCacheFilePrefixPattern
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
InterestingQueries_HighCpuUsage
InterestingQueries_HighIoCount
InterestingQueries_HighMemoryUsage
InterestingQueries_HighTransactionCount
InterestingQueries_LargeResultset
InterestingQueries_LongRunningRequest
InterestingQueries_LongWaitingRequest
InterestingQueriesCount
InterestingQueriesLastSnapshotFileName
InterestingQueriesLastSnapshotFileNameOutput
InterestingQueriesSnapshotFileNamePrefixPattern
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
SnapshotId
SnapshotQueryStatsQuery
SourceId
TargetConnectionString
TopThreshold
SqlTraceCollect
Configuration settings
CacheDirectory
CacheWindow
InputParameters
MDWConnectionString
ConfigConnectionString
TargetConnectionString
LoopEventName
ExitEventName
CollectorTypeUID
CollectionSetUID
ItemID
InstanceID
InstanceName
LoggingLevel
LogID
ParentLogID
Connection managers
ConfigConnection
ConnectionString
CacheDirectory
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
TargetConnectionString
TraceErrorCode
TraceID
TraceLocation
TraceScript
MdwConnection
ConnectionString
CacheDirectory
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
TargetConnectionString
TraceErrorCode
TraceID
TraceLocation
TraceScript
TargetConnection
ConnectionString
CacheDirectory
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
TargetConnectionString
TraceErrorCode
TraceID
TraceLocation
TraceScript
Event handlers
Executables
Foreach Loop - Monitor Trace
SQL - Check if Trace is Running
ExecuteSQLExecutingQuery
CacheDirectory
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
TargetConnectionString
TraceErrorCode
TraceID
TraceLocation
TraceScript
SQL - Log Package Iteration
ExecuteSQLExecutingQuery
CacheDirectory
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
TargetConnectionString
TraceErrorCode
TraceID
TraceLocation
TraceScript
SQL - Log Package Stats
ExecuteSQLExecutingQuery
CacheDirectory
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
TargetConnectionString
TraceErrorCode
TraceID
TraceLocation
TraceScript
SQL - Recreate Trace
ExecuteSQLExecutingQuery
CacheDirectory
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
TargetConnectionString
TraceErrorCode
TraceID
TraceLocation
TraceScript
{710AEAF2-45BD-4AB2-9EAF-FB6268AD10A2}
ExitEventName
LoopEventName
ExitEventName
LoopEventName
Constraint
Constraint 1
Constraint 2
Constraint 3
CacheDirectory
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
TargetConnectionString
TraceErrorCode
TraceID
TraceLocation
TraceScript
SQL - Close trace if running
ExecuteSQLExecutingQuery
CacheDirectory
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
TargetConnectionString
TraceErrorCode
TraceID
TraceLocation
TraceScript
SQL - Execute Trace Start Script
ExecuteSQLExecutingQuery
CacheDirectory
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
TargetConnectionString
TraceErrorCode
TraceID
TraceLocation
TraceScript
SQL - Stop Trace
ExecuteSQLExecutingQuery
CacheDirectory
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
TargetConnectionString
TraceErrorCode
TraceID
TraceLocation
TraceScript
TRC - Generate Trace Start Script
InputParameters
TraceFileLocation
CacheDirectory
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
TargetConnectionString
TraceErrorCode
TraceID
TraceLocation
TraceScript
Log Entry Information
Diagnostic
DiagnosticEx
Log providers
Project Parameters
Precedence constraints
Constraint
Constraint 1
Constraint 2
Constraint 5
Variables
CacheDirectory
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopDuration
LoopEventName
MDWConnectionString
ParentLogID
TargetConnectionString
TraceErrorCode
TraceID
TraceLocation
TraceScript
SqlTraceUpload
Configuration settings
CacheDirectory
CacheWindow
InputParameters
MDWConnectionString
ConfigConnectionString
TargetConnectionString
LoopEventName
ExitEventName
CollectorTypeUID
CollectionSetUID
ItemID
InstanceID
InstanceName
LoggingLevel
LogID
ParentLogID
DaysUntilExpiration
Connection managers
ConfigConnection
ConnectionString
CacheDirectory
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
Counter
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopEventName
MDWConnectionString
ParentLogID
RowCountIn
SnapshotID
SourceID
TargetConnectionString
TraceCurrentEventTime
TraceCurrentFile
TraceDroppedEventCount
TraceID
TraceInfoID
TraceIsRunning
TraceLastEventSequence
TraceLocation
TraceStartTime
TraceUseDefault
MdwConnection
ConnectionString
CacheDirectory
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
Counter
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopEventName
MDWConnectionString
ParentLogID
RowCountIn
SnapshotID
SourceID
TargetConnectionString
TraceCurrentEventTime
TraceCurrentFile
TraceDroppedEventCount
TraceID
TraceInfoID
TraceIsRunning
TraceLastEventSequence
TraceLocation
TraceStartTime
TraceUseDefault
TargetConnection
ConnectionString
CacheDirectory
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
Counter
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopEventName
MDWConnectionString
ParentLogID
RowCountIn
SnapshotID
SourceID
TargetConnectionString
TraceCurrentEventTime
TraceCurrentFile
TraceDroppedEventCount
TraceID
TraceInfoID
TraceIsRunning
TraceLastEventSequence
TraceLocation
TraceStartTime
TraceUseDefault
Event handlers
Executables
For Loop Container
FEF - For each trace file - regular trace upload
DFT - Upload trace file
AGG - Get max value of EventSequence
KeyScale
Keys
CountDistinctScale
CountDistinctKeys
AutoExtendFactor
Aggregate Input 1
EventSequence
Aggregate Output 1
KeyScale
Keys
EventSequence_Max
AggregationColumnId
AggregationType
IsBig
AggregationComparisonFlags
event_count
AggregationColumnId
AggregationType
IsBig
AggregationComparisonFlags
CNT - Error row count source
VariableName
Row Count Input 1
Row Count Output 1
CNT - Input row count
VariableName
Row Count Input 1
Row Count Output 1
CNT - Output row count
VariableName
Row Count Input 1
Row Count Output 1
Data Conversion
Data Conversion Input
SqlHandle
PlanHandle
Data Conversion Output
SqlHandle64
SourceInputColumnLineageID
FastParse
PlanHandle64
SourceInputColumnLineageID
FastParse
Data Conversion Error Output
ErrorCode
ErrorColumn
DRV - Add columns
Derived Column Input
EventSequence_Max
Derived Column Output
trace_info_id
Expression
FriendlyExpression
snapshot_id
Expression
FriendlyExpression
is_running
Expression
FriendlyExpression
dropped_event_count
Expression
FriendlyExpression
last_event_sequence
Expression
FriendlyExpression
Derived Column Error Output
ErrorCode
ErrorColumn
DRV - Add snapshot_id and trace_info_id
Derived Column Input
Derived Column Output
trace_info_id
Expression
FriendlyExpression
snapshot_id
Expression
FriendlyExpression
Derived Column Error Output
ErrorCode
ErrorColumn
MLT - Split two ways
Multicast Input 1
Multicast Output 1
Multicast Output 2
Multicast Output 3
ODB - Read trace
CommandTimeout
OpenRowset
OpenRowsetVariable
SqlCommand
SqlCommandVariable
DefaultCodePage
AlwaysUseDefaultCodePage
AccessMode
ParameterMapping
OLE DB Source Output
TextData
BinaryData
DatabaseID
TransactionID
LineNumber
NTUserName
NTDomainName
HostName
ClientProcessID
ApplicationName
LoginName
SPID
Duration
StartTime
EndTime
Reads
Writes
CPU
Permissions
Severity
EventSubClass
ObjectID
Success
IndexID
IntegerData
ServerName
EventClass
ObjectType
NestLevel
State
Error
Mode
Handle
ObjectName
DatabaseName
FileName
OwnerName
RoleName
TargetUserName
DBUserName
LoginSid
TargetLoginName
TargetLoginSid
ColumnPermissions
LinkedServerName
ProviderName
MethodName
RowCounts
RequestID
XactSequence
EventSequence
BigintData1
BigintData2
GUID
IntegerData2
ObjectID2
Type
OwnerID
ParentName
IsSystem
Offset
SourceDatabaseID
SqlHandle
SessionLoginName
PlanHandle
GroupID
TextData
BinaryData
DatabaseID
TransactionID
LineNumber
NTUserName
NTDomainName
HostName
ClientProcessID
ApplicationName
LoginName
SPID
Duration
StartTime
EndTime
Reads
Writes
CPU
Permissions
Severity
EventSubClass
ObjectID
Success
IndexID
IntegerData
ServerName
EventClass
ObjectType
NestLevel
State
Error
Mode
Handle
ObjectName
DatabaseName
FileName
OwnerName
RoleName
TargetUserName
DBUserName
LoginSid
TargetLoginName
TargetLoginSid
ColumnPermissions
LinkedServerName
ProviderName
MethodName
RowCounts
RequestID
XactSequence
EventSequence
BigintData1
BigintData2
GUID
IntegerData2
ObjectID2
Type
OwnerID
ParentName
IsSystem
Offset
SourceDatabaseID
SqlHandle
SessionLoginName
PlanHandle
GroupID
OLE DB Source Error Output
TextData
BinaryData
DatabaseID
TransactionID
LineNumber
NTUserName
NTDomainName
HostName
ClientProcessID
ApplicationName
LoginName
SPID
Duration
StartTime
EndTime
Reads
Writes
CPU
Permissions
Severity
EventSubClass
ObjectID
Success
IndexID
IntegerData
ServerName
EventClass
ObjectType
NestLevel
State
Error
Mode
Handle
ObjectName
DatabaseName
FileName
OwnerName
RoleName
TargetUserName
DBUserName
LoginSid
TargetLoginName
TargetLoginSid
ColumnPermissions
LinkedServerName
ProviderName
MethodName
RowCounts
RequestID
XactSequence
EventSequence
BigintData1
BigintData2
GUID
IntegerData2
ObjectID2
Type
OwnerID
ParentName
IsSystem
Offset
SourceDatabaseID
SqlHandle
SessionLoginName
PlanHandle
GroupID
ErrorCode
ErrorColumn
OleDbConnection
ODB - Update trace_info
CommandTimeout
SqlCommand
DefaultCodePage
OLE DB Command Input
@trace_info_id
DBParamInfoFlags
@snapshot_id
DBParamInfoFlags
@is_running
DBParamInfoFlags
@event_count
DBParamInfoFlags
@dropped_event_count
DBParamInfoFlags
@last_event_sequence
DBParamInfoFlags
trace_info_id
snapshot_id
is_running
event_count
dropped_event_count
last_event_sequence
OLE DB Command Output
OLE DB Command Error Output
ErrorCode
ErrorColumn
OleDbConnection
ODB - Write to output table
CommandTimeout
OpenRowset
OpenRowsetVariable
SqlCommand
DefaultCodePage
AlwaysUseDefaultCodePage
AccessMode
FastLoadKeepIdentity
FastLoadKeepNulls
FastLoadOptions
FastLoadMaxInsertCommitSize
OLE DB Destination Input
trace_info_id
snapshot_id
TextData
BinaryData
DatabaseID
TransactionID
LineNumber
NTUserName
NTDomainName
HostName
ClientProcessID
ApplicationName
LoginName
SPID
Duration
StartTime
EndTime
Reads
Writes
CPU
Permissions
Severity
EventSubClass
ObjectID
Success
IndexID
IntegerData
ServerName
EventClass
ObjectType
NestLevel
State
Error
Mode
Handle
ObjectName
DatabaseName
FileName
OwnerName
RoleName
TargetUserName
DBUserName
LoginSid
TargetLoginName
TargetLoginSid
ColumnPermissions
LinkedServerName
ProviderName
MethodName
RowCounts
RequestID
XactSequence
EventSequence
BigintData1
BigintData2
GUID
IntegerData2
ObjectID2
Type
OwnerID
ParentName
IsSystem
Offset
SourceDatabaseID
SqlHandle
SessionLoginName
PlanHandle
GroupID
TextData
BinaryData
DatabaseID
TransactionID
LineNumber
NTUserName
NTDomainName
HostName
ClientProcessID
ApplicationName
LoginName
SPID
Duration
StartTime
EndTime
Reads
Writes
CPU
Permissions
Severity
EventSubClass
ObjectID
Success
IndexID
IntegerData
ServerName
EventClass
ObjectType
NestLevel
State
Error
Mode
Handle
ObjectName
DatabaseName
FileName
OwnerName
RoleName
TargetUserName
DBUserName
LoginSid
TargetLoginName
TargetLoginSid
ColumnPermissions
LinkedServerName
ProviderName
MethodName
RowCounts
RequestID
XactSequence
EventSequence
BigintData1
BigintData2
GUID
IntegerData2
ObjectID2
Type
OwnerID
ParentName
IsSystem
Offset
SourceDatabaseID
SessionLoginName
trace_info_id
snapshot_id
GroupID
SqlHandle64
PlanHandle64
OLE DB Destination Error Output
ErrorCode
ErrorColumn
OleDbConnection
BufferSizeTuning
PipelineBufferLeak
PipelineComponentTime
PipelineExecutionPlan
PipelineExecutionTrees
PipelineInitialization
Aggregate Output 1
Data Conversion Output
Derived Column Output
Derived Column Output
Multicast Output 1
Multicast Output 2
OLE DB Source Error Output
OLE DB Source Output
Row Count Output 1
Row Count Output 1
TraceLoadScript
RowCountError
RowCountIn
RowCountOut
CacheDirectory
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
Counter
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopEventName
MDWConnectionString
ParentLogID
RowCountIn
SnapshotID
SourceID
TargetConnectionString
TraceCurrentEventTime
TraceCurrentFile
TraceDroppedEventCount
TraceID
TraceInfoID
TraceIsRunning
TraceLastEventSequence
TraceLocation
TraceStartTime
TraceUseDefault
FAT - Check if trace file is accessible
FilePath
Mode
RowCountError
RowCountIn
RowCountOut
CacheDirectory
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
Counter
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopEventName
MDWConnectionString
ParentLogID
RowCountIn
SnapshotID
SourceID
TargetConnectionString
TraceCurrentEventTime
TraceCurrentFile
TraceDroppedEventCount
TraceID
TraceInfoID
TraceIsRunning
TraceLastEventSequence
TraceLocation
TraceStartTime
TraceUseDefault
FAT - Precheck if trace file is accessible
FilePath
Mode
RowCountError
RowCountIn
RowCountOut
CacheDirectory
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
Counter
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopEventName
MDWConnectionString
ParentLogID
RowCountIn
SnapshotID
SourceID
TargetConnectionString
TraceCurrentEventTime
TraceCurrentFile
TraceDroppedEventCount
TraceID
TraceInfoID
TraceIsRunning
TraceLastEventSequence
TraceLocation
TraceStartTime
TraceUseDefault
FST - Delete trace file
OnError
RowCountError
RowCountIn
RowCountOut
CacheDirectory
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
Counter
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopEventName
MDWConnectionString
ParentLogID
RowCountIn
SnapshotID
SourceID
TargetConnectionString
TraceCurrentEventTime
TraceCurrentFile
TraceDroppedEventCount
TraceID
TraceInfoID
TraceIsRunning
TraceLastEventSequence
TraceLocation
TraceStartTime
TraceUseDefault
FileSystemOperation
RowCountError
RowCountIn
RowCountOut
CacheDirectory
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
Counter
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopEventName
MDWConnectionString
ParentLogID
RowCountIn
SnapshotID
SourceID
TargetConnectionString
TraceCurrentEventTime
TraceCurrentFile
TraceDroppedEventCount
TraceID
TraceInfoID
TraceIsRunning
TraceLastEventSequence
TraceLocation
TraceStartTime
TraceUseDefault
SQL - Log package stats
ExecuteSQLExecutingQuery
LoopDuration
RowCountError
RowCountIn
RowCountOut
CacheDirectory
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
Counter
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopEventName
MDWConnectionString
ParentLogID
RowCountIn
SnapshotID
SourceID
TargetConnectionString
TraceCurrentEventTime
TraceCurrentFile
TraceDroppedEventCount
TraceID
TraceInfoID
TraceIsRunning
TraceLastEventSequence
TraceLocation
TraceStartTime
TraceUseDefault
SQL - logs uploaded file name
ExecuteSQLExecutingQuery
RowCountError
RowCountIn
RowCountOut
CacheDirectory
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
Counter
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopEventName
MDWConnectionString
ParentLogID
RowCountIn
SnapshotID
SourceID
TargetConnectionString
TraceCurrentEventTime
TraceCurrentFile
TraceDroppedEventCount
TraceID
TraceInfoID
TraceIsRunning
TraceLastEventSequence
TraceLocation
TraceStartTime
TraceUseDefault
{821B0536-E431-458F-8EAE-028BE667F142}
Directory
FileSpec
Directory
FileSpec
Constraint
Constraint 1
Constraint 2
Constraint 3
Constraint 4
RowCountError
RowCountIn
RowCountOut
CacheDirectory
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
Counter
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopEventName
MDWConnectionString
ParentLogID
RowCountIn
SnapshotID
SourceID
TargetConnectionString
TraceCurrentEventTime
TraceCurrentFile
TraceDroppedEventCount
TraceID
TraceInfoID
TraceIsRunning
TraceLastEventSequence
TraceLocation
TraceStartTime
TraceUseDefault
SQL - Check trace info
ExecuteSQLExecutingQuery
CacheDirectory
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
Counter
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopEventName
MDWConnectionString
ParentLogID
RowCountIn
SnapshotID
SourceID
TargetConnectionString
TraceCurrentEventTime
TraceCurrentFile
TraceDroppedEventCount
TraceID
TraceInfoID
TraceIsRunning
TraceLastEventSequence
TraceLocation
TraceStartTime
TraceUseDefault
SQL - Close trace
ExecuteSQLExecutingQuery
CacheDirectory
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
Counter
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopEventName
MDWConnectionString
ParentLogID
RowCountIn
SnapshotID
SourceID
TargetConnectionString
TraceCurrentEventTime
TraceCurrentFile
TraceDroppedEventCount
TraceID
TraceInfoID
TraceIsRunning
TraceLastEventSequence
TraceLocation
TraceStartTime
TraceUseDefault
SQL - Get Last_Event_Sequence
ExecuteSQLExecutingQuery
CacheDirectory
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
Counter
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopEventName
MDWConnectionString
ParentLogID
RowCountIn
SnapshotID
SourceID
TargetConnectionString
TraceCurrentEventTime
TraceCurrentFile
TraceDroppedEventCount
TraceID
TraceInfoID
TraceIsRunning
TraceLastEventSequence
TraceLocation
TraceStartTime
TraceUseDefault
Constraint
Constraint 1
Constraint 2
CacheDirectory
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
Counter
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopEventName
MDWConnectionString
ParentLogID
RowCountIn
SnapshotID
SourceID
TargetConnectionString
TraceCurrentEventTime
TraceCurrentFile
TraceDroppedEventCount
TraceID
TraceInfoID
TraceIsRunning
TraceLastEventSequence
TraceLocation
TraceStartTime
TraceUseDefault
SEQ - Default trace upload
DFT - Upload default trace file
AGG - Get max value of EventSequence
KeyScale
Keys
CountDistinctScale
CountDistinctKeys
AutoExtendFactor
Aggregate Input 1
EventSequence
Aggregate Output 1
KeyScale
Keys
EventSequence_Max
AggregationColumnId
AggregationType
IsBig
AggregationComparisonFlags
event_count
AggregationColumnId
AggregationType
IsBig
AggregationComparisonFlags
CNT - Error row count source
VariableName
Row Count Input 1
Row Count Output 1
CNT - Input row count
VariableName
Row Count Input 1
Row Count Output 1
CNT - Output row count
VariableName
Row Count Input 1
Row Count Output 1
Data Conversion
Data Conversion Input
SqlHandle
PlanHandle
Data Conversion Output
SqlHandle64
SourceInputColumnLineageID
FastParse
PlanHandle64
SourceInputColumnLineageID
FastParse
Data Conversion Error Output
ErrorCode
ErrorColumn
DRV - Add columns
Derived Column Input
EventSequence_Max
Derived Column Output
trace_info_id
Expression
FriendlyExpression
snapshot_id
Expression
FriendlyExpression
is_running
Expression
FriendlyExpression
dropped_event_count
Expression
FriendlyExpression
last_event_sequence
Expression
FriendlyExpression
Derived Column Error Output
ErrorCode
ErrorColumn
DRV - Add snapshot_id and trace_info_id
Derived Column Input
Derived Column Output
trace_info_id
Expression
FriendlyExpression
snapshot_id
Expression
FriendlyExpression
Derived Column Error Output
ErrorCode
ErrorColumn
MLT - Split two ways
Multicast Input 1
Multicast Output 1
Multicast Output 2
Multicast Output 3
ODB - Read trace
CommandTimeout
OpenRowset
OpenRowsetVariable
SqlCommand
SqlCommandVariable
DefaultCodePage
AlwaysUseDefaultCodePage
AccessMode
ParameterMapping
OLE DB Source Output
TextData
BinaryData
DatabaseID
TransactionID
LineNumber
NTUserName
NTDomainName
HostName
ClientProcessID
ApplicationName
LoginName
SPID
Duration
StartTime
EndTime
Reads
Writes
CPU
Permissions
Severity
EventSubClass
ObjectID
Success
IndexID
IntegerData
ServerName
EventClass
ObjectType
NestLevel
State
Error
Mode
Handle
ObjectName
DatabaseName
FileName
OwnerName
RoleName
TargetUserName
DBUserName
LoginSid
TargetLoginName
TargetLoginSid
ColumnPermissions
LinkedServerName
ProviderName
MethodName
RowCounts
RequestID
XactSequence
EventSequence
BigintData1
BigintData2
GUID
IntegerData2
ObjectID2
Type
OwnerID
ParentName
IsSystem
Offset
SourceDatabaseID
SqlHandle
SessionLoginName
PlanHandle
GroupID
TextData
BinaryData
DatabaseID
TransactionID
LineNumber
NTUserName
NTDomainName
HostName
ClientProcessID
ApplicationName
LoginName
SPID
Duration
StartTime
EndTime
Reads
Writes
CPU
Permissions
Severity
EventSubClass
ObjectID
Success
IndexID
IntegerData
ServerName
EventClass
ObjectType
NestLevel
State
Error
Mode
Handle
ObjectName
DatabaseName
FileName
OwnerName
RoleName
TargetUserName
DBUserName
LoginSid
TargetLoginName
TargetLoginSid
ColumnPermissions
LinkedServerName
ProviderName
MethodName
RowCounts
RequestID
XactSequence
EventSequence
BigintData1
BigintData2
GUID
IntegerData2
ObjectID2
Type
OwnerID
ParentName
IsSystem
Offset
SourceDatabaseID
SqlHandle
SessionLoginName
PlanHandle
GroupID
OLE DB Source Error Output
TextData
BinaryData
DatabaseID
TransactionID
LineNumber
NTUserName
NTDomainName
HostName
ClientProcessID
ApplicationName
LoginName
SPID
Duration
StartTime
EndTime
Reads
Writes
CPU
Permissions
Severity
EventSubClass
ObjectID
Success
IndexID
IntegerData
ServerName
EventClass
ObjectType
NestLevel
State
Error
Mode
Handle
ObjectName
DatabaseName
FileName
OwnerName
RoleName
TargetUserName
DBUserName
LoginSid
TargetLoginName
TargetLoginSid
ColumnPermissions
LinkedServerName
ProviderName
MethodName
RowCounts
RequestID
XactSequence
EventSequence
BigintData1
BigintData2
GUID
IntegerData2
ObjectID2
Type
OwnerID
ParentName
IsSystem
Offset
SourceDatabaseID
SqlHandle
SessionLoginName
PlanHandle
GroupID
ErrorCode
ErrorColumn
OleDbConnection
ODB - Update trace_info
CommandTimeout
SqlCommand
DefaultCodePage
OLE DB Command Input
@trace_info_id
DBParamInfoFlags
@snapshot_id
DBParamInfoFlags
@is_running
DBParamInfoFlags
@event_count
DBParamInfoFlags
@dropped_event_count
DBParamInfoFlags
@last_event_sequence
DBParamInfoFlags
trace_info_id
snapshot_id
is_running
event_count
dropped_event_count
last_event_sequence
OLE DB Command Output
OLE DB Command Error Output
ErrorCode
ErrorColumn
OleDbConnection
ODB - Write to output table
CommandTimeout
OpenRowset
OpenRowsetVariable
SqlCommand
DefaultCodePage
AlwaysUseDefaultCodePage
AccessMode
FastLoadKeepIdentity
FastLoadKeepNulls
FastLoadOptions
FastLoadMaxInsertCommitSize
OLE DB Destination Input
trace_info_id
snapshot_id
TextData
BinaryData
DatabaseID
TransactionID
LineNumber
NTUserName
NTDomainName
HostName
ClientProcessID
ApplicationName
LoginName
SPID
Duration
StartTime
EndTime
Reads
Writes
CPU
Permissions
Severity
EventSubClass
ObjectID
Success
IndexID
IntegerData
ServerName
EventClass
ObjectType
NestLevel
State
Error
Mode
Handle
ObjectName
DatabaseName
FileName
OwnerName
RoleName
TargetUserName
DBUserName
LoginSid
TargetLoginName
TargetLoginSid
ColumnPermissions
LinkedServerName
ProviderName
MethodName
RowCounts
RequestID
XactSequence
EventSequence
BigintData1
BigintData2
GUID
IntegerData2
ObjectID2
Type
OwnerID
ParentName
IsSystem
Offset
SourceDatabaseID
SqlHandle
SessionLoginName
PlanHandle
GroupID
TextData
BinaryData
DatabaseID
TransactionID
LineNumber
NTUserName
NTDomainName
HostName
ClientProcessID
ApplicationName
LoginName
SPID
Duration
StartTime
EndTime
Reads
Writes
CPU
Permissions
Severity
EventSubClass
ObjectID
Success
IndexID
IntegerData
ServerName
EventClass
ObjectType
NestLevel
State
Error
Mode
Handle
ObjectName
DatabaseName
FileName
OwnerName
RoleName
TargetUserName
DBUserName
LoginSid
TargetLoginName
TargetLoginSid
ColumnPermissions
LinkedServerName
ProviderName
MethodName
RowCounts
RequestID
XactSequence
EventSequence
BigintData1
BigintData2
GUID
IntegerData2
ObjectID2
Type
OwnerID
ParentName
IsSystem
Offset
SourceDatabaseID
SessionLoginName
trace_info_id
snapshot_id
GroupID
SqlHandle64
PlanHandle64
OLE DB Destination Error Output
ErrorCode
ErrorColumn
OleDbConnection
BufferSizeTuning
PipelineBufferLeak
PipelineComponentTime
PipelineExecutionPlan
PipelineExecutionTrees
PipelineInitialization
Aggregate Output 1
Data Conversion Output
Derived Column Output
Derived Column Output
Multicast Output 1
Multicast Output 2
OLE DB Source Error Output
OLE DB Source Output
Row Count Output 1
Row Count Output 1
TraceLoadScript
RowCountError
RowCountIn
RowCountOut
CacheDirectory
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
Counter
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopEventName
MDWConnectionString
ParentLogID
RowCountIn
SnapshotID
SourceID
TargetConnectionString
TraceCurrentEventTime
TraceCurrentFile
TraceDroppedEventCount
TraceID
TraceInfoID
TraceIsRunning
TraceLastEventSequence
TraceLocation
TraceStartTime
TraceUseDefault
SQL - Log package stats
ExecuteSQLExecutingQuery
LoopDuration
RowCountError
RowCountIn
RowCountOut
CacheDirectory
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
Counter
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopEventName
MDWConnectionString
ParentLogID
RowCountIn
SnapshotID
SourceID
TargetConnectionString
TraceCurrentEventTime
TraceCurrentFile
TraceDroppedEventCount
TraceID
TraceInfoID
TraceIsRunning
TraceLastEventSequence
TraceLocation
TraceStartTime
TraceUseDefault
Constraint
RowCountError
RowCountIn
RowCountOut
CacheDirectory
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
Counter
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopEventName
MDWConnectionString
ParentLogID
RowCountIn
SnapshotID
SourceID
TargetConnectionString
TraceCurrentEventTime
TraceCurrentFile
TraceDroppedEventCount
TraceID
TraceInfoID
TraceIsRunning
TraceLastEventSequence
TraceLocation
TraceStartTime
TraceUseDefault
SQL - Close trace
ExecuteSQLExecutingQuery
CacheDirectory
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
Counter
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopEventName
MDWConnectionString
ParentLogID
RowCountIn
SnapshotID
SourceID
TargetConnectionString
TraceCurrentEventTime
TraceCurrentFile
TraceDroppedEventCount
TraceID
TraceInfoID
TraceIsRunning
TraceLastEventSequence
TraceLocation
TraceStartTime
TraceUseDefault
SQL - Get last upload time
ExecuteSQLExecutingQuery
CacheDirectory
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
Counter
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopEventName
MDWConnectionString
ParentLogID
RowCountIn
SnapshotID
SourceID
TargetConnectionString
TraceCurrentEventTime
TraceCurrentFile
TraceDroppedEventCount
TraceID
TraceInfoID
TraceIsRunning
TraceLastEventSequence
TraceLocation
TraceStartTime
TraceUseDefault
SQL - Get snapshot id
ExecuteSQLExecutingQuery
CacheDirectory
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
Counter
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopEventName
MDWConnectionString
ParentLogID
RowCountIn
SnapshotID
SourceID
TargetConnectionString
TraceCurrentEventTime
TraceCurrentFile
TraceDroppedEventCount
TraceID
TraceInfoID
TraceIsRunning
TraceLastEventSequence
TraceLocation
TraceStartTime
TraceUseDefault
SQL - Get trace info
ExecuteSQLExecutingQuery
CacheDirectory
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
Counter
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopEventName
MDWConnectionString
ParentLogID
RowCountIn
SnapshotID
SourceID
TargetConnectionString
TraceCurrentEventTime
TraceCurrentFile
TraceDroppedEventCount
TraceID
TraceInfoID
TraceIsRunning
TraceLastEventSequence
TraceLocation
TraceStartTime
TraceUseDefault
SQL - Update data source
ExecuteSQLExecutingQuery
CacheDirectory
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
Counter
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopEventName
MDWConnectionString
ParentLogID
RowCountIn
SnapshotID
SourceID
TargetConnectionString
TraceCurrentEventTime
TraceCurrentFile
TraceDroppedEventCount
TraceID
TraceInfoID
TraceIsRunning
TraceLastEventSequence
TraceLocation
TraceStartTime
TraceUseDefault
XML - Check use_default attribute
XMLOperation
CacheDirectory
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
Counter
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopEventName
MDWConnectionString
ParentLogID
RowCountIn
SnapshotID
SourceID
TargetConnectionString
TraceCurrentEventTime
TraceCurrentFile
TraceDroppedEventCount
TraceID
TraceInfoID
TraceIsRunning
TraceLastEventSequence
TraceLocation
TraceStartTime
TraceUseDefault
Log Entry Information
Diagnostic
DiagnosticEx
Log providers
Project Parameters
Precedence constraints
Constraint
Constraint 1
Constraint 2
Constraint 3
Constraint 5
Constraint 6
Constraint 8
Variables
CacheDirectory
CacheWindow
CollectionSetUID
CollectorTypeUID
ConfigConnectionString
Counter
DaysUntilExpiration
ExitEventName
InputParameters
InstanceID
InstanceName
ItemID
LoggingLevel
LogID
LoopEventName
MDWConnectionString
ParentLogID
RowCountIn
SnapshotID
SourceID
TargetConnectionString
TraceCurrentEventTime
TraceCurrentFile
TraceDroppedEventCount
TraceID
TraceInfoID
TraceIsRunning
TraceLastEventSequence
TraceLocation
TraceStartTime
TraceUseDefault
SSIS Projects
OtherPackages.dtproj
AnalysisProcessingPackage
Configuration settings
Connection managers
localhost
Event handlers
Executables
Analysis Services Processing Task
Log Entry Information
Diagnostic
DiagnosticEx
Log providers
Project Parameters
Precedence constraints
Variables
BackUpDBTaskPackage
Configuration settings
Connection managers
serverbackup
Event handlers
Executables
Back Up Database Task
ExecuteSQLExecutingQuery
Log Entry Information
Diagnostic
DiagnosticEx
Log providers
Project Parameters
Precedence constraints
Variables
BulkInsertPackage
Configuration settings
Connection managers
localhost.Test
Package.xml
Event handlers
Executables
Bulk Insert Task
BulkInsertBegin
BulkInsertEnd
BulkInsertTaskInfo
Log Entry Information
Diagnostic
DiagnosticEx
Log providers
Project Parameters
Precedence constraints
Variables
CheckDBIntegrityTaskPackage
Configuration settings
Connection managers
serverconn
Event handlers
Executables
Check Database Integrity Task
ExecuteSQLExecutingQuery
Log Entry Information
Diagnostic
DiagnosticEx
Log providers
Project Parameters
Precedence constraints
Variables
CompareExecuteProcess1Package
Configuration settings
Connection managers
log.txt
Event handlers
OnError
Execute Process Task
ExecuteProcessExecutingProcess
ExecuteProcessVariableRouting
Executables
Execute Process Task
ExecuteProcessExecutingProcess
ExecuteProcessVariableRouting
Execute Process Task 1
ExecuteProcessExecutingProcess
ExecuteProcessVariableRouting
Log Entry Information
Diagnostic
DiagnosticEx
Log providers
SSIS log provider for Text files
Project Parameters
Precedence constraints
Constraint
Variables
CompareExecuteProcess2Package
Configuration settings
Connection managers
log.txt
MyVariable
Event handlers
OnError
Execute Process Task
ExecuteProcessExecutingProcess
ExecuteProcessVariableRouting
MyVariable
MyVariable
Executables
Execute Process Task
ExecuteProcessExecutingProcess
ExecuteProcessVariableRouting
MyVariable
Execute Process Task 1
ExecuteProcessExecutingProcess
ExecuteProcessVariableRouting
MyVariable
Log Entry Information
Diagnostic
DiagnosticEx
Log providers
SSIS log provider for Text files
Project Parameters
Precedence constraints
Constraint
Variables
MyVariable
ConstraintsPackage
Configuration settings
Connection managers
Event handlers
Executables
Execute Process Task
ExecuteProcessExecutingProcess
ExecuteProcessVariableRouting
Execute Process Task 1
ExecuteProcessExecutingProcess
ExecuteProcessVariableRouting
Execute Process Task 2
ExecuteProcessExecutingProcess
ExecuteProcessVariableRouting
Execute Process Task 3
ExecuteProcessExecutingProcess
ExecuteProcessVariableRouting
Execute Process Task 4
ExecuteProcessExecutingProcess
ExecuteProcessVariableRouting
Log Entry Information
Diagnostic
DiagnosticEx
Log providers
Project Parameters
Precedence constraints
Constraint
Constraint 1
Constraint 2
Constraint 3
Variables
DataCorrectionPackage
Configuration settings
Connection managers
localhost.AdventureWorks
Event handlers
Executables
Data Flow Task
Data Correction
DomainGroupName
UserComponentTypeName
Data Correction Input
Data Correction Output
IsCorrected
OLE DB Destination
CommandTimeout
OpenRowset
OpenRowsetVariable
SqlCommand
DefaultCodePage
AlwaysUseDefaultCodePage
AccessMode
FastLoadKeepIdentity
FastLoadKeepNulls
FastLoadOptions
FastLoadMaxInsertCommitSize
OLE DB Destination Input
rowguid
ModifiedDate
BusinessEntityID
PersonType
NameStyle
Title
FirstName
MiddleName
LastName
Suffix
EmailPromotion
AdditionalContactInfo
Demographics
IsCorrected
OLE DB Destination Error Output
ErrorCode
ErrorColumn
OleDbConnection
OLE DB Source
CommandTimeout
OpenRowset
OpenRowsetVariable
SqlCommand
SqlCommandVariable
DefaultCodePage
AlwaysUseDefaultCodePage
AccessMode
ParameterMapping
OLE DB Source Output
UserName
ErrorLogID
ErrorTime
ErrorNumber
ErrorSeverity
ErrorState
ErrorProcedure
ErrorLine
ErrorMessage
UserName
ErrorLogID
ErrorTime
ErrorNumber
ErrorSeverity
ErrorState
ErrorProcedure
ErrorLine
ErrorMessage
OLE DB Source Error Output
ErrorLogID
ErrorTime
UserName
ErrorNumber
ErrorSeverity
ErrorState
ErrorProcedure
ErrorLine
ErrorMessage
ErrorCode
ErrorColumn
OleDbConnection
BufferSizeTuning
PipelineBufferLeak
PipelineComponentTime
PipelineExecutionPlan
PipelineExecutionTrees
PipelineInitialization
Data Correction Output
OLE DB Source Output
Log Entry Information
Diagnostic
DiagnosticEx
Log providers
Project Parameters
Precedence constraints
Variables
EventHandlersPackage
Configuration settings
Connection managers
Event handlers
Executables
Execute Process Task
OnError
Execute Process Task
ExecuteProcessExecutingProcess
ExecuteProcessVariableRouting
ExecuteProcessExecutingProcess
ExecuteProcessVariableRouting
Log Entry Information
Diagnostic
DiagnosticEx
Log providers
Project Parameters
Precedence constraints
Variables
SSAS
ALEN-PC\SQLSERVER2016
Server properties
AdventureWorksDW2014Multidimensional-SE
Data sources
Adventure Works DW
Data source views
Adventure Works DW
DimCustomer
DimEmployee
DimGeography
DimPromotion
DimReseller
DimDate
Sales Quota Facts
DimAccount
DimDepartmentGroup
DimProductCategory
DimSalesTerritory
DimScenario
FactFinance
DimSalesReason
FactInternetSalesReason
Currency Rate Facts
Currency
DimProductSubcategory
Organization
vAssocSeqLineItems
vAssocSeqOrders
vTargetMail
vTimeSeries
DimProduct
FactInternetSales
FactResellerSales
Sales Summary Facts
Destination Currency
Clustered Customers
DIMENSION_CONTENT_ROWSET
Cubes
Adventure Works
Actions
City Map
Sales Reason Comparisons
Reseller Details
Internet Details
Sales Summary Details
Dimensions
Date
Ship Date
Delivery Date
Customer
Reseller
Geography
Employee
Promotion
Product
Sales Territory
Source Currency
Sales Reason
Sales Summary Order Details
Internet Sales Order Details
Reseller Sales Order Details
Sales Channel
KPIs
Growth in Customer Base
Product Gross Profit Margin
Revenue
Channel Revenue
Internet Revenue
Calculations
MdxScript
MeasureGroups
Internet Sales
Measures
Internet Sales Amount
Internet Order Quantity
Internet Extended Amount
Internet Tax Amount
Internet Freight Cost
Internet Unit Price
Internet Total Product Cost
Internet Standard Product Cost
Internet Transaction Count
Partitions
Internet_Sales
Internet Orders
Measures
Internet Order Count
Partitions
Internet_Orders
Internet Customers
Measures
Customer Count
Partitions
Customer_Counts
Sales Reasons
Measures
Sales Reason Count
Partitions
Internet_Sales_Reasons
Reseller Sales
Measures
Reseller Sales Amount
Reseller Order Quantity
Reseller Extended Amount
Reseller Tax Amount
Reseller Freight Cost
Discount Amount
Reseller Unit Price
Unit Price Discount Percent
Reseller Total Product Cost
Reseller Standard Product Cost
Reseller Transaction Count
Partitions
Reseller_Sales
Reseller Orders
Measures
Reseller Order Count
Partitions
Reseller_Orders
Sales Summary
Measures
Order Quantity
Unit Price
Extended Amount
Standard Product Cost
Total Product Cost
Sales Amount
Tax Amount
Freight Cost
Transaction Count
Partitions
Total_Orders
Sales Orders
Measures
Order Count
Partitions
Total_Orders
Sales Targets
Measures
Sales Amount Quota
Partitions
Sales_Quotas
Perspectives
Mined Customers
Actions
Internet Details
Dimensions
Date
Ship Date
Delivery Date
Product
Promotion
Customer
Sales Reason
Sales Territory
Source Currency
Clustered Customers
Internet Sales Order Details
KPIs
Calculations
MdxScript
MeasureGroups
Internet Sales
Measures
Internet Sales Amount
Internet Order Quantity
Internet Extended Amount
Internet Tax Amount
Internet Freight Cost
Internet Unit Price
Internet Total Product Cost
Internet Standard Product Cost
Internet Transaction Count
Partitions
Internet Orders
Measures
Internet Order Count
Partitions
Internet Customers
Measures
Customer Count
Partitions
Sales Reasons
Measures
Sales Reason Count
Partitions
Perspectives
Dimensions
Clustered Customers
Attributes
Attribute Name
Customer Clusters
Node Unique Name
Hierarchies
Customer
Attributes
Customer
Postal Code
Country
State-Province
Birth Date
City
Date of First Purchase
Phone
Email Address
Yearly Income
Total Children
Number of Cars Owned
Number of Children At Home
Education
Occupation
Marital Status
Gender
Home Owner
Commute Distance
Commute Distance Sort
Address
Hierarchies
Customer Geography
Date
Attributes
Fiscal Year
Date
Calendar Quarter
Fiscal Quarter
Calendar Semester
Fiscal Semester
Day of Week
Day Name
Day of Month
Day of Year
Calendar Week
Month Name
Calendar Year
Fiscal Semester of Year
Calendar Semester of Year
Fiscal Quarter of Year
Calendar Quarter of Year
Month of Year
Fiscal Week
Calendar Week of Year
Fiscal Week of Year
Hierarchies
Fiscal
Calendar
Calendar Weeks
Fiscal Weeks
Employee
Attributes
Employee
Department Name
Sales Person Flag
Title
Hire Date
Sick Leave Hours
Birth Date
Vacation Hours
Login ID
Base Rate
Email Address
Pay Frequency
Phone
Salaried Flag
Emergency Contact Name
Emergency Contact Phone
Gender
Marital Status
Sales Territory Key
SSN
Manager SSN
Employees
Status
Start Date
End Date
Hire Year
Hierarchies
Employee Department
Geography
Attributes
City
State-Province
Country
Postal Code
Geography Key
Hierarchies
Geography
Internet Sales Order Details
Attributes
Internet Sales Order
Sales Order Number
Sales Order Line
Hierarchies
Internet Sales Orders
Product
Attributes
Product
Standard Cost
Category
Color
Safety Stock Level
Reorder Point
List Price
Size
Size Range
Weight
Days to Manufacture
Dealer Price
Class
Style
Model Name
Product Line
Subcategory
Status
Start Date
End Date
Large Photo
Hierarchies
Product Categories
Product Model Lines
Stock Level
Promotion
Attributes
Promotion
Discount Percent
Max Quantity
Promotion Type
Min Quantity
Promotion Category
End Date
Start Date
Hierarchies
Promotions
Reseller Sales Order Details
Attributes
Reseller Sales Order
Carrier Tracking Number
Customer PO Number
Sales Order Number
Sales Order Line
Hierarchies
Reseller Sales Orders
Reseller
Attributes
Reseller
Product Line
Phone
Last Order Year
Business Type
First Order Year
Number of Employees
Year Opened
Annual Sales
Annual Revenue
Bank Name
Min Payment Amount
Min Payment Type
Order Frequency
Order Month
Geography Key
Address
Hierarchies
Reseller Type
Reseller Bank
Reseller Order Frequency
Reseller Order Month
Sales Channel
Attributes
Sales Channel
Hierarchies
Sales Reason
Attributes
Sales Reason
Sales Reason Type
Hierarchies
Sales Reasons
Sales Summary Order Details
Attributes
Sales Order
Carrier Tracking Number
Customer PO Number
Sales Order Number
Sales Order Line
Hierarchies
Sales Orders
Sales Territory
Attributes
Sales Territory Region
Sales Territory Country
Sales Territory Group
Hierarchies
Sales Territory
Source Currency
Attributes
Source Currency Code
Source Currency
Hierarchies
Mining structures
Customer Mining
Customer Clusters
Customer Counts 1
Commute Distance
Education
Gender
Home Owner
Marital Status
Number of Cars Owned
Number of Children At Home
Occupation
Total Children
Yearly Income
Forecasting
Forecasting
Amount
Model Region
Quantity
Time Index
Market Basket
Association
Order Number
v Assoc Seq Line Items
Sequence Clustering
Sequence Clustering
Order Number
v Assoc Seq Line Items
Targeted Mailing
TM Decision Tree
Age
Bike Buyer
Commute Distance
Customer Key
Education
Occupation
Gender
House Owner Flag
Marital Status
Number Cars Owned
Number Children At Home
Region
Total Children
Yearly Income
TM Naive Bayes
Bike Buyer
Commute Distance
Customer Key
Education
Occupation
Gender
House Owner Flag
Marital Status
Number Cars Owned
Number Children At Home
Region
Total Children
Age
Roles
ALEN-PC\TABULAR2016
Server properties
AW Tabular Model SQL 2014
Connections
SqlServer localhost
Tables
Currency
Columns
RowNumber
CurrencyKey
Currency Code
CurrencyName
Measures
Hierarchies
Partitions
Currency
Customer
Columns
RowNumber
CustomerKey
GeographyKey
Customer Id
Title
First Name
Middle Name
Last Name
Name Style
Birth Date
Marital Status
Suffix
Gender
Email Address
Yearly Income
Total Children
Number of Children At Home
Education
Occupation
Owns House
Total Cars Owned
Address Line 1
Address Line 2
Phone
Date Of First Purchase
Commute Distance
Measures
Hierarchies
Partitions
Customer
Date
Columns
RowNumber
DateKey
Date
Day Number Of Week
Day Name Of Week
Day Of Month
Day Of Year
Week Of Year
Month Name
Month
Calendar Quarter
Calendar Year
Calendar Semester
Fiscal Quarter
Fiscal Year
Fiscal Semester
Measures
Days In Current Quarter to Date
Days In Current Quarter
Hierarchies
Calendar
Fiscal
Production Calendar
Partitions
Date
Employee
Columns
RowNumber
EmployeeKey
ParentEmployeeKey
Employee Id
SalesTerritoryKey
First Name
Last Name
Middle Name
NameStyle
Title
Hire Date
Birth Date
Login
Email
Phone
Marital Status
Emergency Contact Name
Emergency Contact Phone
Is Salaried
Gender
Pay Frequency
Base Rate
Vacation Hours
Sick Leave Hours
Is Current
Is Sales Person
Department Name
Start Date
End Date
Status
Employee Photo
Measures
Hierarchies
Partitions
Employee
Geography
Columns
RowNumber
GeographyKey
City
State Province Code
State Province Name
Country Region Code
Country Region Name
Postal Code
SalesTerritoryKey
Measures
Hierarchies
Geography
Partitions
Geography
Product
Columns
RowNumber
ProductKey
Product Id
ProductSubcategoryKey
Weight Unit Code
Size Unit Code
Product Name
Standard Cost
Is Finished Goods
Color
Safety Stock Level
Reorder Point
List Price
Size
Size Range
Weight
Days To Manufacture
Product Line
Dealer Price
Class
Style
Model Name
LargePhoto
Description
Product Start Date
Product End Date
Product Status
Product SubCategory Name
Product Category Name
Measures
Hierarchies
Category
Partitions
Product
Product Category
Columns
RowNumber
ProductCategoryKey
Product Category Name
Measures
Hierarchies
Partitions
Product Category
Product Subcategory
Columns
RowNumber
ProductSubcategoryKey
Product Subcategory Name
ProductCategoryKey
Measures
Hierarchies
Partitions
Product Subcategory
Promotion
Columns
RowNumber
PromotionKey
Promotion Name
DiscountPct
Promotion Type
Promotion Category
Promotion Start Date
Promotion End Date
Min Quantity
Max Quantity
Measures
Hierarchies
Partitions
Promotion
Reseller
Columns
RowNumber
ResellerKey
GeographyKey
Reseller Id
Reseller Phone
Business Type
Reseller Name
Number Employees
Order Frequency
Order Month
First Order Year
Last Order Year
Product Line
Address Line 1
Address Line 2
Annual Sales
Bank Name
Min Payment Type
Min Payment Amount
Annua Revenue
Year Opened
Measures
Hierarchies
Partitions
Reseller
Sales Territory
Columns
RowNumber
SalesTerritoryKey
Sales Territory Region
Sales Territory Country
Sales Territory Group
Sales Territory Image
Measures
Distinct Count Sales Orders
Total Sales
Total Discount Amount
Total Products Cost
Total Tax Amount
Total Freight
Total Gross Profit
Total Units Sold
Order Lines Count
Total Previous Quarter Gross Profit
Total Current Quarter Gross Profit
Total Previous Quarter Gross Profit Proportion to QTD
Total Previous Quarter Sales
Total Current Quarter Sales
Total Previous Quarter Sales Proportion to QTD
Total Sales - Sales Territory sliced by Employee
Total Current Quarter Sales Performance
Total Current Quarter Gross Profit Performance
Hierarchies
Territory
Partitions
Sales Territory
Internet Sales
Columns
RowNumber
ProductKey
OrderDateKey
DueDateKey
ShipDateKey
CustomerKey
PromotionKey
CurrencyKey
SalesTerritoryKey
Sales Order Number
Sales Order Line Number
Revision Number
Order Quantity
Unit Price
Extended Amount
Unit Price Discount Pct
Discount Amount
Product Standard Cost
Total Product Cost
Sales Amount
Tax Amount
Freight
Carrier Tracking Number
Customer PO Number
Order Date
Due Date
Ship Date
Gross Profit
Measures
Internet Distinct Count Sales Order
Internet Total Sales
Internet Total Discount Amount
Internet Total Product Cost
Internet Total Tax Amount
Internet Total Freight
Internet Total Gross Profit
Internet Total Units
Internet Order Lines Count
Internet Previous Quarter Gross Profit
Internet Current Quarter Gross Profit
Internet Previous Quarter Gross Profit Proportion to QTD
Internet Previous Quarter Sales
Internet Current Quarter Sales
Internet Previous Quarter Sales Proportion to QTD
Internet Current Quarter Sales Performance
Internet Current Quarter Gross Profit Performance
Hierarchies
Partitions
Internet Sales 2009
Internet Sales 2010
Internet Sales 2011
Internet Sales 2012
Internet Sales 2013
Internet Sales 2014
Product Inventory
Columns
RowNumber
ProductKey
DateKey
Movement Date
Unit Cost
Units In
Units Out
Units Balance
Product-Date Inventory Value
Product-Date Optimal Inventory Value
Product-Date Max Inventory Value
Product-Date OverStocked
Product-Date UnderStocked
Product-Date Negative Stock
Measures
Total Units In
Total Units Out
Total Units Movement
Total Units
Total Inventory Value
Total Inventory Optimal Value
Total Inventory Maximum Value
Total Inventory Value Performance
Products OverStocked
Products UnderStocked
Products with Negative Stock
Hierarchies
Partitions
Product Inventory 2005
Product Inventory 2006
Product Inventory 2007
Product Inventory 2008
Product Inventory 2009
Product Inventory 2010
Reseller Sales
Columns
RowNumber
ProductKey
OrderDateKey
DueDateKey
ShipDateKey
ResellerKey
EmployeeKey
PromotionKey
CurrencyKey
SalesTerritoryKey
Sales Order Number
Sales Order Line Number
Revision Number
Order Quantity
Unit Price
Extended Amount
Unit Price Discount Pct
Discount Amount
Product Standard Cost
Total Product Cost
Sales Amount
Tax Amount
Freight
Carrier Tracking Number
Reseller PO Number
Order Date
Due Date
Ship Date
Gross Profit
Measures
Reseller Distinct Count Sales Order
Reseller Total Sales
Reseller Total Discount Amount
Reseller Total Product Cost
Reseller Total Tax Amount
Reseller Total Freight
Reseller Total Gross Profit
Reseller Total Units
Reseller Order Lines Count
Reseller Previous Quarter Gross Profit
Reseller Current Quarter Gross Profit
Reseller Previous Quarter Gross Profit Proportion to QTD
Reseller Previous Quarter Sales
Reseller Current Quarter Sales
Reseller Previous Quarter Sales Proportion to QTD
Reseller Total Sales - Sales Territory sliced by Employee
Reseller Total Sales - Sales Territory sliced by Reseller
Reseller Current Quarter Sales Performance
Reseller Current Quarter Gross Profit Performance
Hierarchies
Partitions
Reseller Sales 2009
Reseller Sales 2010
Reseller Sales 2011
Reseller Sales 2012
Reseller Sales 2013
Reseller Sales 2014
Sales Quota
Columns
RowNumber
SalesQuotaKey
EmployeeKey
DateKey
Calendar Year
Calendar Quarter
Sales Amount Quota
Date
Measures
Hierarchies
Partitions
Sales Quota
Perspectives
Inventory
Internet Operation
Reseller Operation
Roles
Users
Admins
Analysts
Operators
SSRS
AdventureWorks Sample Reports 2012.rptproj
Reports
Company Sales.rdl
Parameters
EmbededImages
logoback
DataSources
AdventureWorks
DataSets
Sales
PageHeader
PageBody
SalesMatrix
Title
PageFooter
Customers_Near_Stores.rdl
Parameters
GeoLocation
Radius
ShowAll
EmbededImages
AdventureWorksLogo
ID20160607_132817
ID20160607_131946
DataSources
AdventureWorks
DataSets
CustomerLocations
StoreLocation
PageHeader
ReportName
tbBackInstructions
tbTitle
Rectangle1
Rectangle2
PageBody
tblxTable_Demographics
Tablix1
Rectangle3
Tablix2
Chart1
DataBar1
Sparkline1vds
Rectangle6
Rectangle7
PageFooter
tbDescription
Rectangle5
Employee_Sales_Summary.rdl
Parameters
ReportMonth
ReportYear
EmployeeID
ShowAll
ExpandAllTableRows
CategoryQuota
EmbededImages
AdventureWorksLogo
DataSources
AdventureWorks
DataSets
EmployeeSalesYearOverYear
EmployeeSalesDetail
EmpSalesMonth
SalesEmployees
CategoryQuotas
PageHeader
ReportName
Textbox5
PageBody
tbToggle
tbScenarioText
Rectangle1
ParameterValues
DataSourceandDatasets
rectCharts
tbChartPurpose
Chart1
Tablix1
rectMatrix
tbChartPurpose2
Tablix2
Textbox21
tbMatrixQuotas
tbCategoryQuotas
Textbox21
tbMatrixQuotas
tbCategoryQuotas
rectSeasonalSales
Chart2
Tablix3
tbChartPurpose3
PageFooter
tbDescription
Product Catalog.rdl
Parameters
EmbededImages
cover4
logopart
logofull
cover3
cover2
cover1
DataSources
AdventureWorks
DataSets
ProductCatalog
PageHeader
PageBody
ProductTable
Title
PageFooter
FooterBanner
PageNumber
OrderOnline
Product Line Sales.rdl
Parameters
ProductCategory
ProductSubcategory
StartDate
EndDate
EmbededImages
tires
wholelogolft_lowres
DataSources
AdventureWorks
DataSets
TopEmployees
ProductCategories
TopCustomers
ProductSubcategories
PageHeader
PageBody
TopEmployees
TopEmployeesTable
TopEmployeesChart
DateRange
Banner
BannerLeft
TopEmployeesHeader
CategorySelection
TopStores
TopStoresHeader
TopStoresTable
TopStoresChart
PageFooter
FooterDate
FooterCompany
FooterURL
Sales Order Detail.rdl
Parameters
SalesOrderNumber
EmbededImages
logofull
DataSources
AdventureWorks
DataSets
SalesOrder
SalesOrderDetail
PageHeader
PageBody
OrderDetail
OrderHeader
OrderNumber
Title
BillToAddress1
BillToPostalCode
BillToCity
ShipMethod
CustomerPhone
ShipToRegion
SalesPersonLabel
SalesPerson
ShipToPostalCode
BillToLabel
ShipToCity
OrderDateLabel
ShipMethodLabel
CustomerName
CurrentDate
CurrentDateLabel
ShipToAddress1
OrderDate
BillToRegion
ShipToLabel
PurchaseOrder
PurchaseOrderLabel
BillToStore
ShipToStore
BillToStateProvince
ShipToStateProvince
ContactLabel
PageFooter
Sales Reason Comparisons.rdl
Parameters
ProductCategory
EmbededImages
logopart_xs
DataSources
AdventureWorksAS
DataSets
ProductData
ProductList
PageHeader
PageBody
matrix1
textbox1
PageFooter
Sales_by_Region.rdl
Parameters
Distance
ShowBingMaps
BingMapTileType
USStatesTransparency
ShowAll
EmbededImages
AdventureWorksLogo
DataSources
AdventureWorks
DataSets
IndividualCustomerSales
StoreSales
StoreSaleTotals
PageHeader
ReportName
PageBody
tbToggle
tbScenarioText
Tablix1
rectStoresbyState
tblxMatrix_StoresbyState
tbStoresbyStateLabel
PageFooter
tbDescription
Store_Contacts.rdl
Parameters
StoreID
ShowAll
EmbededImages
AdventureWorksLogo
DataSources
AdventureWorks
DataSets
StoreContacts
Stores
PageHeader
ReportName
PageBody
tblxContactInformation
PageFooter
tbDescription
Territory Sales Drilldown.rdl
Parameters
EmbededImages
logofull
DataSources
AdventureWorks
DataSets
TerritorySales
PageHeader
PageBody
SalesTable
Title
PageFooter
Datasets
DataSet1.rsd
EmployeeSalesDetail.rsd
EmployeeSalesYearOverYear.rsd
EmpSalesMonth.rsd
SalesEmployees.rsd
Datasources
AdventureWorks.rds
AdventureWorksAS.rds
DataSource1.rds
DataSource2.rds
DataSource3.rds
AdventureWorks.rds
Company Sales.rdl
Parameters
EmbededImages
logoback
DataSources
AdventureWorks
DataSets
Sales
PageHeader
PageBody
SalesMatrix
Title
PageFooter
Dictionary
2002
2003
2004
AccountNumber
ACTION
ACTION_NAME
ActiveFlag
ActualCost
ActualEndDate
ActualResourceHrs
ActualStartDate
AdditionalContactInfo
Addr.Loc.City
Addr.Loc.CountryRegion
Addr.Loc.State
Addr.PostalCode
Addr.Type
AddressID
AddressLine1
AddressLine2
AddressType
AddressTypeID
AFFECTED_ROWS
aggregate
Analyze
AnnualRevenue
AnnualSales
APP_NAME
APPLICATION
asOf
AUDIT_ACTION_ID
AUDIT_LOG_DATA_ID
AUDIT_LOG_TRANSACTION_ID
Availability
AverageLeadTime
AverageRate
BankName
BikeFrame
BillOfMaterialsID
BillToAddressID
Bin
BirthDate
BOMLevel
Bonus
Brands
BusinessEntityID
BusinessType
CardNumber
CardType
CarrierTrackingNumber
CatalogDescription
Category
ChangeNumber
CheckDate
City
Class
COL_NAME
Color
Comment
Comments
CommissionPct
ComponentID
COMPUTER
ContactType
ContactTypeID
Copyright
CostLastYear
CostRate
CostYTD
CountryRegion
CountryRegionCode
CountryRegionName
Crankset
CreditCardApprovalCode
CreditCardID
CreditCardNumber
CreditRating
CultureID
CurrencyCode
CurrencyRateDate
CurrencyRateID
CurrentFlag
CustomerID
DATA_TYPE
DATABASE
Database Version
DatabaseLogID
DatabaseUser
DATE_FROM
DATE_TO
DateCreated
DateFirstPurchase
DaysToManufacture
DDL
ddl_report
Delete
DELETE_ALL
Demographics
Department
DepartmentID
Description
DESCRIPTION
Diagram
DiscontinuedDate
DiscountPct
Document
DocumentLevel
DocumentNode
DocumentSummary
DueDate
Edu.Degree
Edu.EndDate
Edu.GPA
Edu.GPAScale
Edu.Level
Edu.Loc.City
Edu.Loc.CountryRegion
Edu.Loc.State
Edu.Major
Edu.Minor
Edu.School
Edu.StartDate
Education
EMail
EmailAddress
EMailAddress
EmailAddressID
EmailPromotion
EMailSpecialInstructions
EMailTelephoneNumber
Emp.EndDate
Emp.FunctionCategory
Emp.IndustryCategory
Emp.JobTitle
Emp.Loc.City
Emp.Loc.CountryRegion
Emp.Loc.State
Emp.OrgName
Emp.Responsibility
Emp.StartDate
EmployeeID
EndDate
EndOfDayRate
EndTime
ErrorLine
ErrorLogID
ErrorMessage
ErrorNumber
ErrorProcedure
ErrorSeverity
ErrorState
ErrorTime
Event
EventDateTime
EventDetails
EventName
ExpMonth
ExpYear
FileExtension
FileName
FinishedGoodsFlag
FirstName
FolderFlag
Freight
FromCurrencyCode
FullName
Gender
Group
GroupByACTION
GroupByAPPLICATION
GroupByCOMPUTER
GroupByDate
GroupByMODIFIED_BY
GroupByTableName
GroupName
hex
HireDate
HomeAddressSpecialInstructions
HomeOwnerFlag
HOST_NAME
Identity
IllustrationID
index
Instructions
Internet
IsOnlyStateProvinceFlag
items_per_order
JobCandidateID
JobTitle
KEY1
KEY2
KEY3
KEY4
LaborHours
language
LargePhoto
LargePhotoFileName
LastName
LastReceiptCost
LastReceiptDate
LineTotal
ListPrice
LocalID
LocationID
LogId
LoginID
LotSize
MachineHours
MaintenanceDescription
MakeFlag
Manufacturer
MaritalStatus
Material
MAX_ROWS
MaxOrderQty
MaxQty
MiddleName
MinOrderQty
MinQty
MODIFIED_BY
MODIFIED_DATE
ModifiedDate
Name
Name.First
Name.Last
Name.Middle
Name.Prefix
Name.Suffix
NameStyle
NationalIDNumber
NEW_VALUE
NEW_VALUE_BLOB
NEW_VALUE_LONG
NoOfYears
NumberCarsOwned
NumberChildrenAtHome
NumberEmployees
Object
OBJECT_NAME
OBJECT_TYPE
Occupation
OLD_VALUE
OLD_VALUE_LONG
OLDER_THAN
OLDER_THAN_TYPE
OnlineOrderFlag
OnOrderQty
OperationSequence
OrderDate
OrderID
OrderQty
OrderTrackingID
OrganizationLevel
OrganizationNode
Owner
PasswordHash
PasswordSalt
PayFrequency
Pedal
PerAssemblyQty
PersonID
PersonType
PhoneNumber
PhoneNumberType
PhoneNumberTypeID
PictureAngle
PictureSize
PlannedCost
PostalCode
PostTime
PreferredVendorStatus
Primary
PRIMARY_KEY
PRIMARY_KEY_DATA
ProductAssemblyID
ProductCategoryID
ProductDescriptionID
ProductID
ProductLine
ProductModel
ProductModelID
ProductNumber
ProductPhotoID
ProductReviewID
ProductSubcategoryID
ProductURL
PurchaseOrderDetailID
PurchaseOrderID
PurchaseOrderNumber
PurchasingWebServiceURL
purge
Quantity
QuotaDate
Rate
RateChangeDate
Rating
ReasonType
REC_COUNT
ReceivedQty
ReferenceOrderID
ReferenceOrderLineID
RejectedQty
RemoveServer
ReorderPoint
Resume
ReviewDate
ReviewerName
Revision
RevisionNumber
RiderExperience
ROW_COUNT
rowguid
Saddle
SafetyStockLevel
SalariedFlag
SalesLastYear
SalesOrderDetailID
SalesOrderDetails
SalesOrderID
SalesOrderNumber
SalesPersonID
SalesQuota
SalesReasonID
SalesTaxRateID
SalesTerritory
SalesYTD
ScheduledEndDate
ScheduledStartDate
Schema
SCHEMA
ScrappedQty
ScrapReasonID
searchString
SellEndDate
SellStartDate
SetupHours
Shelf
Shift
ShiftID
ShipBase
ShipDate
ShipMethodID
ShipRate
ShipToAddressID
ShoppingCartID
ShoppingCartItemID
SickLeaveHours
Size
SizeUnitMeasureCode
Skills
SpatialLocation
SpecialOfferID
Specialty
SquareFeet
SSN
standard
StandardCost
StandardPrice
StartDate
StartProductID
StartTime
StateProvince
StateProvinceCode
StateProvinceID
StateProvinceName
Status
Step
StockedQty
StoreID
Street
string
Style
SubTotal
Suffix
Summary
SYSOBJ_ID
SystemInformationID
TABLE_NAME
TABLE_SCHEMA
TaxAmt
TaxRate
TaxType
TelephoneNumber
TelephoneSpecialInstructions
TerritoryGroup
TerritoryID
TerritoryName
Test column
Test column 3
Test column2
ThumbNailPhoto
ThumbnailPhotoFileName
Title
ToCurrencyCode
TotalChildren
TotalDue
TotalPurchaseYTD
TrackingEventID
TransactionDate
TransactionID
TransactionType
TSQL
Type
undo
UnitMeasureCode
UnitPrice
UnitPriceDiscount
useInflectional
UserName
useThesaurus
VacationHours
ValidFrom
ValidTo
value
Value
var
VendorID
VersionDate
View
WarrantyDescription
WarrantyPeriod
WebSite
Weight
WeightUnitMeasureCode
Wheel
WHERE
WorkOrderID
XmlEvent
YearlyIncome
YearOpened
About this documentation