Reports to show you what’s happening with the TFS warehouse and cube
Grant has posted a set of reports that help you understand what’s going on in the TFS warehouse and cube in Team Foundation Server 2010 so that you can deal with issues such as field collisions, which can be very tedious to handle since out of the box we don’t provide easy ways to figure it out. His post includes an attached zip file that you can download and deploy to your TFS 2010 installation.
One of the key components of TFS is the Data Warehouse, which is made up of a relational database and an Analysis Services cube. In general, people don’t have a problem with the performance or operation of our Data Warehouse. However there were two classes of problems that you’re likely to run into as your servers grow larger:
- Processing Time – As the number of reportable fields increases, the number of dimensions that Analysis Services has to process also increases. This increases the time it takes to process the cube and therefore the latency of the data is higher.
- Schema Conflicts – In the simple case, when there are two fields in different collections (e.g. Priority) with the same name but a different type (e.g. String vs. Integer) this results in a schema conflict. That project collection is then blocked from processing warehouse updates and the data in the warehouse & cube becomes stale.
These reports are useful to TFS administrators, operations/support teams, project administrators & end-users. The reports in this pack display the following kinds of information:
- Recent processing times
- Current status (whether the cube is processing now and, if not, when it is scheduled to process next)
- Schema conflicts
- Most recent time that each adapter successfully ran