Package: QueryActivityUpload

CollapseAll image

Collapse image Properties


 Name   Value 
CertificateContext 0
CertificateObject  
CheckpointFileName  
CheckpointUsage Never
CheckSignatureOnLoad True
CreationDate 7/10/2007 4:27:11 PM
CreationName Microsoft.Package
CreatorComputerName  
CreatorName  
DebugMode False
DelayValidation True
Description  
DesignEvents  
DesignTimeProperties  
Disable False
DisableEventHandlers False
DumpDescriptor  
DumpOnAnyError False
EnableConfigurations True
EnableDump True
EncryptCheckpoints False
ExecutionDuration 0
ExecutionResult Success
ExecutionStatus None
FailPackageOnFailure False
FailParentOnFailure True
ForcedExecutionValue 0
ForceExecutionResult None
ForceExecutionValue False
HasExpressions False
ID {833DB628-8E19-47A3-92C5-FB1779B52E76}
IgnoreConfigurationsOnLoad False
InteractiveMode False
IsDefaultLocaleID False
IsolationLevel Serializable
LastModifiedProductVersion 13.0.200.2131
LocaleID English (United States)
LoggingMode Enabled
MaxConcurrentExecutables -1
MaximumErrorCount 1
Name QueryActivityUpload
OfflineMode False
PackageFormatVersion 8
PackageLocation dtsserver:MSDB\Data Collector\QueryActivityUpload
PackagePath MSDB\Data Collector\QueryActivityUpload
PackagePriorityClass Default
PackageServerName ALEN-PC
PackageStorageType MsSql
PackageType DTSDesigner100
ProtectionLevel EncryptSensitiveWithUserKey
SafeRecursiveProjectPackageExecution False
SaveCheckpoints False
SQLFolder \
SuppressConfigurationWarnings False
SuspendRequired False
TransactionOption Supported
UpdateObjects False
UpdatePackage True
VersionBuild 347
VersionComments  
VersionGUID {A6F7BA9C-B80D-4942-9733-2CC3AC1D1111}
VersionMajor 1
VersionMinor 0

Collapse image Configuration settings


 Name   Description 
CacheDirectory  
CacheWindow  
CollectionSetUID  
CollectorTypeUID  
ConfigConnectionString  
DaysUntilExpiration  
ExitEventName  
InputParameters  
InstanceID  
InstanceName  
ItemID  
LoggingLevel  
LogID  
LoopEventName  
MDWConnectionString  
ParentLogID  
TargetConnectionString  

Collapse image Connection managers


 Name   Description 
ConfigConnection Connection used to get information about collection configuration and for logging purposes.
ConfigConnection2  
MdwConnection Connection used to upload collected data to a warehouse.
TargetConnection Connection used to get information from the monitored (target) instance.

Collapse image Executables


 Name   Description 
CWM - Remove Upload Snapshots Older Than CacheWindow Cache Window Maintainance Task
FAT - Check Cache File Exists File Access Task
FEF - For each collected cache file try upload Foreach Loop Container
SEQ - Capture and analyze query statistics and query plan and text Sequence Container
SEQ - Rename Collection Cache File Sequence Container
SQL - Get SnapshotId Execute SQL Task
SQL - Get SourceId Execute SQL Task

Collapse image Log entry information


 Name   Description 
Diagnostic Logs package diagnostics information, e.g. maximum concurrent executables
DiagnosticEx Logs more information on package execution with XML format

Collapse image Precedence constraints


 Name   Description 
Constraint  
Constraint 12  
Constraint 3  
Constraint 6  
Constraint 7  
Constraint 8  

Collapse image User defined variables


 Name   Description 
CacheDirectory  
CacheWindow  
CollectionCacheFileName Stores snapshots of dm_exec_requests
CollectionCacheFileNameOutput Stores snpashots of dm_exec_requests. This variable is used as temporary cached file name during the upload.
CollectionCacheFilePrefixPattern Prefix for files related to dm_exec_requets collection
CollectionSetUID  
CollectorTypeUID  
ConfigConnectionString  
DaysUntilExpiration  
ExitEventName  
InputParameters  
InstanceID  
InstanceName  
InterestingQueries_HighCpuUsage  
InterestingQueries_HighIoCount  
InterestingQueries_HighMemoryUsage  
InterestingQueries_HighTransactionCount  
InterestingQueries_LargeResultset  
InterestingQueries_LongRunningRequest  
InterestingQueries_LongWaitingRequest  
InterestingQueriesCount  
InterestingQueriesLastSnapshotFileName Stores the most recent copy of snapshot of dm_exec_query_stats saved from the previous execution of this package.
InterestingQueriesLastSnapshotFileNameOutput Stores temporary copy of the most recent snapshot of dm_exec_query_stats
InterestingQueriesSnapshotFileNamePrefixPattern Prefix for files related to dm_exec_query_stats collection.
ItemID  
LoggingLevel  
LogID  
LoopDuration  
LoopEventName  
MDWConnectionString  
ParentLogID  
SnapshotId  
SnapshotQueryStatsQuery  
SourceId  
TargetConnectionString  
TopThreshold  

Collapse image See also


Package index