As part of the Performance Tuning series – Performance Stack , this section looks at Buffer Managment tuning. The purpose of the series is a general approach to Performance Tuning – independent of database server platform. A large proportion of DBAs support more than one type of database server and a methodology allows them to apply to all platforms. Memory usage Measure and assign memory space for IO and memory data structures e.g procedure cache Ensure the buffer space is sufficient. To low buffer space for DBMS memory requirements causes a low hit rate. A low hit rate is where... Read more →