• Hello mkarthikeyan,

    It would be hard to suggest without having a look at the code. To make a start, check the execution plan of the stored procedure and see which part is taking the longest time and start working on that part. Check the following link for a general idea on improving performance of SPs.

    http://blog.sqlauthority.com/2010/02/16/sql-server-stored-procedure-optimization-tips-best-practices/