Slow Performance With V9

[Keith Owens]

Hello All

HPUX11 32bit
V9.1D09 32bit

We have just upgraded our test system from V8 to V9 and are disappointed to find that V9 can't beat the performance benchmarks we took in V8.

Our startup parameters are set as follows;
-----------------------------------------------------------
-B 50000 # database buffer
# -pwscan 500 # page writer scan
# -pwwmax 5 # page writer max. buffers
# -pwqdelay 100 # page writer max. buffers
# -pwsdelay 1 # page writer scan delay
-bibufs 50
-aibufs 100
-L 150000
-n 150
-Mn 1
-spin 2000
------------------------------------------------------------
We have APW, BIW and AIW running and when I look at promon I get excellent buffer hits - > 95% but the process just takes longer.

Even jobs that simply read & report (no writes to the db at all) take longer.

Are there any obvious ways that I can make the performance of V9 better?

Thanks

 

[ron]

More info, please.

Hello, Keith.

We upgraded from 8.3C to 9.1D two years ago ... and did lots of performnce tests. We're quite pleased with the result ... so I feel that there must be a way to solve your problem.

Tell me ...

1. Are you doing the before/after tests on the very same box?
2. How did you convert from 8 to 9, conv89 or dump/load?
3. Do you know about the <-noshvarfix> startup parameter? Have you used it?
4. What blocksize do you use for the DB, AI and BI?
5. Did you change anything at all in the upgrade process? (ie, blocksizes)
6. Do you use "fixed" or "variable" AI extents?

Ron.