I am using SQL server R2.
I have stored procedure which takes too much time to execute.
I have posted estimated plane here,
https://www.brentozar.com/pastetheplan/?id=rk6Z6MKxfCan anyone help me to find out why my stored procedure is slow.
--------------
We have AWS server for testing. Same stored procedure doesn't take much time on our testing server (same Sql server 2008 R2) or our local server (SQL server 2012).
But our clients server it runs too slow.
Welcome to SSC Harshada
The estimated plan is no good to anyone, we need the actual plan to see what is actually going on. Please take a read of the 3rd link in my signature for help on posting performance problems.
Also can you confirm what index and statistic maintenance is done on your clients server?