Dissecting the Visual Studio Load Test Results Database (Part 6–Data Warehousing)

In the previous post, I showed how I use a couple of stored procedures to recalculate data based on various criteria. In this post, I am going to share a few data tables that I use to store “Warehousing” data to make reports faster and easier to create. In the next post I will show…

0

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

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

[FIXED] Importing and Exporting Perfmon Counters [download]

(NOTE: A bug was reported about errors (missing stored procedures) when trying to add the SQL file to the DB.I have fixed that bug and moved the downloads to CodePlex. Please use this link to get the tool: https://perfmonimportexport.codeplex.com/ ) I am posting this utility to help people who need to import or export perfmon…

3

"Extrapolation, Educated Guesses and Dart Boards, Oh My"

Here is another common question in the testing world: “What is the best way to take the results from our tests with a small load and estimate how the system will behave under a full load?” There are many different reasons for asking this question, not the least of which is because testers often do…

0

How to Export Perfmon Counter Values from the Visual Studio Load Test Results Database

How Are Perfmon Results Stored When Visual Studio collects perfmon data during a load test, it stores the data in the SQL database using four tables that allow it to normalize the data into a relational hierarchy. The four tables are: Dbo.LoadTestPerformanceCounterCategory – holds the list of machine names and counter category names (such as…

2

Explanation of “Off-Box Inclusive Testing” and how it impacts results and troubleshooting

Explanation of “Off-Box Inclusive testing” and how it impacts troubleshooting An “Off-Box” request is any request that is made by a client to a machine that is not part of the core environment. As an example, if a user opens Internet Explorer and goes to the main Contoso.com website, Internet Explorer will go to the…

0