Test management warehouse: Improve deletion performance

Last week we received a complaint from an internal customer that the test management warehouse adapter is taking a lot of time to process the data. Dhruv took a look at the problem and found that it is slow because the indexes on the test management tables (FactTestResult, DimTestResult, DimTestRun) is highly fragmented. When he…

0

How to find test points assigned to a particular person

Here is a code snippet which you can use to find test points assigned to a particular person. # Load Client Assembly [Reflection.Assembly]::Load(“Microsoft.TeamFoundation.Client, Version=11.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a”); [Reflection.Assembly]::Load(“Microsoft.TeamFoundation.TestManagement.Client, Version=11.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a”); [Reflection.Assembly]::Load(“Microsoft.TeamFoundation.TestManagement.Common, Version=11.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a”);   # Define parameters $tfsCollectionUrl = “http://myserver:8080/tfs/DefaultCollection”; $projectName = "DefaultProject"; $planId = "1"; $userDisplayName = "Aseem Bansal"; # Connect to tfs…

0

How to write a custom test management event listener?

In couple of my previous posts, I talked about what are the important events raised by test management service and how code for one such event listener looks like. In this post, I will talk about what exact steps I did to write my test management event listener. In case you are interested in writing…

1

How to find the action recording associated with the test?

I was looking at this question on the MTM forum and wanted to find out answers for following 2 questions. How can a user find out whether an action recording is associated with a test or not? How can a user delete the associated action recording? For #1, I coded a small power-shell script which…

3

A test run must be created with at-least one test case

I was trying to run an automated test using TCM.exe and the executable was failing with a message saying “A test run must be created with at-least one test case.” On looking at the code, I found why it is failing and what should I do to come out of this error. Later on I…

0

Which Test Management notifications are available?

Test Management service in Team Foundation Server 2012 raises notifications on some specific actions by its users. You can subscribe to these notifications to understand what’s going on in the server. Here are some of the important notifications which are raised by test management service. TestRunStartedNotification TestRunChangedNotification TestRunCompletedNotification  TestPlanChangedNotification TestSuiteChangedNotification  TestConfigurationChangedNotification     (Update 11/20)  Let…

4

How to enable Tfs job agent logs for lab operations

In this post, I want to talk about the steps which I typically perform to enable the job agent logs for lab operations. 1. Stop the TFS job agent service. (net stop tfsjobagent) 2.  Enable tracing for Tfs job agent. Take a backup of the tfsjobagent.exe.config file. (It is typically found under C:\Program Files\Microsoft Team…

0

How to enable lab agent logs

Here are the steps which I typically perform to enable lab agent logs. 1. Go to the lab agent installation directory (typically it is something like C:\Program Files\Microsoft Visual Studio Lab Management 10.0). 2. Open the configuration file named LabAgentService.exe.config and edit it as shown below. (Changed autoflush from false to true, removed comments from…

0

How to enable build agent or build controller’s logs?

Here are the steps which I typically perform to enable build agent/controller logs. 1. Go to the build agent/controller installation directory (typically it is something like C:\Program Files\Microsoft Team Foundation Server 2010\Tools). 2. Create a new configuration file named TFSBuildServiceHost.exe.config with the following content: <configuration>    <system.diagnostics>        <switches>            <add name=”BuildServiceTraceLevel” value=”4″/>        </switches>        <trace autoflush=”true” indentsize=”4″>            <listeners>               …

5