Controlling Data Warehouse refresh in TFS 2010

TFS 2010 added some new options to control how and when the data warehouse and Analysis Services cube is refreshed.  From your TFS Server’s Application Tier, browse to this site: http://myTFSServer:8080/tfs/TeamFoundation/Administration/v3.0/WarehouseControlService.asmx, click on ChangeSettings, and from there you can enter the Setting ID and the new value.  These are the available settings that you can change:

RunIntervalSeconds – Frequency in which TFS Warehouse data is synchronized.  This is not analysis services, this is the table that the cube gets its data from.

IncrementalProcessIntervalSeconds – Frequency with which Analysis Database is updated.  This is the one that you are most likely going to change if you want your data to be more “up to date” in your reports.  Just make sure that it’s not a lower number than the “RunIntervalSeconds” value as that would be pointless.

FullProcessIntervalSeconds – The cube gets fully processed once a day by default, but you can change this setting to get it to run at a different interval.

DailyFullProcessingTime – Time of day when full cube process should start.  Make sure that this doesn’t land in the middle of the day as full processing takes a big performance hit.

MaxParallelASProcessingCommands – Max number of commands that can run in parallel in Analysis Services.

AnalysisSchemaUpdateWaitSeconds – used by Analysis processing jobs trying to acquire an exclusive access to the warehouse resources during the Schema Change stage.

SchemaUpdateWaitSeconds – How long a job will be waiting in the Running state for the exclusive access to call IWarehouseAdapter.SchemaChange().

DataUpdateWaitSeconds – how long a job will be waiting in the Running state for another adapter making Schema changes or for Analysis Processing job changing Analysis Database schema.

WarehouseCommandSqlTimeout – used for acquiring an exclusive access to a warehouse resource

AnalysisServicesProcessingTimeout – How long to wait for an Analysis Services processing call to complete.

About esteban

Esteban is the Founder and Chief Technologist at Nebbia Technology, an ALM consulting and Azure-powered technology company. He is a software developer with a passion for ALM, TFS, Azure, and software development best practices. Esteban is a Microsoft Visual Studio ALM MVP and ALM Ranger, Pluralsight author, and the president of ONETUG (Orlando .NET User Group).

5 thoughts on “TFS 2010 Dashboards with SharePoint 2010 (MOSS)

  1. Jose Medero

    Hi Esteban, i am working on integrating my company’s TFS 2010 with a SharePoint 2010 portal. I have been looking that several blogs shows that when the configuration is done they get several dashboards. In my case the only dashboard that was created was “My Dashboard”. Wath do I need to get other dashboards like the ones mentioned in your article.

    I am working on a sharepoint 2010 farm single server test enviroment with my production TFS 2010. My configuration goes as follows:
    – TFS 2010 Standard
    – SharePoint 2010 Enterprise
    – Sql 2008 r2 Enterprise with Report Server in Integrated Mode.
    – SP has been integrated with reporting services.

  2. Esteban Garcia

    Do you see any errors in the Team Project creation log? I seem to remember running into this before, and I think it had to do with permissions during the creation of the Team Project, but I may be mistaken. Can you take a look at your log file and let me know?

  3. Bob Cronin

    I know this is an old post Esteban, but it saved me today. Thanks for publishing!

  4. Anurag Jain

    Hi Esteban, Thanks for this nice explanation, But i do have some other requirement.
    Lest say if we have WorkItemLinkFilters LinkType=”System.LinkTypes.Hierarchy” then WorkItemTypeFilters should be “Task” and if we have WorkItemLinkFilters LinkType=”System.LinkTypes.Hierarchy” then WorkItemTypeFilters should be “child” only. Is it possible to achieve ?

  5. Sankar

    This is working fine for active users.. How can I remove inactive user from Team Foundation Service Accounts using this command?

Leave a Reply

Your email address will not be published. Required fields are marked *

Are you human? *