Track linq queries causing issues

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.

Peter

They are found on the APP Server in the directory where Epicor is installed. Then you navigate to:

...\Websites\<<InstanceName>>\Server\BPM\Sources

Remember though, there are many versions in those directories, so you will only want the latest one.

What you most likely will look for are ones that make direct joins from Db.<<tablename>> to the temporary tables.