Today one of my customers called and asked how to identify what causing slowness in TFS. Well, you should start with the basics, check TFS Application Tier and make sure CPU, Disk Usage and Network are in the normal levels. Once you’re sure the IIS (App Tier) is working we move to TFS DB. The first query you should run (Using SSMS) is the following: 1 SELECT top 20 SUBSTRING(t.text, ( s.statement_start_offset / 2 ) + 1,
2 ( ( CASE statement_end_offset WHEN -1 THEN DATALENGTH(t.text) ELSE s.statement_end_offset END - s.statement_start_offset ) / 2 ) + 1) AS statement_text,
This is a question I get a lot – How to convert / create a work item from email?
So as you know me there is a tool for any question , here is an Outlook Add-In I wrote that allows you to create a work item from any email.
Download Wit-It 2013
Wit-It will also add attachments and links to the work item.
This post will show to manipulate MTM configurations and variables using TFS API, this post came after a customer raise a demand to add hundreds of configurations to MTM from external system. Download Demo Project I’ve created WPF Application and added the following assemblies into my project: Microsoft.TeamFoundation.Client Microsoft.TeamFoundation.Common Microsoft.TeamFoundation.TestManagement.Client.dll Microsoft.TeamFoundation.TestManagement.Common.dll Step 1: Connect TFS private void Button_Click(object sender, RoutedEventArgs e)
TeamProjectPicker tpp = new TeamProjectPicker(TeamProjectPickerMode.SingleProject, false);
if (tpp.ShowDialog() != System.Windows.Forms.DialogResult.OK) return;
Tfs = tpp.SelectedTeamProjectCollection;
Grp.IsEnabled = true;
There is always a way to make thing work faster, my customer has two App Tiers controlled by NLB and DB Cluster and still there is ways to improved TFS Performance. I’ve wrote on DB Resizing and Management - Control\Reduce TFS DB Size I demonstrate how to clear IIS Logs - Clear IIS Logs Using Task Scheduler – Although some people prefer to disable log by Running the following command: (I don’t like it – If there is a problem disabling information will not help you solving the problem…..) %windir%\system32\inetsrv\appcmd set config -section:system.webServer/httpLogging /dontLog:"True" /commit:apphost Separate I/O...
I’m building a dashboard for a customer with a lot reports from SSRS, while working I’ve received the following message: To solve this you need to change SSRS config file located at - “C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\ReportServer\rsreportserver.config” Change “MaxActiveReqForOneUser” key From 20 to 100
Today I received an email from the company DBA saying that out TFS Backup failed because “There is not enough space on the disk”.
First I’ve opened SSMS to understand how big is our TFS DB and I…….. What????? I knew that we’re getting bigger from day to day (more and more groups are joining to start working with TFS) but 633GB???
TFS DB Size growth usually comes from Attachments and Source Control, So I tried to understand which Team Projects are taking most of the space.
I need to understand what type of attachments are taking all that space, again per...
בתקופה האחרונה שואלים אותי יותר ויותר בנוגע להעברת בדיקות וכל מבנה העץ תחת MTM לשרת אחר או פרוייקט אחר.
ב – 2010 שרק הגיע MTM לשוק כתבתי כלי לשכפול פנימי בתוך הפרויקט (במטרה לנהל גרסאות שונות של הבדיקות) - http://blogs.microsoft.co.il/shair/2011/03/20/test-case-migrator-between-projects-wpf-metro/.
ב – 2012 מיקרוסופט הכריזה על יכולת חדשה ב – MTM – Clone המאפשרת שיכפול של כל עץ הבדיקות, אבל זה רק באותו הפרוייקט….
אז שוב מצאתי את עצמי כותב כלי לסייע במעבר –הורדה של הכלי (כולל קוד)
1. הקמתי פרוייקט ריק
2. נפתח את הכלי, נציין פרויקט מקור ופרוייקט מטרה.
3. לאחר מכן נבחר אילו ספריות ו\או בדיקות אנו מעוניינים להעביר..
4. ניצור Test Plan...
I’m getting this question a lot, how to run multiple tests on different machines in parallel?
Every customer that I work with has over 100 tests and some has more than 1000+.
So how to improve test execution time? running 1000+ tests can take a while and we want to get the results as fast as possible.
So, for Unit Tests there is a nice trick (Wrote about it in 2010 –>Run Unit Tests in Parallel using Visual Studio 2010) that allow you to run those tests in parallel on the same machine.
But what about Coded UI Tests? you most know we...
This is something I see a lot, IIS logs takes a lot of space and sometimes even cause the IIS Server to stop due to “Not Enough Space” exception.
There is not a build in solution for Log retention policy but several options on File Size, Creation Scheduling etc.
There are many solutions for cleaning the Logs but I prefer the Task Scheduler way with a single line for cleaning Logs based on their creation date.
Run Task Scheduler from the Command Line
Open a command prompt. To open a command prompt, click Start , click All Programs , click Accessories , and...
Microsoft Test Manager allows you to connect Test Automation to Manual Test, this is part of end to end solution, once you connect Automated Test to Manual Test you can use it in Lab Manager.
You can link any unit test, coded UI test, or generic test to a test case. You’ll want to link a test method that performs the test described by the test case. Typically these are integration tests. The results of automated and manual tests appear together. If the test cases are linked to backlog items, stories, or other requirements, you can review the test results...