I have a sp which is timing out on my website. When i run a trace on it, duration comes ~ 80000 (ms)
So it times out as it is set 30s for site. but when I run the same call after copying from trace in SSMS, it hardly takes 2-3 secs. Why profiler show long durations?
I tries same thing for 5-10 calls to be sure that it is not because of cached data. but they are always fast on SSMS.
Is duration column in profiler accounts for Network time or any other times in it?
-----Table Proc Index Performance TSQL &&%$#@*(#@$%.......------------
Deep Into SQL Jungle