best disk performance - DB or log file

[jsuez]

Hi,

I'm building a new 6.2 server and have installed a Micron P420 PCIe SSD card. I also have a RAID5 array with SSDs. The P420 is super fast, faster than the SSDs.

So, my question is this: Who should get the best performer the DB or Log file? I understand the entries are written to the log file before they are committed to the DB.

Thanks,

 

[SniperKing]

Hi, no doubt it should be DB, while the log file is not that I/O intensive.

 

[marclant]

I agree, priority on the DB.

You can check the Perf Guide, they have a good checklist for both:
DB: http://ibm.co/1aHiVZf
Logs: http://ibm.co/1hQSS0z

Note that I picked the info from the 7.1 Info Center and I know you are going to 6.2. The reason for that is that the 7.1 Performance Guide has been revised and is still applicable to 6.2. Also, you would be all set if/when you go to a more recent version down the road.

 

[moon-buddy]

I would toss in a different viewpoint - I say make them equal.

The LOGS are used as much as the DB is. Faster is better.