VSTS Tip: Collecting SQL Trace information on load tested web apps

On a test app that I was load testing, I wasn’t seeing any SQL trace information even though I was quite sure the web application was getting its content via a backend SQL database on the same machine.  As it turns out, the default is that the SQL trace will only capture queries that take longer than 500 milliseconds.  Apparently the way to get information for shorter running queries is to dial down the Duration property.  

Comments (1)

  1. Visual Studio Team System

    Yesterday marked the one-year anniversary of the public announcement of…