Monitoring Build Performance

19 03 2009

Developers love nothing more than complaining about how long their builds take, sometimes their complaints are justified and sometimes they’re not. Even worse sometimes performance degrades slowly over time and no one notices.

To better quantify how long builds are taking I created a Build Performance report that is emailed to me monthly. This report gives the minimum, maximum, and average build duration (in minutes) for each of our main build definitions over the last 12 months.

Below is an example of that report and you can download the Build Performance Report Definition for SQL Server 2005 Reporting Services from here. If you want to restrict the build definitions that are included you can add an additional condition to the WHERE clause:

AND (
    [Build].[Build Type] LIKE ‘DEV_._’
    OR [Build].[Build Type] = ‘Main’
)

image-thumb

This report was made better thanks to SSW’s Rules to Better MS SQL Reporting Services.


Actions

Information

4 responses

19 03 2009
Drilling Into Build Performance at TeamSystemNotes

[...] my last post on Monitoring Build Performance I showed a report that you can use to identify when your builds aren’t performing as expected. So [...]

20 03 2009
Jim Lamb : Improving Build Performance in TFS 2008

[...] William Bartholomew has a two great posts on build performance:  Monitoring Build Performance and Drilling into Build Performance – March 19, 2009. Published Tuesday, February 10, 2009 7:40 [...]

20 04 2009
Un tableau de bord prêt à l’emploi pour Team Foundation Server | Coded Style

[...] Un tableau de bord prêt à l’emploi pour Team Foundation Server Le lien ci-dessous vous permettra de créer un ensemble de graphiques basé sur une requête de Work Items de Team Foundation Server. Le tableau de bord du chef de projet en quelques minutes. Ensuite les données sont rafraîchies à la demande : Nouveaux Bugs ouverts, résolus et fermés par mois Nouveaux Bugs par état Vélocité de correction Bugs Backlog Et beaucoup d’autres données !     Le lien vers le post original : http://blogs.msdn.com/teams_wit_tools/archive/2009/02/12/building-lightweight-dashboards-using-excel.aspx  Ce rapport est téléchargeable et vous apporte les informations concernant le nombre de Build par semaine, par jours, les durées d’exécution… Les données extraites proviennent de mon serveur TFS de démo : le temps moyen d’exécution d’une compilation est de 3 minutes. Ce qui est déjà long lorsqu’on fait une présentation ! Le lien vers l’exemple de rapport : http://blogs.teamsystemnotes.com/2009/03/19/monitoring-build-performance/ [...]

25 05 2009
Drilling Into Build Performance « TeamSystemNotes

[...] my last post on Monitoring Build Performance I showed a report that you can use to identify when your builds aren’t performing as expected. So [...]

Leave a comment