w2k and quadri-Xeon
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 r ...
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
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
Participate on our website and join the conversation
This topic is archived. New comments cannot be posted and votes cannot be cast.
Responses to this topic
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.
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.
