the way to debug performance on a large sql system is to log things on the sql server itself and monitor for weird queries. Tjis is part of monitoring a db and

the way to debug performance on a large sql system is to log things on the sql server itself and monitor for weird queries. Tjis is part of monitoring a db and this has to be done no matter which tech you used to generate those queries. good ORMs all have a way to fine-control the underlying statements to avoid querying individual rows one by one. I'm fairly proficient with sql queries and i still don't like writing sql queries and binding to objects manually