Package: QueryActivityUpload

CollapseAll image

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 System variables


No items exist
 Name   Description 

Collapse image See also


Package index