Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in August and this forum will be retired.

Hello Everyone

I want to make a choice for the CPU in a new server configuration, I have seen that current Intel Xeon CPUs have various L2 cache sizes 4,8 and 12MB. Do database application like ASA 9 use and take advantage of the extra L2 cache size in a 32-bit Windows Server configuration?

Thank you in advance


asked 31 Aug '11, 03:48

Nikos%20Samaras's gravatar image

Nikos Samaras
accept rate: 0%

The L2 CPU cache is not managed by SQL Anywhere; it is managed by the operating system. The amount that the L2 cache that will be used is defined by the registry key 'SecondLevelDataCache', available on some Windows platforms. See your operating system documentation for more info about controlling the L2 cache size.

As with all performance tuning recommendations, "it depends" on your workload type whether the extra L2 cache makes a difference. For instance, the related CPU time on a query may not be relevant if your query is really I/O-bound and most of the execution time is spent working against the disk. In that particular use-case, "all CPUs wait at the same speed", so the L2 cache usage on the CPU isn't really going to be a factor.

As John mentions here, some server threads do try to maintain processor affinity to try to eliminate the need for moving large amounts of information around in the processor caches.

The best way to decide if a bigger L2 cache really makes a difference to your workload is to set up a well-designed performance test, that will control for as many performance factors as possible.

permanent link

answered 31 Aug '11, 12:15

Jeff%20Albion's gravatar image

Jeff Albion
accept rate: 25%

edited 31 Aug '11, 12:16

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 31 Aug '11, 03:48

question was seen: 1,854 times

last updated: 31 Aug '11, 12:16