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