Thanks a lot for replying. Actually, the stored proc calls another stored proc and hence there are 2 execution plans.Could you please advise on how to improve this proc.

I manurally ran it. Please find the execution plans attached. I am an entry level junior dba and I request your valuable advise.

Do i need to run the stored procedure now to view the execution plan? It is in production and I cannot run the stored proc now. How can i get...

Thanks a lot for your reply. Actually, there was blocking, self-blocking. I am still not able to understand why the response was very slow only yesterday and not in the...

Thanks for the reply

i checked the mirroring state before issuing the failover command. It was showing "SYNCHRONIZED". But when i issue the failover command, i am getting an error tha says mirror is...

Thanks a lot for replying. Take CAre