SQL Server Performance Forum – Threads Archive
Difference in SQL Server editions
Hi, just wanted to know the important technical difference between SQL 2K Standard edition and the Enterprise editions besides the log shipping difference. Thanks.You’re best bet is to search on the homepage of SQL Serverhttp://www.microsoft.com/sql
There are many documents about this. Too much to post here. ———————–
–Frank
http://www.insidesql.de
———————–
1. Open Books Online.
2. Go to Index tab.
3. Type editions of SQL Server.
4. Hit Enter.
5. Choose a topic and you’ll find plenty of information. — Marek Grzenkowicz
… before that get a coffee.. [8D] Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
quick note on one difference (i believe) is the capabilities of Reporting Services which i am playing with now. going to class on this next week, so hopefully be more updated. the
Bugster
ps; i already have coffee in hand
Enterprise Edition has all SQL funcionabilty.
Standard Edition does not support:
– Failover Clustering
– Paralell create index.
– Paralell DBCC.
– Log Shipping.
– Enhanced read-ahead and scan.
– Indexed views.
– Federal Database Server.
– System Area Network (SAN).
– User defined OLAP partitions.
– Linked OLAP cubes.
– Real Time OLAP.
– Partition Wizard.
– Relational OLAP (ROLAP) dimension support.
– HTTP Internet support.
– Write Back to dimensions.
– Very large dimension support.
– Distributed partitioned cubes. End of coffe.
Luis Martin
Moderator
SQL-Server-Performance.com All postings are provided “AS IS†with no warranties for accuracy.
There are also differences in hardware configurations that each edition can use are also important:
- Standard Edition cannot utilize more than 2 GB of RAM and 4 CPUs
- Enterprise Edition can be scaled up to 64 GB of RAM and 32 CPUs
]]>