We have a lot of customizations in BPMs, Configurators and BAQs. I monitor my SQL environment and often find linq driven queries that are just terrible. Long run times and huge transaction increases. Slows the entire system.
I am having trouble having tracking the source of these queries. I have the SQL but with the app server accessing SQL under the same account and nothing in the resource monitor, how can I find the method directive (C#) or user that is generating the linq queries.