C
cjbrandt
Guest
Flushing the buffer pool is a fairly common question in DBA forums for OpenEdge. I have never seen a command that would do it, the normal response is to either restart the db or run a backup or table analysis - without using the -Bp option. DBCC DROPCLEANBUFFERS will flush the database memory blocks, but not the file system cache, similar to if the database was stopped and restarted. If there is a report that runs slowly the first time and quickly after, then that usually indicates the subsequent runs are using data in the buffer pools. You can track the physical vs logical reads a report makes. You could also try removing the "-q" client side parameter so the code in the report will be loaded into memory for each run, otherwise the code stays in memory and that would also make future reports run faster. I can see the case for creating a 11.6.4. Most companies don't bother requesting the latest hotfix when they upgrade. They would upgrade to 11.6.3 and then be at risk for the db crashing during a backup or dbanalys.
Continue reading...
Continue reading...