Re: SAP DB vs MS SQL Performance

[detlef schulze]

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   [...]