Differences between SQL Server 2000 | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Differences between SQL Server 2000

Hi, What are the differences between SQL Server 2000 Standard and SQL Server 2000 Enterprise editions? What is the preferred edition for 8GB Size with text and image data Database?? Regards,
Sri
Go for ENTERPRISE EDITION in your case. Using SE you get max of 4 CPU, no dist.partitioned views/Log shipping/failover clustering and max of 2GB RAM can be used on SQL Server. Whereas, EE has capability of
-up to 32 CPU on the Windows 2000 DataCenter up to 8 CPU on the Windows 2000 Advanced Server and on the Windows NT Server 4.0 Enterprise Edition up to 4 CPU on the Windows NT Server 4.0 and on the Windows 2000 Server
-up to 64Gb RAM on the Windows 2000 DataCenter up to 8 Gb RAM on the Windows 2000 Advanced Server up to 4 Gb RAM on the Windows 2000 Server up to 3 Gb RAM on the Windows NT Server 4.0 Enterprise Edition up to 2 Gb RAM on the Windows NT Server 4.0
-Distributed Partitioned Views
-Log Shipping
-Parallel index creation
-Failover clustering …. what else you require. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com

Seehttp://microsoft.com/sql/evaluation/overview/default.asp for more details. Gaurav
Moderator
Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard

See http://microsoft.com/sql/techinfo/planning/SQLReskChooseEd.asp for info on the same topic. Gaurav
Moderator
Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard

]]>