See: http://llblgenprof.com/

It's in beta now. We're using it ourselves for a while, great tool . You can use it to easily visualize queries executed, analyze what's going on, which queries take a lot of time etc. etc.

LLBLGen Pro v3.0 recommended, if you're using LLBLGen Pro v2.6, it will work with sqlserver, as it requires DbProviderfactory usage to be able to intercept database activity.