DBA

• Why are Type II storage areas important for indexes?
• Where is the ProTop source code?
• After image roll-forward recovery
• Why -lruskips 100?
• Tuning your database buffer pool (-B)
• Need to restart OE Replication?
• dbanalys for large databases
• Windows - Correct probkup and db startup priority
• The all-important (to ProTop) database analysis
• Check your schema for "gotchas"
• Upgrading the OpenEdge version ProTop is using
• How to find processes using the most memory on Linux (dirtymem.sh).
• Managing extent size
• How to get the latest version of ProTop
• Are you seeing Object Manager (OM) waits? Did a health check indicate omSize 1024 = 1024 (the default)?
• Got remote clients? Use prefetch!
• ProTop Administration - What is it?
• Dump & Load Scripts (^d) - FREE
• Dump & Load Scripts (^d) - PAID
• A Dump & Load Component Checklist
• Why Does SYNCIO Seem To Disagree With My IO Throughput Test? (Or My Vendor's Promises)
• Use CDC to migrate bothersome tables.
• How to run a ProTop utility or report standalone
• Upgrading OpenEdge
• Does your AI block size match your BI block size?
• Tuning OpenEdge Database Connections
• OpenEdge database log truncate and archive
• OpenEdge database backup best practices