RE: SAP DB vs MS SQL Performance

[Dirk Ringe]

Also I would think that for raw insertion of records the db ist not that much CPU bound. The 4 way box probably pays of if you stress it with lots of parallel client requests. But I would also like to see some benchmarks of SAP DB in comparison to MS SQL and Oracle on the same hardware.   Dirk -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of detlef schulze Sent: Monday, September 30, 2002 11:23 AM To: [EMAIL PROTECTED] Subject: Re: SAP DB vs MS SQL Performance A four way box isn't automatically faster than a single CPU machine. In fact some tasks are much slower (memory allocation for example). The reason to use a 4-way machine is usually it's better scalability and availability.   Did you set the instance parameters of the db for a multi-cpu machine according to the manual (MAXCPU etc.) ?   [...] 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   [...]