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

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