TFS Performance Issues–Useful SQL Queries

Wednesday, November 11, 2015

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, 3...
tags: , , , , ,
no comments

TFS API Part 56 – Test Configurations

Monday, February 2, 2015

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; ...
tags: , , , ,
no comments

TFS Performance Tips – Cache

Sunday, August 17, 2014

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...
no comments

The number of requests for "Domain\User" has exceeded the maximum number allowed for a single user

Wednesday, July 9, 2014

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
no comments

Control\Reduce TFS DB Size

Sunday, June 29, 2014

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...

העתקה של בדיקות ומבנה משרת לשרת

Thursday, June 26, 2014

בתקופה האחרונה שואלים אותי יותר ויותר בנוגע להעברת בדיקות וכל מבנה העץ תחת MTM לשרת אחר או פרוייקט אחר. ב – 2010 שרק הגיע MTM לשוק כתבתי כלי לשכפול פנימי בתוך הפרויקט (במטרה לנהל גרסאות שונות של הבדיקות) - ב – 2012 מיקרוסופט הכריזה על יכולת חדשה ב – MTM – Clone המאפשרת שיכפול של כל עץ הבדיקות, אבל זה רק באותו הפרוייקט…. אז שוב מצאתי את עצמי כותב כלי לסייע במעבר –הורדה של הכלי (כולל קוד) 1. הקמתי פרוייקט ריק 2. נפתח את הכלי, נציין פרויקט מקור ופרוייקט מטרה. 3. לאחר מכן נבחר אילו ספריות ו\או בדיקות אנו מעוניינים להעביר.. 4. ניצור Test Plan...
no comments

How To: Run Tests On Different Machines In Parallel

Wednesday, June 18, 2014

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...

Clear IIS Logs Using Task Scheduler

Wednesday, April 23, 2014

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...
no comments

TFS API Part 54 – Add Associate Automation Programmatically

Monday, March 3, 2014

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...
tags: , , ,
no comments