Re: Problems with inconsistant query performance.

In response to Matthew Schumacher <matt.s@aptalaska.net>:
>
> What I really need is a way to profile my proc when it runs slow so that
> I can resolve which of the queries is really slow.  Anyone with an idea
> on how to do this?

You could turn on statement logging and duration logging.  This would
give you a record of when things run and how long they take.  A little
work analyzing should show you which queries are running when your
favorite query slows down.

--
Bill Moran
Collaborative Fusion Inc.