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 4 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply