April 13, 2009 at 10:15 pm
Hi,
We have a POS application that runs on multiple branch servers with a central HO server. The branch servers and HO Server use merge replication to sychronise. The HO Server then talks to the Financials Server using a program. We currently have SQL 2000 STD Edition on all of these servers and are facing severe performance issues.
As a result, we have decided to move to SQL 2005 since this allows for more RAM to be used. However we have to decide on whether to move to SQL 2005 Standard or Enterprise.
I have seen the microsoft site comparing the two versions. However, I am not a fully technical person and any advice or explanations about the different features would be very welcome and helpful
Sudarshan.
April 14, 2009 at 12:23 pm
You need to identify what is causing your current performance problems, in order to determine the hardware required to remove any bottlenecks in your system. Once you have that information you can determine whether Standard Edition meets your needs. If so then the only reason to buy Enterprise edition is if the additional functionality is worth the higher cost.
Ultimately if the performance problems are due to poor code then they will still exist in 2005 - some may be mitigated to a degree, while some problems may grow worse. You should also understand how the changes in 2005 pertain to your application, for example if you use triggers excessively then you will see more tempdb usage.
April 14, 2009 at 2:35 pm
More RAM is often welcome by SQL but in SQL 2005 there is no difference between the RAM supported by standard edition and enterprise edition. Both are limited only by the operating system. See http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx?PHPSESSID=0324345d45ef1bf1f764044e03584cd0 The number of CPUs supported by standard edition is limited to 4 where enterprise is not limited.
Francis
April 15, 2009 at 7:14 am
the 2 biggest differences between std and ent are online index rebuilding and partitioning. Also AFAIK page level restores are only available in sql2005 ent
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 15, 2009 at 7:41 am
Hi,
Check these links might be helpful for you
http://www.microsoft.com/Sqlserver/2005/en/us/compare-features.aspx
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply