What is the data in the VSTS load test results store

Article Posted: What is the data in the load test results store

Bill Barnett's blog — Mon, 13 Feb 2006 17:26:03 GMT

If you're interested in accessing the data in the load test results store directly to build your own...

re: What is the data in the VSTS load test results store

GAT2000 — Fri, 16 Feb 2007 11:57:15 GMT

Thanks, this was very useful :)

re: What is the data in the VSTS load test results store

tomandlis — Thu, 22 Mar 2007 17:25:02 GMT

thanks this is great.

One question. What do zeros in the samples table mean? Using your DB dictionary I have written sql queriy and can see the raw data. However, in about 5% of the intervals I see '0' , i.e., nothing zero zilch nada, for average response time.

That seems impossible. During the load test there were 7 requests per second and each interval was 5 seconds long. In other words there were 35 requests in every interval--I would think there would have to be a response returned during that period. If not, I would hope VSTS would report null.

I understand that sometimes the server being tested is too busy to report perfmon data, but doesn't VSTS report zero for this case? I would think it would/should because reporting zero would be very confusing and (I think) would make average response times look really good (when they weren't).

re: What is the data in the VSTS load test results store

kobycool — Mon, 16 Apr 2007 14:21:02 GMT

In some of tables of 'LoadTest' database I cannot see any values. For example, table 'LoadTestTestSummaryData' does not contain values.

Am I missing something?

Thx.

re: What is the data in the VSTS load test results store

NickTulett — Mon, 06 Jul 2009 13:28:01 GMT

Very useful but how do I actually see the content of a "long binary data" value?

e.g. WebLoadTestErrorDetail.WebTestRequestResult