32/23/2007 1:06:13 PM512010303{D2FA353E-8BAA-478A-A991-C45331F770BE}-10000ConfigConnection{2AEF0133-FEA0-472B-B12D-89F60FF1CBCD}Connection used to get information about collection configuration and for logging purposes.OLEDB@[User::ConfigConnectionString]0Data Source=(local);Initial Catalog=msdb;Provider=SQLNCLI10;Integrated Security=SSPI;APP=SQL Server Data Collector;0MdwConnection{68AAF105-9266-4AA6-A164-CD0A512B42D3}Connection used to upload collected data to a warehouse.OLEDB@[User::MDWConnectionString]-1Data Source=(local);Initial Catalog=MDW;Provider=SQLNCLI10;Integrated Security=SSPI;APP=SQL Server Data Collector;0TargetConnection{132C9722-DFF5-4B1E-8335-113AB9B72B8B}Connection used to get information from the monitored (target) instance.OLEDB@[User::TargetConnectionString]-1Data Source=(local);Provider=SQLNCLI10;Integrated Security=SSPI;APP=SQL Server Data Collector;0User::CacheDirectory\Package.Variables[User::CacheDirectory].Properties[Value]CacheDirectory{767DBF63-6589-4A47-92B6-83B7FE6C3F88}0User::CacheWindow\Package.Variables[User::CacheWindow].Properties[Value]CacheWindow{8F817CE9-10DB-45C1-9F64-78474C992FAA}0User::InputParameters\Package.Variables[User::InputParameters].Properties[Value]InputParameters{10D13CA8-84F9-41CF-A09D-8D3158B0243B}0User::MDWConnectionString\Package.Variables[User::MDWConnectionString].Properties[Value]MDWConnectionString{28F4286B-9D00-4269-AC22-C247150E220B}0User::ConfigConnectionString\Package.Variables[User::ConfigConnectionString].Properties[Value]ConfigConnectionString{6893D265-3DAF-4111-9601-754CB28CF15D}0User::TargetConnectionString\Package.Variables[User::TargetConnectionString].Properties[Value]TargetConnectionString{D425A728-7408-4EE7-993B-46EFDC11947F}0User::LoopEventName\Package.Variables[User::LoopEventName].Properties[Value]LoopEventName{B1E74B02-0F02-41C7-A9D7-7612EADE9BD4}0User::ExitEventName\Package.Variables[User::ExitEventName].Properties[Value]ExitEventName{9ADFDA9C-89B3-460E-83EC-C123E92768AC}0User::CollectorTypeUID\Package.Variables[User::CollectorTypeUID].Properties[Value]CollectorTypeUID{E6BB8D08-A42F-480E-B74D-5764B102E229}0User::CollectionSetUID\Package.Variables[User::CollectionSetUID].Properties[Value]CollectionSetUID{E6AB7F85-7160-4A06-A6AF-7A845BDED62B}0User::ItemID\Package.Variables[User::ItemID].Properties[Value]ItemID{333F5E0C-65B8-4430-8E6B-014393E50641}0User::InstanceID\Package.Variables[User::InstanceID].Properties[Value]InstanceID{3630A5D4-5D8A-4717-8F10-9287946862DC}0User::InstanceName\Package.Variables[User::InstanceName].Properties[Value]InstanceName{AFA614B3-B990-404B-8186-7238F5089A5B}0User::LoggingLevel\Package.Variables[User::LoggingLevel].Properties[Value]LoggingLevel{710AD3B8-3D9A-4ACA-A0AD-C95665519570}0User::LogID\Package.Variables[User::LogID].Properties[Value]LogID{D88542C7-EBB5-4A03-87BB-DF54B345A295}0User::ParentLogID\Package.Variables[User::ParentLogID].Properties[Value]ParentLogID{90B244E1-CD1E-483B-AE10-D2E0C1319450}0User::DaysUntilExpiration\Package.Variables[User::DaysUntilExpiration].Properties[Value]DaysUntilExpiration{F2ABCCBA-9B7C-4C1E-B5C5-A52ACE6475C3}10.0.1101.000-100-10104857610331-1@[User::CacheDirectory] + "\\" + @[User::InstanceID] + "_" + @[User::CollectionSetUID] + "_" + (DT_WSTR, 255) @[User::ItemID] + ".csv"0User00C:\DOCUME~1\apred\LOCALS~1\Temp\eKatmai_DCCacheDirectory{4C443096-5A0D-4CB6-BD3F-6610BE9905E8}@[User::CacheDirectory] + "\\" + @[System::MachineName] + "_" + @[User::InstanceID] + "_" + @[User::CollectionSetUID] + "_" + (DT_WSTR, 255) @[User::ItemID] + ".cache"-1User00C:\DOCUME~1\apred\LOCALS~1\Temp\eKatmai_DC\AHMEDAY03_MSSQL.1_640012b7-4ed0-4865-a636-4946d73c425f_0.cacheCacheFileName{63E3032E-054F-412B-B853-7538BDAAFE3B}@[User::CacheDirectory] + "\\"+ @[User::CacheUploadFilesPrefixPattern] + REPLACE( REPLACE( (DT_WSTR, 40) GETDATE(), " ", "-" ), ":", "-" ) + ".cache" -1User00C:\DOCUME~1\apred\LOCALS~1\Temp\eKatmai_DC\AHMEDAY03_MSSQL.1_640012b7-4ed0-4865-a636-4946d73c425f_0_upload_copyat_2008-01-29-11-41-21.190000000.cacheCacheOutput{940C99E7-EF6F-40B0-982C-9553759C2414}@[System::MachineName] + "_" + @[User::InstanceID] + "_" + @[User::CollectionSetUID] + "_" + (DT_WSTR, 255) @[User::ItemID] + "_upload_copyat_" -1User00AHMEDAY03_MSSQL.1_640012b7-4ed0-4865-a636-4946d73c425f_0_upload_copyat_CacheUploadFilesPrefixPattern{F81B33AE-4244-4889-BF12-8E6BFB11030F}0User001CacheWindow{F220B51D-1FFB-4003-9EC0-2285752F310B}0User00640012b7-4ed0-4865-a636-4946d73c425fCollectionSetUID{D0868A36-C135-49D0-A8F1-13542A84B573}0User00294605dd-21de-40b2-b20f-f3e170ea1ec3CollectorTypeUID{CBF24B5A-C8CF-48E8-9509-D3204867FCC7}0User00Provider=SQLNCLI10;Data Source=(local);Integrated Security=SSPI;Initial Catalog=msdb;APP=SQL Server Data CollectorConfigConnectionString{F04807FB-804D-4425-81AF-F7CB457826A5}0User000DaysUntilExpiration{888B7540-0785-4F57-A56D-D58BBF911921}0User00EXITEVENTExitEventName{E3526FDC-CCDB-4346-8948-14B54720A63F}0User00InputParameters{EE554175-B0CA-4786-AFB9-D0253F3C39A6}0User00MSSQL.1InstanceID{C0E00118-2CAF-4F3C-9E53-A1E2CE30AB7C}0User00(local)InstanceName{38EFEA28-38F1-4ED1-8DBC-AAB0E2265EE5}0User000ItemID{39074E00-5D29-4CBF-9105-C3A346061C04}0User002LoggingLevel{E15C61FE-2988-4503-8A17-1F01F9D5E2D4}0User000LogID{98D987AA-CF36-4316-933A-05D4B96743E5}0User00LOOPEVENTLoopEventName{CEFF4763-688B-466E-A1E7-E290014294EF}0User00Provider=SQLNCLI10;Data Source=(local);Integrated Security=SSPI;Initial Catalog=MDW;APP=SQL Server Data CollectorMDWConnectionString{7017ED52-3782-4E8C-9165-776BD4BF407F}0User000ParentLogID{7012C6A3-A799-452D-A88F-F82FEBE5B864}0User006SnapshotID{C51017D6-9981-46D1-8375-EBCE6B57EC9C}0User000SourceID{82A4097B-17D7-4B24-B70A-D548BA812BC8}0User00Provider=SQLNCLI10;Data Source=(local);Integrated Security=SSPI;APP=SQL Server Data CollectorTargetConnectionString{0EA15FE2-50C0-41A8-AD04-B859D38EA993}102,7,OnError,9,OnWarning-1-1-1-1-1-1-1-1-1-1-1-1-1-100-100001048576-11-10User00PerfCountersLockSyncRoot{A0DA22EB-F905-466C-B115-716E3F49FA5D}200File Access;Microsoft Corporation; Microsoft SQL Server codename Katmai; (C) 2007 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;100-100011048576-11001@[User::CacheFileName]0FAT - Check Current Cache File Exists{B737D089-54D7-40A4-9F46-A1B8AA87FF57}File Access TaskDTS.FileAccessTask.100C:\DOCUME~1\apred\LOCALS~1\Temp\eKatmai_DC\AHMEDAY03_MSSQL.1_640012b7-4ed0-4865-a636-4946d73c425f_0.cache0File System Task;Microsoft Corporation; Microsoft SQL Server v9; © 2004 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;100-100001048576-11-120FST - Rename Current Cache File{609f9d36-aad4-4395-8b31-0c27b6ffefdd}File System TaskMicrosoft.SqlServer.Dts.Tasks.FileSystemTask.FileSystemTask, Microsoft.SqlServer.FileSystemTask, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91002-1Constraint{B5B398D6-E5AB-4742-ABD1-AD95B984F0AF}Sequence Container{A7035C8A-5219-42B8-BDE6-365F3240D4B2}Sequence ContainerSTOCK:SEQUENCE00Execute SQL Task; Microsoft Corporation; Microsoft SQL Server v9; © 2004 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;100-100-101048576-11-120SQL - Register collection set to MDW{a3667210-4432-41f0-8d04-d53b10574f52}Execute SQL TaskMicrosoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ExecuteSQLTask, Microsoft.SqlServer.SQLTask, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc9100Execute SQL Task; Microsoft Corporation; Microsoft SQL Server v9; © 2004 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;100-100-101048576-11-120SQL - Create snapshot ID in MDW{02641DDC-5CDC-4BD2-8112-1FA7BE3A488C}Execute SQL TaskMicrosoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ExecuteSQLTask, Microsoft.SqlServer.SQLTask, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc9100Cache Window Maintainance Task; Microsoft Corporation; Microsoft SQL Server v10; © 2007 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;100-100001048576-11-10User000LoopDuration{7EDAF031-506D-45CA-A56C-7597EB330B4C}20"User::CacheUploadFilesPrefixPattern"CWM - Delete Old Cache Files{884A53D3-672D-42BF-A6D4-A96E27430985}Cache Window Maintainance TaskMicrosoft.SqlServer.Management.Collector.Tasks.CacheWindowMaintainanceTask, Microsoft.SqlServer.Management.CollectorTasks, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc910{EE8E4F57-1623-455B-B0B2-ABCCA165FFB5}{EE8E4F57-1623-455B-B0B2-ABCCA165FFB5}DTS.ForEachFileEnumerator.2@[User::CacheDirectory]@[User::CacheUploadFilesPrefixPattern] + "*.cache"100-100-101048576-11-10User00c:\perflogs\MACIES4_MSSQL.1_640012b7-4ed0-4865-a636-4946d73c425f_0.cacheCacheFileToUpload{F36AAF41-4971-4431-B175-E6DEE50CE8A6}DATEDIFF("ms", @[System::ContainerStartTime], GETDATE())-1User0093210LoopDuration{F7E27146-0A15-485B-8BD1-9A4327B9CEF6}0User000RowCountError{05DBC8DD-D393-4E0E-8A8D-97EC37B1C527}0User000RowCountIn{F5DD1F52-8D07-4E99-8435-35B4ECBBE28A}0User000RowCountOut{A3990693-0E65-44C7-BF35-1AD1F08EDCB0}@[User::RowCountOut] - @[User::RowCountError]-1User000RowCountOutFinal{03FCCBFD-6016-428F-A0DF-294876A9D2B1}200Performs high-performance data extraction, transformation and loading;Microsoft Corporation; Microsoft SQL Server v10; (C) 2007 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;100-100-101048576-11-120DFT - Update perf_counters_instances table with newly discovered instances{E24F9238-4DE6-4DFE-97B9-35990020B45A}Data Flow TaskSSIS.Pipeline.201User::CacheFileToUpload

0[snapshots].[performance_counter_instances]1252false3falsefalse1000

0Performs high-performance data extraction, transformation and loading;Microsoft Corporation; Microsoft SQL Server v9; (C) 2004 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;100-100-101048576-11-120DFT - Bulk Insert Collected data into MDW{E0D31BC6-173F-4DB9-BBD1-941BFE618005}Data Flow TaskSSIS.Pipeline.20User::RowCountIn

1User::CacheFileToUpload

SELECT path, performance_counter_id FROM snapshots.performance_counter_instancesSELECT [path], [performance_counter_id] FROM [snapshots].[performance_counter_instances] WHERE [path] = ?055<referenceMetadata><referenceColumns><referenceColumn name="path" dataType="DT_WSTR" length="2048" precision="0" scale="0" codePage="0"/><referenceColumn name="performance_counter_id" dataType="DT_I4" length="0" precision="0" scale="0" codePage="0"/></referenceColumns></referenceMetadata>#1860;1252010path

performance_counter_id

@[User::SnapshotID]@[User::SnapshotID](DT_DBTIMESTAMP2,1)#1858(DT_DBTIMESTAMP2,1)collection_time

User::RowCountOut

User::RowCountError

0[snapshots].[performance_counter_values]1252false3falsefalseCHECK_CONSTRAINTS1000

0File System Task;Microsoft Corporation; Microsoft SQL Server v9; © 2004 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;100-100001048576-11-120FST - Cleanup{2665570b-6fcf-43a3-b8ba-5f3d5bd99357}File System TaskMicrosoft.SqlServer.Dts.Tasks.FileSystemTask.FileSystemTask, Microsoft.SqlServer.FileSystemTask, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc9100Execute SQL Task; Microsoft Corporation; Microsoft SQL Server code name "Katmai"; © 2007 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;100-100011048576-11000SQL - Log Package Stats{CD4E0504-1536-4071-A070-9A7D8A6D7B32}Execute SQL TaskMicrosoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ExecuteSQLTask, Microsoft.SqlServer.SQLTask, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91022-1Constraint 2{96006738-B053-493C-95AD-64168C63BA4C}02-1Constraint 1{649D8163-D3B7-4998-A29D-ABDE0EAAEA77}23-1@[User::LoggingLevel] >= 1Constraint{17CA7F5E-10A1-41B3-9F5F-FD4CCB15FB8D}FEF - For Each Collected Cache File Remaining, Try to Upload{2B763872-7CE3-4CFF-88F9-5A1EDFA05BC8}Foreach Loop ContainerSTOCK:FOREACHLOOP0User::CacheFileToUpload0{EF918497-3946-428A-9BF3-D32E69048E5A}{EF918497-3946-428A-9BF3-D32E69048E5A}22-1Constraint 2{3E8C2FDE-1E6D-4C61-A58B-D114921193FC}02-1Constraint 3{E0BDAD4D-63EC-4C7B-B392-48D799204549}02-1Constraint 5{766AFD21-4197-496F-90A8-2C9B25E85D3C}02-1Constraint 4{5B5E777C-2E3A-453F-91F2-6E28C7BC6B13}PerfCountersUpload{08D854CB-0D45-4E96-92C6-227A5DCD7066}SSIS.Package.20