Home » Blogs » bhardister's blog

How to confirm that data has stopped flowing from the TFS 2010 operational store to the data warehouse

This is a great procedure because you can tell instantly if changes are going to be picked-up or not. You don't have to wait for the cube to process. Here's the procedure for TFS 2010:

  1. Make one or more of the following changes:
    • Check in a changed file to source control.
    • Update a work item.
    • Publish a test result.
  2. Click Start, point to All Programs, point to Microsoft SQL Server 2008, and then click SQL Server Management Studio.
  3. In the Server Type list, in the Connect to Server dialog box, select Database Engine, and then click Connect.
  4. In Microsoft SQL Server Management Studio, click New Query.
  5. Confirm the change appears in the appropriate tables by running the following query:


    6. select * from [Tfs_DefaultCollection].[dbo].[WorkItemsAre] where id = (select max(id) from [Tfs_DefaultCollection].[dbo].[WorkItemsAre])

If the change does not appear, the data has stopped flowing.