Tag: perfmon

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…

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…

In Part 1, we visited the high level schema of the Visual Studio Load Test Results Database, showing the tables and views that are a default part of the DB. In Part 2, we will look at the built in Stored Procedures and how some of them get used for building results and reports. The…

(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…

I am sharing a set of tools I use during many of my engagements and projects. These tools have been written by myself and my ITSM teammates over the past several years. The zip file includes the following (each item has a Word document explaining how to install and use): C# Project and Item Templates…

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…

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…