« Problems with SQL Server Reporting Services Permissions | Main | Simplify Authorization for Team Project Creation »
April 20, 2005
High CPU load on Team Server
Buck Hodges has the answer to a problem that I was seeing on the Team Foundation Server. I have both the data and app tier installed on a single, slightly older machine and the system was at 100% CPU running at about a 30-40% duty cycle. I hadn't gotten around to investigating it, and now I don't have to.
The SQL Analysis data warehouse should recalculate every hour, but the interval was increased to every 2 minutes for Beta 2. Follow the link to Buck's site for details on reconfiguring this parameter.
Note 1: I haven't seen this high duty cycle all of the time. I suspect that the TFSServerScheduler may have crashed at some point and I was just so happy to have my CPU back that I didn't notice.
Note 2: Buck references 'Warehouse/Warehouse.asmx', but on my system it's at 'Warehouse/warehousecontroller.asmx' (in the VSTFWeb).
Posted by Mike Attili at April 20, 2005 09:30 AM