Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
raghu229
Starting Member
2 Posts |
 Posted - 2007-08-21 : 13:32:48
|
| We are upgrading our webserver. sql is about 50% of our CPU load. What would be the better from these two options - go for 2 dual core CPUs and sql workgroup for each one working on WOW; or 1 dual core CPU and sql standard working at 64 bit? I can't afford ot go to sql standard on both CPUs. Thanks in advance. |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
raghu229
Starting Member
2 Posts |
Posted - 2007-08-21 : 15:16:13
|
| The db size is approaching 1GB. only IIS uses sql, but we get about 100,000 to 200,000 hits a month on the website. It is a databse driven website, with pages typically needing about 10-50 database searches to generate. Our current web server is an athlon 2.4GHz with sql 2000 (free version), and CPU time is maxed at 100% often resulting in service denied messgaes for customers. we use a lot of caching as a short term solution. sql and IIS use about half the cpu load each. Not sure if getting 2 cpus on a 4gb machine with sql workgroup is ebtter than 1 cpu using 64 bit sql standard and addressing the full 4gb of ram unlike workgroup. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-21 : 21:55:57
|
| You should put IIS and sql on separate servers. |
|
|
|
|
|
|
sql performance and hardware