cancel
Showing results for 
Search instead for 
Did you mean: 

SQL

Ayman Altounji
Valued Contributor

SQL

Who does a bigger "Level 2 Cache" will influense my SQL7 performance ?
3 REPLIES
Ayman Altounji
Valued Contributor

Re: SQL

The larger your level 2 cache is, the better your SQLy performance. This is true, however, with any software.
Ayman Altounji
Valued Contributor

Re: SQL

the size of your L2 cache only starts to really affect performance when you scale beyond a single processor, and then only when going to 4 and up.
A certain amount of cache is used to provide cache coherency between each processor. Good rule of thumb is if you are buying a box that supports 4 processors then you can afford 2MB cache processors coz thats the only way you will take full advantage of the potential offered by 4 processors.
SQL tuning requires a lot more than just cache ......
physical memory x 3 for pagefile
seperate system, pagefile, transaction logs and db disks, NT tuning
etc etc etc
look it up, theres loads of data on tuning sql produced by compaq and MS
Ayman Altounji
Valued Contributor

Re: SQL

See the Compaq Engineering white paper on configuring SQL 6.5 in an NT 4.0 OS environment on Compaq Proliant systems. Many of the items covered apply to SQL 6.5 and 7.0 versions.

http://www5.compaq.com/support/techpubs/whitepapers/415a0696_2.html