HTAP systems face the engineering challenge of resource isolation versus performance trade-offs: large aggregation queries may saturate CPU and memory, slowing down critical transaction writes, while resource isolation itself may sacrifice efficiency.