Svein Erling Tysvaer wrote:

>
>
> Hi Richard!
>
> Just to be certain - you have checked the queries of the app itself?
> Poor design (e.g. asking for all too many rows or count to show a
> progress bar) or poor plans chosen by the optimizer are quite common
> reasons for poor performance, and fixing such issues have far greater
> impact than any configuration tweaking.
>
> Set

Unfortunately I'm no DBA and wouldn't know how to even start. We are
however hassling the software company who's app it is and they are
looking at/fixing various issues as they find them.

As the guy looking after the IT there in general, I'm basically just
trying to get a reasonable config that I can put in there so I can then
go back to the third party and get them to look further at the application.

-- Richard