SQL Server Performance Forum – Threads Archive

New installment

Hi We have the following setup W2k server with IIS 5.0
Asus P4P800E Deluxe Mobo
P4 2,8 Mhz – 1 Gb Ram
3 sata harddisks 1 hd = 2 partitions
c: boot/system
f: backup 2 hd’s in a raid 1 (mirror) Intel Raid ICH5R chipset onboard controller
e: webroot Where would be the best partition/hd to install a MS SQL
2000 databas with regards to performance? It’s possible to install a 4th ide harddisk if this can speed up performance. Tia

I almost forgot the most important point to tell
you that the server is supposed to run database
driven asp.net web pages. Sorry [:I]

I would invest in the 4th harddrive if I could afford it. Also, up the RAM on this box. You’re really going to struggle with 1gb of RAM, if the server gets any traffic at all. I would go with two mirrored sets. Depending on how much you’re going to be using the RAM or paging, and depending on how much traffic and load you need for IIS, it could be better to put MS SQL on either array. So, we can’t really give you an educated decision on this w/o more information. [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />] RAM RAM Also, when you set this box up, be sure to set the max memory on SQL Server. Otherwise, you will quickly choke the system. Depending on how complex and demanding the IIS apps are, you might also need to mess with the memory, CPU, and network settings at the app pool and website levels. It could be fun if this gets much usage. It’s not really much of a box for a big load. MeanOldDBA [email protected] When life gives you a lemon, fire the DBA.

Thanks for your answer. I was however disappointed to read that
our investment in this completely new box don#%92t comply the
specifications of a â€œgood boxâ€ Hardware requirement for the ms sql 2000 database Processor Pentium 166 MHz or higher
Memory 32 MB RAM (minimum for Desktop Engine),
64 MB RAM (minimum for all other editions),
128 MB RAM or more recommended
Hard disk space 270 MB (full installation),
250 MB (typical),
95 MB (minimum),
Desktop Engine: 44 MB
Analysis Services: 50 MB minimum and 130 MB typical
English Query: 80 MB Here we are screwed again by the profit seeking computer industry. Goodbye
[xx(]

[<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />] I didn’t say it’s a bad box. I said "for a big load", it’s not much. You’re not getting screwed by the profit seeking computer industry if you don’t plan well. You’re screwing yourself. There’s a big difference. This box might be completely sufficient for this particular task. It depends how much of a load you need to put on it. I was trying to point out the first breakpoints you will encounter though if the load gets very high. For a combination SQL Server/IIS server, you will probably first encounter issues with the fact you only have 1gb of RAM. After that, the next likely breakpoint will be your disk subsystem. All of this depends on what the box is used for though. Set it up and test it. See how it performs. Tune what you have. If it’s not enough at that point, you buy something else. MeanOldDBA [email protected] When life gives you a lemon, fire the DBA.

]]>