March 3, 2003 at 7:12 am
I've got a preconfigured Win2K server with IIS5. I need to install SQL 2K server on it.
The system specs are as follows:
processor - Intel 1.2ghz Celeron
memory - 640mb
hard drives - 3 drives at 40gb each and 2 volumes per drive
drive 1 - 20gb Operating System and 20gb free
drive 2 - 20gb for Web project site files and 20gb free
drive 3 - 20gb free and 20gb free
How should I install/configure SQL 2K server on this preconfigured test server to get the best results for IIS and SQL server?
Thanks,
William
March 3, 2003 at 7:49 am
Not much to work with. I'd put the data on one, the log files on the other. Without RAID you're living on the edge, definitely should do frequent backups and copy to another physical disk. With the amount of memory you have I'd expect that performance won't be great. Typically you install SQL on a stand alone box so it doesn't have to share memory. Probably best bet is to configure to use dynamic memory (the default) and see what happens.
Andy
March 3, 2003 at 10:26 am
Andy,
Thanks for the feedback. I too, agree with the need for RAID - (RAID5) and using SQL's dynamic memory. I mentioned that another box was need for the SQL server. However, I was told that the budget is very small. What do you think about the following configuration?
memory - min 1 gig (purchase another 512 stick)
drive 1 - OS 20gb volume with the SQL server install and SQL data files on the other 20gb volume
drive 2 - 20gb volume web files with the SQL log files on the remaining 20gb volume
drive 3 - backup - web files, SQL data and log files
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply