Q

SQL Server 2005 Enterprise Edition vs. Standard Edition

SQL Server expert Adam Machanic highlights the differences to consider when weighing the move to SQL Server 2005 Enterprise and Standard Edtions.

We have a dual processor 8 GB RAM Windows Server 2003 running SQL Server 2000 Standard Edition, hosting a relatively small data warehouse of 100 GB. Performance is a bit poor and I have made a proposal to move to either SQL Server 2005 Standard or Enterprise Edition, allowing access to additional memory. Can you offer reasons to use one edition over the other?
The main reasons to choose Enterprise over the Standard Edition are for scalability and availability requirements. Features such as partitioning and online indexing help maintain a high level of database quality of service and uptime. However, as your company's management has discovered, these features do not come cheap. The Enterprise Edition is almost five times more expensive than the Standard Edition, and many firms have decided that their requirements for availability and scalability simply aren't stringent enough to make the additional cost worthwhile.

Microsoft has published a features comparison chart that shows the differences between the various editions of

SQL Server. It should help you make the correct decision for your company's needs.

By the way, it's important to note that upgrading to SQL Server 2005 from SQL Server 2000 may not have any positive impact upon your application's performance. Before upgrading, make sure to carefully analyze the system in order to determine what is causing the poor performance. It is quite possible that you'll be able to fix the issue without upgrading.

This was first published in July 2006

Dig deeper on Microsoft SQL Server 2005

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close