Comprehensive Benchmark for
Automatic Storage Management
Bert Scalzo, a noted Oracle benchmark expert has
a great paper on using Oracle10g Automatic Storage Management (ASM)
with Oracle:
http://www.linuxjournal.com/article/8539
Here we
have a clear-cut winner. The LVM ran 30% faster, achieved a 25% higher
transaction per second rate, scored 56% faster on kilobytes per second
and had a 108% better average response time. I suspect that the real
differentiator here was the temporary segment allocation necessary for
the large GROUP BY and ORDER BY operations.
Scalzo concludes About ASM:
So,
what does all of this mean? For people doing RAC, ASM is a viable and
credible approach for disk space management, with numerous
administrative and maintenance benefits to its credit. But for those
simply doing non-RAC database deployments, ASM is not yet as scalable
as the Linux ext3 filesystem using an LVM. And while all these
benchmarks were done using the standard LVM included with Red Hat and
other popular Linux distributions, it's quite possible that an
enterprise targeted LVM, such as those available from either IBM or
Veritas, would best even these results. Therefore, for people not
doing RAC who care more about performance than administrative ease,
for now you should stick with the Linux filesystems and an LVM.
|
