Hi All,
My Front end people getting time out error in some situation. Also when i see the Profiler its taking around 30Sec of Duration,30Sec of CPU and 234Sec of Reads.
But if i use SET SHOWPLAN_ALL, it is showing less number of consumption time taken for execute a Procedure.
I want to know,for this slow down of Procedure any Server level Setting is there?
---