April 3, 2005 at 6:23 pm
I need to buy a new server that will host both a website and a SQL Server 2000 database. We will be upgrading to SQL 2005 later. I plan on picking up a new Dell box but don't have unlimited resources. The website is pretty active with a wide variety of db searches being performed. Was going to go with:2 Xeon 3.2 Ghz,2 GB ram.
What I'm trying to determine is what disk/raid configuration to use. I know that optimally you want to migrate different elements to different raid drives such as the pagefile,tempdb,indexes,transaction logs, etc. but I don't have the $$$ to do this. I believe that I will be limited to 4 drives with 2 channels on the raid controller. I was thinking of doing a Raid 1 on the first with the OS, DB & website on that and Raid 1 on the other channel with the transaction log,tempdb and the pagefile on that. Does this sound good?
If a better solutions exists with a couple of more harddrives please suggest. But please let me know what can be done with a 4drive/2raid channel system.
Thanks to all for comments in advance.
April 5, 2005 at 3:46 am
Hello!
INHO I think there are more issues to care for, like security and 'what you care fore most' (website or db). Licensing is not a problem since you are allowed to restrict SQL to use only one proc (since your website is pretty active, I guess you should go for a 'license per proc').
The 2-nd XEON is > 1000$, so I would rather buy the server with one proc only and spend 1000+some_more for the webserver. For security reasons...
Also, I should go for a separate location for db. I would rather mix OS with the web instead of db.
HTH,
Emanuel
April 5, 2005 at 4:43 am
I'd isolate the web and sql to seperate boxes - putting them together is not a good solution for either performance or security.
As to the rest it depends upon the expected load on your system , you need to analyse that before making guesses about the hardware. I'd recommend any of the sql books but you might want to check out Microsoft sql server 2000 performance tuning book isbn 0-7356-1270-6
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
April 6, 2005 at 8:21 am
Well there isn't a security issue becuase the webserver only has a subset of the data from the main server replicated to it. The main server is hit by the employees who are queriring on a much larger set of data and using more intensive queries.
At some point we will upgrade from SQL 7 to 2005. It is my understanding that Indexed Views will then be availble (maybe available in SQL 2000). At that point perhaps we can again run test to see if all (employees & webusers) can just hit the main DB.
In either case we will still have a robust webserver that should last us 4 to 5 years.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply