Data tier load with Team Foundation beta


Did you install your beta data tier in Virtual PC or Virtual Server and see a high CPU load while its running?  Even on real hardware, you may notice some load when nothing would appear to be going on.  Someone mentioned on an internal mailing list that the data tier CPU load for a combined app and data tier installed in Virtual Server was quite high, averaging about 50-70% with most of that time being used by SQL analysis services (msmdsrv.exe).

Well, here’s the answer (I didn’t write the question or the answer, but I hope people find it useful).

The warehouse was designed to run processing every hour. For demo purposes the period was changed to 2 minutes in beta 2. On a weak system or a virtual machine you will see this behavior.

Change the run interval on the app tier as follows.

  1. Stop TFSServerScheduler using ‘net stop TFSServerScheduler’.
  2. Go to http://localhost:8080/Warehouse/warehousecontroller.asmx using a browser on the app tier.  Click on ChangeSetting and enter the following values and then press the ‘Invoke’ button (3600 seconds = run once per hour).
    1. settingID: RunIntervalSeconds
    2. newValue: 3600
  3. Restart TFSServerScheduler using ‘net start TFSServerScheduler’.

Note: It is important to restart TFSServerScheduler, as the interval is cached and will not take effect until the next run.

You can also manually kick off the data warehouse.  Here are the steps to do so:

  1. Go to http://localhost:8080/Warehouse/warehousecontroller.asmx using a browser on the app tier.
  2. Click the ‘Run’ link.
  3. Press the ‘Invoke’ button.

 This will trigger a refresh of the reports.

[Update]  Thanks to Mike for pointing out the the original instructions were a little rough.  I’ve updated them.

[Update 2] Added msmdsrv.exe to the text to (hopefully) make it easier for folks to find the post when they notice that the Yukon April CTP Analysis Services process is consuming a lot of CPU time.

Comments (20)

  1. Amaxo says:

    Buck Hodges has the answer to a problem that I was seeing on the Team Foundation Server. I have both the data and app tier installed on a single, slightly older machine and the system was at 100% CPU running…

  2. Visual Studio Team System

    Beta 2 is out and thousands of you have downloaded and installed it with varying…

  3. Buck Hodges says:

    Many folks are interested in guidance on hardware.  In the Team Foundation forum, Brian Harry, Product…

  4. I’ve linked to this post from Buck Hodges before (New Team System Stuff 2005–04–25), but it appears…

  5. Steven Borg says:

    Works great and I love it! Only thing is that you can’t use the tips you have for running it on command in Beta 2, since the Run operation doesn’t support Get, so VS doesn’t create an Invoke button for you. :-(

  6. Steven Borg says:

    Whoops! You can do it, just only from the local machine! :-O Not a remote machine, like I was trying.

  7. If you’ve installed team system, you’ll probably find these two pages helpful to fix two bits:http://www.amaxo.com/blog/archives/2005/05/eliminate_ctl00.html fixes the problem with Unable to locate control: ctl00oReportCell when looking at reportshttp://b

  8. Buck Hodges says:

    We’re still ironing out a few more wrinkles in preparation for the dogfood upgrade, but I wanted to…

  9. 如何成功安装VSTS 2005 Beta2

  10. Clark Sell says:

    The following is my official VSTS jumpstart kit.  I will maintain this post entry going forward….

  11. Clark Sell says:

    Internet Links

    Visual Studio Team System Home

    Getting Started with Team Foundation

    MSDN Technical…

  12. Clark Sell says:

    Internet Links Visual Studio Team System Home Getting Started with Team Foundation MSDN Technical Forums

  13. How To Change Report Interval in TFS