– Tuning single instance first

– SQL Tuning is most beneficial
– Buffer cache size is very important
– Use sequence cache
– Use partition table
– Reduce long full table scan (OLTP)
– Use selective,correct index
– Use automatic segment space management
– Private Network/Interconnect 1/10 Gbit Ethernet Infiniband