Time out occured calling SP from webpage | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Time out occured calling SP from webpage

Hi, I have a stored procedure returns a small result set (20 rows and 5 colums apprx).
When I run this SP from QA it takes only 3 – 5 seconds to give me back the results, but when I try to execute the same thing from a web page it takes more than 30 seconds to execute and times out. To eliminate any possibility of IP connections, I have installed the webserver on the same server as SQL server and also tried to open the pages from localhost. If anyone has any suggestions, please let me know. Thanks in advance.
While running the sp from Webpage, capture all the activities in profiler
and check whether it is because of Parameter Sniffing.
]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |