ASE is dropping plan for my procedure too frequently. This causes
procedure to take up more than double the time required to run. how can
i force server to NOT drop the cached plan??

Please help.

SS