Set L2 cache per CPU to 2 MB

• gary1

  SSC-Insane

  Points: 21152

  More actions

  June 10, 2011 at 5:20 pm

  #251841

  Hi,

  I'm configuring the memory settings for SQL Server 2008 R2 which is hosing Share Point 2010 databases and MS recommends the following:

  On the server that is running SQL Server 2008, we recommend that the L2 cache per CPU have a minimum of 2 MB to improve memory

  Please advice where to set L2 cache per CPU to 2 MB ?

  Thanks

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736270

  More actions

  June 10, 2011 at 6:23 pm

  #1337335

  L2 cache is built into the chip. You cannot set it. When you buy hardware, you pick a CPU with at least 2MB of L2 cache.