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 |
|
wmanu
Starting Member
1 Post |
 Posted - 2008-09-19 : 05:11:53
|
| Hi There,I'm having 150 lines of SQL statements, with 5 parameters, executes in 12 seconds. But when I make a Stored Procedure out of it (with exactly the same 150 lines of code) with 5 input paramentes, the execution take from 5 to 10 minutes.There is a huge difference in execution time 12 sec vs 10 minutes for exectuing the same code. Has anyone experianced this before? Many thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-19 : 06:22:56
|
| this may be due to parameter sniffing |
 |
|
|
|
|
|
SP Executes For Long Time