dynamox
6 Thallium

Re: Ask the Expert: Performance Calculations on Clariion/VNX

8.2.3.2 Redo Log Files

If the high-I/O files are redo log files, then consider splitting the redo log files from the other files. Possible configurations can include the following:

  • Placing all redo logs on one disk without any other files. Also consider availability; members of the same group should be on different physical disks and controllers for recoverability purposes.
  • Placing each redo log group on a separate disk that does not store any other files.
  • Striping the redo log files across several disks, using an operating system striping tool. (Manual striping is not possible in this situation.)
  • Avoiding the use of RAID 5 for redo logs.

Redo log files are written sequentially by the Log Writer (LGWR) process. This operation can be made faster if there is no concurrent activity on the same disk. Dedicating a separate disk to redo log files usually ensures that LGWR runs smoothly with no further tuning necessary. If your system supports asynchronous I/O but this feature is not currently configured, then test to see if using this feature is beneficial. Performance bottlenecks related to LGWR are rare.

http://docs.oracle.com/cd/B19306_01/server.102/b14211/iodesign.htm

RRR
5 Osmium

Re: Ask the Expert: Performance Calculations on Clariion/VNX

That would be wonderful and a real enhancement since then you don't have to worry about either dis- or enabling FAST Cache!

0 Kudos
RRR
5 Osmium

Re: Ask the Expert: Performance Calculations on Clariion/VNX

Ok, avoid RAID5, but that's in an ideal world. I think that calculating the requirements are always better.

0 Kudos
JonK1
3 Silver

Re: Ask the Expert: Performance Calculations on Clariion/VNX

Yeah, but I'm then also wondering whether redo logfiles should actually be put on RAID5 instead of RAID10. Remember that full stripe writes on RAID5 are cheaper than writes on RAID10. So there the move to RAID5 would actually improve back-end load!?

0 Kudos
RRR
5 Osmium

Re: Ask the Expert: Performance Calculations on Clariion/VNX

Exactly, that’s why I asked… Glad Dynamox came to the rescue!

0 Kudos
dynamox
6 Thallium

Re: Ask the Expert: Performance Calculations on Clariion/VNX

if you are going to dedicate one raid group for specific server, probably yes. But considering how small redo log files are, storage admins like to put multiple server's redo log files on the same RG/Pool. So multiple sequential streams become random writes as far as RG/Pool is concerned. Agree ?

0 Kudos
JonK1
3 Silver

Re: Ask the Expert: Performance Calculations on Clariion/VNX

Agreed dynamox, good point!

0 Kudos
RRR
5 Osmium

Re: Ask the Expert: Performance Calculations on Clariion/VNX

Like I said before, redo logs don't have to be small: I've seen db servers with database drives of 500GB and redo log drives of 250GB !!!!

0 Kudos
dynamox
6 Thallium

Re: Ask the Expert: Performance Calculations on Clariion/VNX

50% of DB ? That's insane, none of my multi-terabyte OLTP databases have redo logs that take up 50% of the database size.

0 Kudos
RRR
5 Osmium

Re: Ask the Expert: Performance Calculations on Clariion/VNX

I know…. These were high I/O OLTP of a University Hospital and they wanted to make sure the transactions were saved (for 2 days I think it was) even without the hourly backup.

0 Kudos