I am using following to free up buffer and catch (Only for testing , to find speed of SP in diffrent situation)
is there any thing else i can add to following list.
some body suggested me, one shouod not bother about these thing but i wanted to know.
Q) We know DBCC DROPCLEANBUFFERS automatically flushs it self , based of memory and buffer/catch hit ratio.
Please tel me how and when this gets flushed or not used DBCC FREEPROCCACHE