Order workflow taking high buffer reads for each execution
Hi Team
Order processing workflow causing issue in PROD instance.
In Developement instance we did not found issue.
As per the customer ,in the workflow one of the procedure is causing issue and its taking high buffer reads.Can you please help
If any procedure call taking high buffer reads 400K for each execution ,can we tune the further.
I have checked each SQL buffer and execution time ,seems there is no issue.
Thanks
Sampath