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.