Premier Field Engineer, Microsoft Services Customer Service and Support
(This blog post is part of a series of posts on the new VSTS Pioneer TFS dogfood server.)
Everybody loves statistics, so here are the statistics for the first month on the VSTS Pioneer server.
Work Item Tracking
Version Control
These statistics are captured by using the TFS Best Practices Analyzer and a custom configuration file. The configuration tells the BPA tool to run a series of SQL queries and dump the results to an XML file. I have then created an XSLT that transforms the results into a more user-friendly HTML file. The BPA tool is then scheduled to run every night and generate a fresh set of statistics. I’m working with the TFS BPA team to get this configuration built into the next version of the BPA tool – I don’t have an ETA on when that will ship, but stay tuned.
This month I’ve also pulled the last 30 days of PerfMon counters to see how our hardware choices are holding up. If you’d like to setup something like this for yourself, have a look at my previous posts.
Disk Performance
Things are looking OK on the IO front. 95% of the time we’re pushing 45MB/sec (Read) and 33MB/sec (Write) or less to and from our storage. The response time is <40ms which is nothing to worry about for the configuration we have.
LogicalDisk(_Total)
50th Percentile
95th Percentile
99th Percentile
Avg. Disk sec/Read
0.004
0.039
0.371
Avg. Disk sec/Write
0.003
0.023
0.063
Disk Read Bytes/sec
2,142,548
44,926,021
94,273,782
Disk Write Bytes/sec
1,908,518
33,029,252
70,802,346
Avg. Disk Bytes/Transfer
42,867
133,887
436,920
Memory
The memory usage on our SQL server has remained completely constant. This is because SQL is set to use a fixed amount and Analysis Services & Reporting Services share the rest.
CPU Performance
(Avg: 32%). The majority of this usage is SQL Server, with a small portion going to Analysis Services & Reporting Services. It’s nice to see that we still have plenty of capacity left for the usage to grow.
That’s all for statistics, stay tuned for more next month.