Dissecting the Visual Studio Load Test Results Database (Part 4–Building Better Views)

In the previous posts of this series, I focused on showing you the built in features of the Load Test Results Database. The next few posts will focus on customizing and extending the database. The Mystery of the Perfmon Page Counters There are two ways you can look at the details for pages, transactions, etc…

0

Dissecting the Visual Studio Load Test Results Database (Part 3–Excel Reporting)

In Part 3, we look at the sprocs and calls used to build reports in Excel. The Excel Reporting Feature In the 2010 release of Visual Studio Ultimate, a new feature was added that allows you to use Microsoft Excel to create either a Run Comparison or Trend Analysis report. You can read the standard…

1

Dissecting the Visual Studio Load Test Results Database (Part 1–Intro to the Schema)

Sean Lumley wrote a good blog post years ago about the actual schema for the Visual Studio Load Test results database, but even with that post, navigating the DB and figuring out how things tie together can be confusing at the least, and sometimes almost impossible to figure out. I have been working inside the…

1

How Does the User Pacing model differ from the Number of Tests Started model

In my post on User Load Profiles, I talked about choosing one of two different load models, based on a couple of the options in Visual Studio. However, I have still received a lot of requests to clarify these two models and to show how I can apply one of the models to the testing…

0

All About Load Test Results and the Results DB (Part 5–Requests vs. Pages vs. Transactions

I was recently asked about the details of transaction timers and realized that I have not made a post that clearly shows the differences between the various timers that Visual Studio collects and reports on. While there is a good help file page on this in the online documentation (https://msdn.microsoft.com/en-us/library/ms404656.aspx), I thought I would show…

0

Test And Attack – The Art of Testing WITH…

My old team coined a phrase that they use to describe their Performance engagements called “Test and Attack.” It is meant to conjure up a picture that can represent exactly what happens during the execution phase of a performance tuning and optimization engagement. So what does happen? Test With You, Not For You We refer…

0

Should I Setup My Rig Outside of My Environment’s DMZ?

My old team would get this question all of the time when we were scoping potential customer engagements. The customer wanted to make sure we could simulate the “Internet” for their testing. We have hardware WAN simulators in our labs, so we could easily do this. However, when we were asked to include them in…

0