Performance tuning a Progress 9.1D09 64bit on HP-UX 11.i OS

[MightyMouse]

Can anyone help me with performance tuning a Progress 9.1D09 database on an HP server with HP-UX 11.i OS?
We have a 70Gig progress db and a 10Gig database, Raid 0+1 split across disks. On a HP L2000 server, 2 CPU's, 8Gig RAM and 100 user license.

The users are on Win2K PC's and Citrix Servers. How can I get the best performance out of this database?

70Gig db --------------------- 10Gig db
ready> pg Supprs.pf --------- ready> pg dbext.pf
-H MyServer ---------------------- -S dbext-prod
-S Supprise-prod ----------------- -B 15000
-B 240000 ------------------------ -L 5000
-L 160000 ------------------------ -n 200
-n 200 ---------------------------- -Mm 8192
-Mm 8192 ------------------------ -spin 2000
-spin 2000 ------------------------ -Mn 20
-Mn 30 ---------------------------- -Ma 10
-Mpb 20 --------------------------- -directio
-Ma 10
-directio

Currently -------------------------- Soon to be
Shmmax - 67108864 Static ------- 1073741824 Dynamic
Shmseg - 120 Static --------------- 21 Dynamic
Shmmni - 202 Static
Shmseg - 120 Static

I have just installed 64Bit Progress on this machine with a 64Bit OS and want the best performance from it.


Thanks,
Mike

 

[ron]

Hello there, MM!

None of what you've listed-out looks "bad" ... but please let me ask a few more questions ...

** What DB block size do you use?
** What's the blocksize of your BI?
** Do you use AI? If so - what's the blocksize? (If not ... why not?)
** How many discs is the DB spread across? Do these discs have ANY other files on them? What interlace was specified when the RAID was set-up? Also, when the RAID was set-up, has a RAID 0+1 situation been created, or 1+0? (The difference is important.)
** Are your BI extents on a disc that is used by NOTHING else at all?
** If you use AI, are the AI extents on a dedicated disc?
** Have you specified -noshvarfix?
** Do you truncate the BI "frequently" - or do you just leave it alone?

Ron.