Re: Solaris Priority Paging and Database products.

From: Paul Rogers <paulrogers_at_home.com>
Date: 1999/09/10
Message-ID: <37D8F94A.8E58783A_at_home.com>#1/1


    I have implemented it for a large customer running SAP/Oracle on a large E10K domain. I don't think it directly contributed to a performance
increase. The trick today is not to be memory starved. This domain had 20GB of memory. That meant that fsflush was running like crazy but not that we were doing real paging. We tuned the entire memory system including priority paging and fsflush parameters like slowscan and handspreadpages and saw some improvement. Further investigation revealed some horrific joins in the custom stuff added to SAP and once those were tuned performance really settled down.

Paul Rogers
Sun Professional Services

Richard Yates wrote:

> A quick question - has anyone implemented priority paging on Solaris
> and noticed a performance change with their database product? If so,
> I shall be very interested to hear any conclusions reached! I have
> done some testing, but due to certain factors formed no firm ideas,
> other than "it *should* be a good thing".
>
> Richard Yates.
> --
> Erratic news-swerver! :. post+e-mail to be sure I get your msg.
>
> The Open University is not responsible for content herein, which
> may be incorrect and is used at reader's own risk.
Received on Fri Sep 10 1999 - 00:00:00 CEST

Original text of this message