Community

Performance impact of controller cache: SQL Server read only workloads

(Linchi Shea) In my previous post, I looked at how a typical OLTP workload may be affected by various controller cache configurations. And the conclusion was that giving too much cache (say all 512MB) to reads hurt the OLTP performance. The primary reason was that the writes from the OLTP workloads

Read More - Register for Free Membership