Effective Thoughts

You may have noticed it takes a while for Team Foundation Server (TFS) reports to reflect changes you've made to work items or builds. Let me guess...about an hour, right? Out of the box, TFS is set to refresh the data warehouse from its transactional store every 60 minutes. How do I change the frequency of the data warehouse refresh? Browse to the TFS Controller Web Service on your TFS application tier server within IE at: http://localhost:8080/Warehouse/v1.0/warehousecontroller.asmx Select the ChangeSetting option Enter RunIntervalSeconds for the settingId and the desired number of seconds for newValue (300 for 5 minutes...5*60) Select Invoke How do I force a data warehouse refresh? Two methods here: either via the above web service or using SQL Server Management Studio. Via the web service: Browse to the TFS Controller Web Service within IE at: http://localhost:8080/Warehouse/v1.0/warehousecontroller.asmx Select the Run option Click Invo...

Update 12/25/2008: Refreshes are out... here ! Update 12/10/2008: Apparently, there's a way to edit the VPC config file (.VMC) to disable time synchronization with the host operating system. Might make demos relying on a sprint/iteration interesting but it's very helpful. ------------------ We rely on the TFS / VSTS 2008 VirtualPC instances Microsoft pumps out for demos, presentations, and even some training. Yes, I can kit out a VPC on my own but it takes at least a day or two, it lacks the scenarios and test users, and sharing 20+GB files across the team can be challenging. I'm excited to announce the TFS team will be refreshing the 12/31 expiring VPC instances soon...with SQL 2008 and all the latest bits! Thanks, Jeff Beehler for this insight.