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 |
|
Mauricio Moreno
Starting Member
18 Posts |
 Posted - 2007-04-26 : 13:46:03
|
| Hello,I am currently hosting my ecommerce site on a dedicated server with dual AMD processors and 2 gigs of ram. I have on average 20 people on the site at one time.on this server i have sql express, from which i understand, only utilizes one of the processors and 1gig of ram. I have the choice to pay an extra 150 a month to have my host put sql workgroup on my system. My question is, will i notice any kind of real performace boost by upgrading. Or at the level that i am at, there wont be much difference?Any help would be very useful.Thanks |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-04-26 : 15:54:24
|
are you experiencing perf problems now? if so, my instinct would be to fix perf problems in the code first, before throwing hardware at it. use profiler to find where bottlenecks are, then address them.
www.elsasoft.org |
 |
|
|
Mauricio Moreno
Starting Member
18 Posts |
Posted - 2007-04-26 : 18:32:07
|
| i already have the hardware on the server, but because i am using express, i assume its not using the full capabilities of the server. If i have them install sql workgroup which supports my dual processors and the gigs of ram, will i notice an improvement in performance? |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-04-26 : 19:29:16
|
it depends. I'll ask again: are you experiencing perf problems now? if not, no need to upgrade.if your current db is small enough such that most queried pages can be cached in memory even with the limitations that express has, then you probably won't get any benefit. if it's bigger, such that express needs to hit the disk where workgroup wouldn't, then you get a benefit. but the benefit may not be worth paying for if you aren't experiencing problems now. hence my original question.EDIT: if you expect load to grow in the future, that could be another reason to upgrade now of course.
www.elsasoft.org |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-26 : 22:46:48
|
| Yes, sql2k5 express has limits on cpu and memory. Will improve performance if sql can use more cpu and memory. |
|
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2007-04-26 : 23:13:57
|
| Not necessarily. It will only improve performance if SQL Server Express is the limitation. Is your site slow now?How big is your database? For example if your database is less than 1GB then allowing SQL Server to use the extra RAM won't help that much. I'm guessing that even at 4GB you'd still get good performance out of Express.If your single process isn't used very much adding a second won't improve performance.The biggest benefit of adding RAM is reduce disk access. How many disk I/O's do you do per second? Can you reduce that by adding indexes? Indexes are cheaper than paying thousands for licenses :)===============================================Creating tomorrow's legacy systems today.One crisis at a time. |
|
|
|
|
|
|
|
|
Express vs Workgroup - Should i upgrade?