topic SQL in ProLiant Servers (ML,DL,SL)

SQL

Ayman Altounji — Fri, 22 Dec 2000 00:00:00 GMT

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

Re: SQL

Ayman Altounji — Wed, 27 Dec 2000 00:00:00 GMT

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

Re: SQL

Ayman Altounji — Thu, 28 Dec 2000 00:00:00 GMT

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

Re: SQL

Ayman Altounji — Fri, 09 Mar 2001 00:00:00 GMT

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