Ever wonder what the difference is between SQL Server 2008 Enterprise Edition and SQL Server 2008 Standard edition. Well Microsoft has published a document that provides such a comparison. At the end of this blog is a link so you can get the entire document. Here are a few highlights from the document:
SQL Server 2008 Enterprise
SQL Server 2008 Enterprise is a comprehensive data platform for running mission critical online transaction processing (OLTP), data warehousing (DW) and business intelligence (BI) applications. SQL Server 2008 Enterprise provides enterprise class scalability, high availability and security to meet the high demands of these applications.
Enterprise is ideally suited for the following usage scenarios:
– Mission critical deployments requiring high availability and uptime
– Existing large scale OLTP deployments
– OLTP deployments that expect to grow rapidly in the future
– Large scale reporting and analysis deployments
– Data Warehousing
– Server Consolidation
SQL Server 2008 Standard
SQL Server 2008 Standard is a full featured data platform for running departmental online transaction processing (OLTP) and business intelligence (BI) applications. SQL Server 2008 Standard provides best-in-class ease of use and manageability for running departmental applications.
Standard is ideally suited for the following usage scenarios:
– Departmental deployments
– Small to medium scale OLTP deployments
– OLTP deployments that are not expected to rapidly grow in the future
– Reporting and analysis deployments
The table below provides a high level comparison of the key capabilities between SQL Server 2008 Enterprise and Standard:
To obtain the entire report, with lots of really useful information…..
Posted Michael Corey,
Founder & CEO, Ntirety