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

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 2012 Upgrade Process Template–Guide

Thursday, July 18, 2013

Many customers are upgrading from TFS 2010 or earlier versions to TFS 2012 and in near future will upgrade to TFS 2013. As Microsoft making the upgrade process of TFS a very smooth process there are still things we need to upgrade in our Team Project process template things that will not happened in the TFS Upgrade Process. So which things? the Team Project Process Template – Work Items, Queries, Reports, Categories and more. There are couple of scenarios you interesting in: Upgrade the same Process Template to the latest version. ...

VS/TFS 2012 Update 2 & Update 3 CTP

Wednesday, May 8, 2013

Couple of days ago Brian Harry post about the new release of Update 2 for Visual Studio and TFS 2012, and today another release of Update 3 that isn’t big a Update 1 and 2 but contains a set of bug fixes that can ease you work. Before jumping to Update 3, if for some reason you’re not using Update 2 this is the time to read about it and install it! Update 2 VS/TFS 2012.2 (Update 2) Visual Studio 2012 Update 2 (VS 2012.2) ISOs available ...

Run Windows Store Apps From Desktop

Thursday, February 7, 2013

When customers ask me how they can run Windows Store app from Desktop usually the answer is – You Can’t, but if you really want there is a way to do that. The reason I usually answer is You Can’t is because – In order to run Windows Store app from Desktop you need to install Windows App Certification Kit, this pack contains “” file that can run a Windows Store app by his application model id. So if you plan on publishing your app you can’t assume the ACK is installed on the client machine. ...

Visual Source Safe Upgrade Tool for Team Foundation Server

Sunday, November 11, 2012

If for some reason you or your company is still using VSS it’s time to move forward! Team Foundation server supports VSS Migration, until today there were a command line tool allowing you to migrate VSS repository to TFS Source Control – this tool is called – VSSConverter. VSSConverter command line tool requires configuration file that need manual authoring, but no More! Microsoft has announce a new wizard based UI tool for upgrading VSS repositories to Team Foundation Server 2012/2010. Open the tool and start the upgrade, choose VSS local repository. ...