Share via

Updating the TFS Warehouse

  • Article

I think that my next few posts will be about the Team Foundation Server Data Warehouse, so I wanted to do a post about how to update this warehouse on demand.

The Team Foundation Server Data Warehouse updates itself every couple of hours by default. This process involves running all of the registered data adapters and processing the cube. As you store more and more data, this can become a very CPU-intensive operation. That is why the warehouse only updates every couple of hours by default. In most cases, having your reports current within a couple of hours is sufficient.

However, there are times when you want to update the warehouse on demand. Maybe you’re giving a demonstration, or maybe you’re debugging an adapter you’ve written or maybe you just need the most up to date method.

Updating the warehouse on demand is pretty straightforward - you can use the corresponding warehouse XML Web Service to kick off a run. This is an async operation though, so you’ll need to poll on its status. The two web methods you’ll need are shown below:

Warehouse

What makes this process a little tedious is that you have to keep invoking GetWarehouseStatus until it returns a status of Idle.

To make this a little easier, I thought I would write a small utility to kick off the run and monitor its status for me. This little utility is shown below:

Update

Once you select the right TFS, press the Update button and the utility should take care of kicking off a run and polling until the warehouse is idle again. I posted the source here, please give it a try and let me know what you think.

Thanks!

Eric.

Comments

  • Anonymous
    July 10, 2006
    I was reading through the MSDN aggregation of blogs when I saw this post and it reminded me of a post and corresponding tool that I wrote a while back that looks very similiar to what you are doing here.

    http://paltman.com/archive/2006/04/12/teamfoundationserverwarehouseupdatetool.aspx

    My app is a tray app who's icon changes color with the status and provides context menu options for kicking off an update.

  • Anonymous
    July 10, 2006
    Eric Lee on be careful of proxy settings when using the Team Foundation Server Object Model, KPI and...

  • Anonymous
    July 10, 2006
    See Eric Lee’s post on Updating the TFS Warehouse for a quick overview of how Team...

  • Anonymous
    July 10, 2006
    Nice job on the tray application - good to see another VSTS enthusiast :)  Maybe we can collaborate on a tool sometime.

  • Anonymous
    July 10, 2006
    Eric, it'd be a lot of fun to collaborate on a VSTS project, maybe make use of CodePlex for it.

  • Anonymous
    August 01, 2006
    The comment has been removed

  • Anonymous
    August 01, 2006
    I published a small update of this soft to provide support for autenthification, you can find it here : http://julien.lavigneducadet.com/index.php?2006/08/02/5-tfs-warehouse-update-with-authentification

  • Anonymous
    March 08, 2007
    I received this from a colleague today and it’s so helpful I thought I’d post it to my blog

  • Anonymous
    March 08, 2007
    TEAM FOUNDATION SERVER Utilities Capacity planning spreadsheet and tools (Unsupported) Team Foundation

  • Anonymous
    March 11, 2007
    A dump, of various tools, thanks to Zeeshan Shah. Note: this is not an endorsed list. Utilities Team

  • Anonymous
    July 12, 2007
    After I installed the eScrum template everything seemed fine bar the reports, only the work item report

  • Anonymous
    July 12, 2007
    After I installed the eScrum template everything seemed fine bar the reports, only the work item report

  • Anonymous
    November 17, 2007
    I have been working on my DDD6 demo, I intend to show eScrum at end of my session on Scrum. I thought

  • Anonymous
    March 29, 2008
    PingBack from http://www.lavigneducadet.com/wordpress/?p=18

  • Anonymous
    March 29, 2008
    PingBack from http://www.lavigneducadet.com/wordpress/?p=19

  • Anonymous
    October 15, 2008
    PingBack from http://adallow.wordpress.com/2008/10/16/app-adn-source-code-to-update-your-tfs-warehouse/

  • Anonymous
    May 29, 2009
    PingBack from http://paidsurveyshub.info/story.php?title=eric-lee-a-humble-blog-updating-the-tfs-warehouse