We have released the “Test Attachment Cleaner” powertool on Visual Studio Gallery today.
In Visual Studio 2010, with the introduction of Visual Studio Test Professional 2010 & Visual Studio Premium/Ultimate 2010 SKUs, testers can author manual and automated Test cases, configure the different diagnostic data collectors (as part of Test Settings), associate the Test Settings with Test Plan/Suites and then execute these test cases as part of Test Runs. The execution of a Test Run (whether automated or manual) generates a bunch of diagnostic data, which may be captured either automatically by the system or manually by the tester. This diagnostic data is critical in eliminating the “no repro” bug scenarios between the testers and developers.
However, the downside of this rich diagnostic data captures is that the system/user generated diagnostic data, over a period of time, can grow at a rapid pace and start taking up database space. With Visual Studio 2010, the database administrator has little or no control over what data gets attached as part of Test Runs – i.e., there are no policy settings he can control to limit the size of the data capture OR no retention policy to determine how long to hold this data before initiating a cleanup. In such scenarios, the Admin has no mechanism to:
1. Determine which set of diagnostic captures is taking up how much space AND
2. Reclaim the space for runs which are no longer relevant from business perspective.
The “Test Attachment Cleaner” powertool fills this void by serving both the above points.
The Test Attachment Cleaner is a command line powertool (tcmpt.exe attachmentcleanup), which accepts the following parameters:
Sample Setting files for core scenarios:
As part of the package, sample setting files are provided which cater to the following 5 core scenarios. The readme document contains additional details around the different knobs used within the sample setting files.
Scenario#1: Identify list of attachments taking up database space of more than 1 GB per attachment
Scenario#2: View/Delete IntelliTrace log files over a size of 500 MB
Scenario#3: View/Delete all Video log files with Test run creation date older than specific date with no active bugs
Scenario#4: View/Delete all TRX & COV log files for test runs that happened between 30 and 90 days in age & do not perform the Linked Bugs lookup query
Scenario#5: View/Delete all custom/user attachments over size of 5 MB with no active or resolved bugs on test runs between 2 dates