Senior Service Engineer, Microsoft Visual Studio Team Foundation Service
When you do a "Get Latest" in TFS, there are three requests that the server processes:
In the second step, if there are a large number of requests for file downloads it can place quite a lot of load on your TFS Application Tier. If you have a large number of users or build servers that download files in your environment, you may benefit from setting up a Team Foundation Server Source Control Proxy on a separate machine. Since the proxy is state-less, you could even place multiple machines behind a load balancer (we use this internally for our build labs with good results).
Once you have the proxy set up, you might want to know who isn't using it. This can be done easily by querying the TfsActivityLogging database. This logging is enabled by default in TFS 2008. In TFS 2005 you will have to enable the commandLogging flag in the Global Web.Config file (and the query below will be a little different).
In our environment, we know that all proxy servers run as NETWORK SERVICE, so we can filter out non-proxy requests easily by excluding machine accounts (DOMAIN\COMPUTERNAME$)
SELECT SUM([ExecutionCount]) as DownloadCount, [IdentityName], [IPAddress] FROM [TfsActivityLogging].[dbo].[tbl_Command] WITH (NOLOCK) WHERE Command = 'Download' AND IdentityName NOT LIKE '%$' GROUP BY IPAddress, IdentityName ORDER BY SUM([ExecutionCount]) DESC
SUM([ExecutionCount]) as DownloadCount, [IdentityName], [IPAddress]
WHERE Command = 'Download'
AND IdentityName NOT LIKE '%$'
GROUP BY IPAddress, IdentityName
ORDER BY SUM([ExecutionCount]) DESC
If everybody is using a proxy server, the only requests in the TFS Activity Log you should see are requests from a proxy server itself. Every other request will either be:
Brian Harry on A new Team System users group (with a twist) and Team Foundation Server 2008 SP1 Bug fixes...
So do internal LAN users go through the proxy as well? This is a configuration we'd considered to reduce load on the AT.
Yes William, all users (including internal) are using proxy servers
Since posting How TFS Proxy 2008 works , I have got a bunch of questions regarding TFS proxy. I would
I’m on the team that runs the busiest Team Foundation Server at Microsoft. The Developer Division instance
Informes de rendimiento de TFS
Hola a todos, veo en el blog del ex-MVP (ahora trabaja en Microsoft), Grant Hollyday , que ha creado