Home > Ask the SQL Server Experts > Archive: SQL Server 2005 Questions & Answers > SQL Server 2005 Enterprise Edition vs. Standard Edition
Ask The SQL Server Expert: Questions & Answers
EMAIL THIS

SQL Server 2005 Enterprise Edition vs. Standard Edition

Adam Machanic EXPERT RESPONSE FROM: Adam Machanic

Pose a Question
Other SQL Server Categories
Meet all SQL Server Experts
Become an Expert for this site


Expert advice on database administration
Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google


>
QUESTION POSED ON: 06 July 2006
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?


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google



RELATED CONTENT
Microsoft SQL Server 2005
End of life comes for SQL Server 2005 SP2, 2008
SQL Server Reporting Services Fast Guide
SQL Server Service Broker Tutorial and Reference Guide
Tips for tuning SQL Server 2005 to improve reporting performance
SQL Server consolidation: Why it's an optimization technique
Parent-child dimensions in SQL Server 2005 with Analysis Services MDX
Enforcing data integrity in a SQL Server database
SSIS error message due to installation problem on SQL Server 2005
Should you upgrade to SQL Server 2005 or SQL Server 2008?
Basics for working with DATETIME and SMALLDATETIME in SQL Server 2005
Microsoft SQL Server 2005 Research

Archive: SQL Server 2005
Stored procedure concurrency problems in SQL Server 2005
SQL vs. T-SQL
Database Snapshots: Creating read-only copies of a database
Upgrading SQL Servers
Determining number of servers needed for large member site
Encryption failures when upgrading to SQL Server 2005
Upgrading to SQL Server 2005 while maintaining .adp access
Modifying a query to show navigation path
Viewing SQL Server 2005 data via Windows Forms
SQL Server 2005 upgrade issues

RELATED GLOSSARY TERMS
Terms from Whatis.com − the technology online dictionary
application server  (SearchSQLServer.com)
Yukon  (SearchSQLServer.com)

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary


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.




Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.
Browse our Expert Advice



SQL Solutions - SQL Database Design
HomeNewsTopicsITKnowledge ExchangeTipsAsk the ExpertsMultimediaWhite PapersIT Downloads
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 2005 - 2009, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts