Dan Foreman Brave. Point, Inc. danf@prodb. com 1
Progress User since 1984 Guest Speaker at USA & European Progress Users Conferences since 1988 2
3
4
Largest Single DB? Largest Concurrent DB Connections? Progress Version? Database Operating System? 5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Lots of misinformation &opinions about Direct I/O (-directio) Added in V 6 but only applied to Data General and Sequent Platforms Starting in V 8 applies to all platforms but the Progress Documentation wasn’t updated right away Database Startup Option 21
22
Database Block Size 4 k-8 k General: Match DB Block Size to File System Block Size Set the File System Block Size is as large as possible Increase in DB Block Size may mean a reduction in –B Dump/Load is required to change the Block Size 23
Fixed Size Data Extents Don’t grow into the Variable Extent Not as crucial as it was in the 90’s when Storage was slower Large Extents (as large as triple digit gigabytes) are not a performance problem if you are using a “modern” OS and Storage Device 24
25
26
Disks are the Slowest Server Component We recommend Lots of Striped Database Disks 1999: 9 gb & 9 -14 ms Average Access 2009: 144 gb & 6 -9 ms Average Access 2012: SSD are <. 2 ms Average Access 27
Separation of After Image, Before Image, and Database Disks Mainly for Integrity (especially AI) Secondarily for Performance (maybe) Try to not Stripe DB/BI on the same Volume 28
RAID 5 is (almost) always EVIL! RAID Levels are not precisely crafted standards (like USB 3. 0, etc. ) SANs are very complex devices RAID 10 requires more disk space than RAID 5 Hybrids may be acceptable (RAID 5 for DB, RAID 10 for AI/BI) YMMV 29
Stripe Size for RAID 0, 5, 6, or 10 The Largest Stripe Size usually produces the best Performance YMMV (or YKMV for some of our international audience) 30
Have a third party look at your system once a year Doesn’t need to be me - competition is good You may be surprised at what you’ve missed or has slipped through the cracks It’s like car insurance… 31
32
Скачать презентацию Dan Foreman Brave Point Inc danf prodb com 1
967fcc162d9b13ca2216f59fca263bff.ppt