As the previous poster said, the problem may be that your procedure
cache is too small.

Another option:

While it won't stop ASE from aging the plan from procedure cache,
you can use the Abstract Plans feature to minimize the time it takes
to generate a new plan (as the optimizer will be bypassed).

Cheers,
-bret


SSawhney wrote:
> 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