K
Kai Lahtinen
Guest
Hi! One of our customers is facing serious performance issues as they are testing a new production server. The current server is Windows 2003 Server and the new server is Windows 2012 R2 Server. Both are blade servers (not virtual). OpenEdge version is 10.2B08 32 bit. The database is copied using backup files and all the database startup parameters are the very same. The database interbal size is over 300 GB. When running online backups and batch jobs it can last over two times more with the new server altough during these tests AI was not enabled in the new one. Both servers have SAN disk system and the database is placed on E: (Data), F: (Before Image) and G: (After Image). The SAN disk system is different: Current server, Primary storage platform HDS Virtual Storage Platform (VSP), write cache enabled New server, Primary storage platform IBM SAN Volume Controller IBM_2145:SVC (code_level 7.6.1.7, build 125.2.1702091228000), no write cache All the data is placed on type II areas and indexes are on different areas. The total number of areas is 46. Database startup parameters: Database Blocksize (-blocksize): 8192 Number of Database Buffers (-B): 80000 (too small because of the 32 bit version) Number of Alternate Database Buffers (-B2): 100 Current Spin Lock Tries (-spin): 50000 Before-Image Cluster Size: 524288 Before-Image Block Size: 8192 After-Image Block Size: 8192 Number of After-Image Buffers (-aibufs): 40 BIW, AIW and APW are used. Any ideas what might be the problem? Our plan B is to update to version 11.7 64 bit ASAP. Regards Kai
Continue reading...
Continue reading...