patternsqlMinor
Packages in Data Collector folder
Viewed 0 times
packagesdatafoldercollector
Problem
What are those in the Data Collector folder ? I tried to delete some and got the message that it was conflicting with some reference.
Solution
Those packages are related to Management Data Warehouse.
If you open SQL Server Management Studio you will find a node 'Data Collection' where you can right click to configure data collection and also have access to some historical reports about server activity.
Have a look at System Data Collection Sets where for example it states:
The Query Activity collector type collects data by using the
QueryActivityCollect.dtsx SSIS package, and uploads data by using the
QueryActivityUpload.dtsx SSIS package.
For more information see Data Collector Architecture and Processing.
I'm not sure how you got to a point where you get 2 versions of each package (where one is appended by (1)). I tried reproducing that by enabling/disabling collection or creating a new MDW but maybe you got into that state by upgrading and then re-enabling data collection or something.
If you open SQL Server Management Studio you will find a node 'Data Collection' where you can right click to configure data collection and also have access to some historical reports about server activity.
Have a look at System Data Collection Sets where for example it states:
The Query Activity collector type collects data by using the
QueryActivityCollect.dtsx SSIS package, and uploads data by using the
QueryActivityUpload.dtsx SSIS package.
For more information see Data Collector Architecture and Processing.
I'm not sure how you got to a point where you get 2 versions of each package (where one is appended by (1)). I tried reproducing that by enabling/disabling collection or creating a new MDW but maybe you got into that state by upgrading and then re-enabling data collection or something.
Context
StackExchange Database Administrators Q#151001, answer score: 5
Revisions (0)
No revisions yet.