SQL

[Ayman Altounji]

Who does a bigger "Level 2 Cache" will influense my SQL7 performance ?

[Ayman Altounji]

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

[Ayman Altounji]

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]

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