Hi,
We are moving database from MS SQL on PC server to Sun E450. The current database is MS SQL 2000 on a Single CPU Dell 1300 PC Server (550MHz PIII with 1GB Memory). E450 is 4 CPU (450MHz) with 2GB memory. We thought SAPDB should be more powerful than MS SQL. We did a simple test after installed the SAPDB64 on Solaris 2.8 (64bit). The result surprise us. We use three clients to concurrently insert 10,000 small record (64 bytes) into db. The average time is 37, 216ms on SAPDB on 4 CPU Sun Box. But MS SQL only used 18,764ms to do the insertion. The default setting ws used on both SAP DB and MS SQL. This picture is deadly wrong. There should be no way a 4 CPU Sun Box slower than PIII Intel box. Any suggestion what can cause it
Thanks
Dave
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
