Forum Post: RE: Controls to help high demand for record create

  • Thread starter Thread starter Rob Fitzpatrick
  • Start date Start date
Status
Not open for further replies.
R

Rob Fitzpatrick

Guest
So the BI/AI block size and BI cluster size are set to default, and buffers are set just above the defaults. When the concern is a bottleneck in transaction throughput those are the first things I'd change. Note this does require a DB restart. I'd suggest the following as a starting point; it may not be perfect for your workload but it's an educated guess and better than the defaults: - BI block size 16 KB - AI block size 16 KB - BI cluster size 8 MB - -bibufs 100 - -aibufs 100 Then monitor as George has suggested during periods of high transaction activity and see how your commit rate and other metrics change. Hope this helps.

Continue reading...
 
Status
Not open for further replies.
Back
Top