Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sunilts
Starting Member
3 Posts |
 Posted - 2008-11-20 : 10:44:49
|
| I came across a strange issue and doesn't know whatz the cause for that problem.I have a proc on the SQL db which was returning the resultset between 6 and 15 secs. Yesterday I received quite afew notifications from the web server with error message "Timeout occured" when executing the above proc. I executed the proc directly on the server using query analyser, it was taking 3 to 4 min to return the results.... I checked the execution plan, indexes and everything seems to be ok... I recompiled the proc (drop and create).... and everything was back to normal.. same query which was taking 3 min to return the results worked in 2 sec..any idea why this happenend? let me know.. Thanks. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-20 : 10:48:19
|
| may be because of parameter sniffing i guess |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-11-20 : 10:50:11
|
| Here is the issue and read carefully:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=114445 |
|
|
|
|
|
|
Strange issue with SQL Stored Proc.