Load Test Transactions and Pages Relationship (in the LoadTest2010 Database)

Question

To All:

Once a load test is completed and you look at the results you naturally want to create a heirarchy of things. That bring decomposing the test into to respective components for reporting. In my case I want to do this:

Load Test

Test Case

Transaction

Pages within that transaction

However, I can see three of these four but not a link between test case to transaction to page.

It jumps form Test Case to page.

There seems to be no relationship defined for this in the database. Yet it saurely exists as the test runs it that way and that is recorded in the scripts.

SO has anyone found a way to relate the tese three things in the database?

Thanks!
Ken

Answer 1

Hi Kabaker551111,

Thank you for posting in the MSDN forum.

You wrote that “I can see three of these four but not a link between test case to transaction to page.

It jumps form Test Case to page”. If possible, you can provide some detailed information through a screenshot to tell us what you have seen so that we can understand your issue better.

Best regards,

---

Amanda Zhu [MSFT]
MSDN Community Support | Feedback to us

Answer 2

A screenshot will not really do anything as you can't see it from the UI. You can in an entity relationship diagram for the repository itself. I suspect a DBA would immediately see what I am talking about :-).

Thanks!
Ken

Answer 3

Hi Ken,

Based on your description, we still can’t understand your purpose clearly. Now we could not repro your scenario. So I would like to know where you see the Load Test, Test Case, Transaction and Pages with that transaction. What are you want to do for these four in your case? And what’s the database that you said? Does it store the load test results? Is the database a SQL Server database? In addition, is the test case related to MTM?

If possible, you could provide more detailed information and give us a screen shot that can indicate what you are doing and what you have seen.

Thanks for your understanding and support.

Best regards,

---

Amanda Zhu [MSFT]
MSDN Community Support | Feedback to us

Answer 4

Hello Ken,

What about your issue now? Have you resolved it?

Can you give an example of what you are trying to do?

Best regards,

---

Amanda Zhu [MSFT]
MSDN Community Support | Feedback to us

Answer 5

Amanda,

I actually did reolve it, but the resolution is a short term hack :-). I used Sean Lumley's extensions (see here -- http://blogs.msdn.com/b/slumley/archive/2008/09/11/reporting-on-web-tests-using-new-web-test-api-s.aspx) and updated a plugin I already have with pre and post page events to write to an extra column in the page table of the extensions the active transaction.

The long term solution would be a new table in the load test repository database that does the same thing elegantly and fits the normalization scheme of the database.

Thanks!

Ken