Re: Benchmark for different edition SQL 2000

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Wanchun (anonymous_at_discussions.microsoft.com)
Date: 05/19/04 

Date: Tue, 18 May 2004 18:26:03 -0700

Hari,

Thanks for your advice. However, I have read the page before and without any idea. The point of availability is confused me. In fact, the standard edition and enterprise edition is no different except?

--Scalability ( useless to us because we only have 1 CPU machine with 512MRAM)
--Availability/uptime (useless to us because we don't have a standby or cluster machine)
--Performance (Time is not so critical because we are just using the 6.5 version now with no complain)
--Advanced analysis ( Analysis is not so critical because we are just using the 6.5 version now with no complain)

I just concern, is it enterprise edition is more stable? or standard edition is easy to down?

Wanchun

     
     ----- Hari Prasad wrote: -----
     
     Hi,
     
     Based on your configurations and settings I will recommend you to go for SQL
     Server standard edition.
     
     Have a look into the below link in choosing the edition of sql server:-
     
     http://www.microsoft.com/sql/techinfo/planning/SQLReskChooseEd.asp
     
     Thanks
     Hari
     MCDBA
     
     
     
     "Wanchun" <anonymous@discussions.microsoft.com> wrote in message
     news:08540023-9C99-4569-9A26-F765151912A2@microsoft.com...
> We want to select the edition between standard and enterprise. Our usage:
> 1) 10 users/application connect to the server at the same time
> 2) 5000 row insert per day
> 3) Our machine is only 1CPU 2.6GHz and 512 MB RAM with window 2000 server
> 4) One database will be installed
> 5) The size of the database around 10GB
>> Because we want to replace the existing SQL6.5 with 400MHz 256MRAM
     database server.
> Please advise. Thanks
     
     
     

Relevant Pages

  • Re: trial software
    ... > license for the Standard Edition and reinstall the OS to deploy. ... > can't be installed on top of the Enterprise Edition. ... > That's why I wanted the Standard Edition trial software. ... to install/setup - option one - make you app better. ...
    (microsoft.public.windows.server.general)
  • Re: Standard to Enterprise
    ... My guess is that you have two active SQL Server instances (and notification services) and one of them is Standard Edition and the other one is Enterprise Edition. ...
    (microsoft.public.sqlserver.setup)
  • Re: Standard to Enterprise
    ... You'll need to uninstall your Enterprise Edition and install a Standard Edition from scratch. ... instances of SQL Server services are both Standard Editions or Enterprise ... > different edition of Notification Services. ...
    (microsoft.public.sqlserver.setup)
  • Re: Reviving Older Products
    ... I'd like to have D1-D3 in the Standard Edition, ... and D5 in the Enterprise Edition. ... These ideas won't bring in a huge amount of money, ... the compiler, and make that available like Microsoft has made their ...
    (borland.public.delphi.non-technical)
  • Re: AS / PTS
    ... I don't remember SQL2k Standard edition allows HTTP access. ... cubes through HTTP. ... Enterprise edition you'll not encounter these problems. ... Let me know again if you got it working in Standard edition. ...
    (microsoft.public.sqlserver.olap)