Optimise database deployement
Regarding NFS data storage architecture following points are important to get maximum system performance.
- Database server must be recommended with multiple physical hard disks or SAN/NAS with RAID or multiple logical units.
- NFS data files should be deployed on multiple disks as much as possible.
- Index and Data Files should be on separate disks.
- Database block size for OLTP system should be small as much possible like 4k or 8k. So while updating data minimum disk activity required .
- OLTP systems are always write efficient while OLTP/reporting systems are always read efficient. So block size should be big on OLTP/reporting system. Like 16K or 32k. This will read maximum data in less disk activity.
For NFS where business transaction volume is very high with high number of users and concurrency the reporting database should be recommended on separate machine for good system performance.
This post was viewed (40) times.
Multi-tasking: Time Saver or Time Waster? Checklist – The Last Ten Nights and Days of Ramadan…