When you say you have memory concerns is this because you're looking at perfmon or task manager stats?  Keep in mind SQL will take all the memory it can up...

I tune for response time first and resource usage second for on premise.  In azure I tune to reduce DTU usage (i.e. resource usage) first and response time second (so...

Was it in a "RUNNABLE" or "RUNNING" state or both.  The estimated rows does look odd.  It's a little hard to say for certain without looking at the plan what...

Can you run the following two commands in SSMS and then run the proc from the same session.  After you execute, copy and paste the output that displays in the...

ALTER DATABASE SCOPED CONFIGURATION CLEAR PROCEDURE_CACHE;