- Last Updated: [[2020-12-04]] - [[Load Testing]] [[Tableau]] [[Visual Studio Load Testing]] - In Tableau, you can connect to this results store by connecting to a new Microsoft SQL Server database and entering the connection string `(LocalDB)\MSSQLLocalDB`. Select the LoadTest2010 database. - Double click on the LoadTestTransactionDetail table. This table should have all the detail for the transactions, consisting of the following columns: - `Load Test Run ID, Transaction Detail ID, Test Detail ID, Timestamp, Transaction ID, Elapsed Time, End Time, In Measurement Interval, Response Time` - The Transaction ID will be automatically assigned. In order to see the transaction name corresponding to the transaction ID, look at the table `WebLoadTestTransaction`. - Be careful when attempting to join `LoadTestTransactionDetail` and `WebLoadTestTransaction`. For some reason, creating a join of these tables in Tableau causes all transactions to have exactly the same response/elapsed time. This is due to the tables being joined on the wrong columns. To avoid, this, click on the Venn Diagram in the Data Source window and make sure that they are joined on two fields: `Load Test Run ID` and `Transaction ID`. - User Load and Performance Counters can be found in the table `LoadTestComputedCounterSample` under the folder Views.