I have an application which gives timeout at times when you try to execute a stored procedure. The stored proc takes only few seconds to execute while running in the query analyzer. When you call the SP from application, it gives time out message at times. How do we troubleshoot these issues in live.
...
Go to the complete details ...