Viewing 6 posts - 1 through 6 (of 6 total)
I found the pb
by using SET arithabort off, I reproduce the low query
in my SP, I use option (keepfixed plan)
by turn off this option, my SP is faster
October 30, 2012 at 4:17 am
there are no locks or deadlocks, application timeout is set to 30 seconds
in SSMS the SP run in 1s
one more time, when I set application connexion string to "current language=english"...
October 26, 2012 at 2:59 am
1) drop and recreate SP => dont' work
2) clear all cache for this SP => don't work
3) restart SQL => don't work
4) created a new SP with a different name...
October 25, 2012 at 9:59 am
I don't understand, the same SP with with the same parameters timeout in profiler but not in SSMS
October 25, 2012 at 3:32 am
thanks for your answer but there is no physical reads
September 1, 2010 at 10:11 am
Viewing 6 posts - 1 through 6 (of 6 total)