How do you approach performance tuning for a database that supports both OLTP transactional workloads and OLAP analytical workloads on the same system?

Sample answer preview

Supporting both OLTP and OLAP workloads on the same database is one of the most challenging performance tuning scenarios because these workloads have fundamentally conflicting resource requirements. OLTP needs fast response times for small, frequent transactions.