[louissan]

Hi all,

I just got this quadri-cpu monster.
Inside:
- Quadri PIIIXeon 700 / 2 MB cache
- 4 GB ECC RAM
- RAID disk arrays

The beast is to be used for FAST SQL database access. Enven though we know
it's to run efficiently, we're looking
for URLs or websites which could tell
us how to fine-tune performance for
heavy random read/write accesses in a
database environment.

Thanx for your help

Cheers


Louissan

[Intlharvester]

Database tuning is a wizardly art and depends a lot on your application. I suspect the reason that you can't find a webpage is because the people who know are too busy making $200/hour to give their knowledge away for free.

You could start with "Inside SQL Sever 7" from MS Press, which is a great book about MSSQL internals, and then start connecting the dots, but that's gambling with what is probably an important production system. (I assume if this wasn't MS-SQL, you probably wouldn't be on NT.)

Or, you could figure that you have an expensive box, and expensive applicaiton, and you might as well open your wallet again and get some expensive tuning help.

[louissan]

Thanks for that...
I found something at MS press, which I
downloaded and it's quite interesting.
The name is 'Microsoft SQL Server 7.0
Performance tuning guide'.

And yes, we use SQL server (not Oracle).
No offense huh ?

Cheers and thanx

Louissan