ONLINE 7.2 tuned to simulate SE x.x
Posted in 1997
We have recently 'upgraded' from SE 5.0 to ONLINE 7.2. Performance dropped dramatically on the first day (2 days back), to about 10% of SE performance. A frenetic 36 hours later performance is up to about 30 to 50% of SE level - the users are no longer tearing their hair out, they just have long faces. With SE, I hardly had any configuration to do. Update Statistics once in a while, keep meaningful indexes, recreate them once in a while, make sure the programs are using them, keep the log on different disk and I'm in business. When using ONLINE, its a different ballgame with the myriad of tunable parameters. It would seem logical that a large majority of parameters of ONLINE are also used by SE, except that the DBA cannot tune them. What are they? And what are their values under SE? ---------------------- Rudy Fernandes GIC, Kuwait ----------------------