Inherited this massive stored procedure with views, scalar udfs, etc. Looking at the plan, what are recommendations? Thanks

chsqlsentry 2017-06-16 19:39:03

First pass, we've eliminated some compuited columns using scalar UDFs and restructured a few things. It runs "ok" for one execution, but breaks down as number of simultaneous users grows. Using jmeter/blazemeter to generate load tests.