|
Posted by dunleav1 on 09/28/54 11:58
First issue:
I wrote a tsql transaction to insert 200000 records at a time and it
was approx. 20% slower than Oracle. I have Oracle configured with a
large log cache and large redolog - so lot happens in the cache before
a write. Is there any way to configure the log cache to be larger in
sql server or do I just keep giving the entire engine memory? I tried
altered the recovery interval hoping it was part of the computation for
the size of log cache within the engine but with no real improvement.
Second issue - It looks like mssql doesn't handle log/data file
contention as well as Oracle if the log and data files are on the same
array. I know it's not the preferred configuration but I'm doing with
the hardware i have. I don't see any latency on the raid array but the
numbers are lower than Oracle.
Third issue - Sql server does about 50% more context swithing that
Oracle. Even with using pooling instead of threading.
Fourth issue - When going through jdbc - either the jdbc driver or the
engine jdbc/java api is a lot slower than Oracle.
Navigation:
[Reply to this message]
|