 |
|
Oracle Tips by Burleson |
Database Characteristics that should have all
files moved to SSD
There are some databases that should have
all of their files moved to SSD. These databases tend to have at
least one of the following characteristics:
High concurrent access: DBA’s managing
databases that are being hit by a large number of concurrent users
should consider storing all of their data on SSD. This will ensure
that storage is not a bottleneck for the application and maximize
the utilization of servers and networks. I/O wait time will be
minimized and servers and bandwidth will be fully utilized.
Frequent random accesses to all tables: For
some databases, it is impossible to identify a subset of files that
are frequently accessed. Many times these databases are effectively
large indices.
Small to medium size databases: Given the
fixed costs associated with buying RAID systems, it is often
economical to buy a SSD to store small to medium sized databases. A
RamSan-210, for example, can provide 32GB of database storage for
the price of some enterprise RAID systems.
The above book excerpt is from:
Oracle RAC
& Grid Tuning with Solid State Disk
Expert Secrets for High Performance Clustered Grid Computing
ISBN:
0-9761573-5-7
Mike Ault, Donald K. Burleson
http://www.rampant-books.com/book_2005_2_rac_ssd_tuning.htm |
