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:
Visual Studio uses this data, along with some built in views to build the graphs it shows as part of the load test results. It does NOT use this data to build any of the tables shown in the results (see the example below to understand what results I am describing here. For more information on the LoadTest2010 DB Schema, see this post from Sean Lumley).
See my new post that contains a tool for both IMPORTING and EXPORTING perfmon counters.
Running this I get the following error "the number of elements in the select list exceeds the maximum allowed number of 4096 elements".
Could you please let me know what needs to be done.
I am guessing that the number of unique counters stored for the run in question is too large for the type of SQL I am using to export the results. Since I have to build a dynamic query and then pivot it, I am limited to a total of 4096 unique columns in the final set.
The best thing to try is to narrow the scope of the result set by making the instance name more specific. You'd limit the number of counters you get back that way. Maybe something like '\\COMPUTERNAME\ASP%' or '\\COMPUTERNAME\Process%'