title: Querying Visual studio 2010 load test data from SQL table
body: <p>I have setup a load test in Visual studio 2010, run it several times, and then exported the data into an SQL database.  It should be the typical way of doing this.  It has all these standard tables:</p>
  
  <p><a href="http://blogs.msdn.com/b/billbar/archive/2006/02/10/what-is-the-data-in-the-vsts-load-test-results-store.aspx" rel="nofollow">http://blogs.msdn.com/b/billbar/archive/2006/02/10/what-is-the-data-in-the-vsts-load-test-results-store.aspx</a></p>
  
  <p>I am try to query the "Time to first Byte" for a specific requestURI in a test.</p>
  
  <p>Any thoughts on how to put together this query?  Where table is the "Time to first byte" for a specific URI actually stored in?  Is there a website that lists common queries for these load test databases?</p>
  
  <p>Thanks.</p>