Re: Developer edition performance

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

From: Wayne Snyder (wayne.nospam.snyder_at_mariner-usa.com)
Date: 07/02/04 

Date: Fri, 2 Jul 2004 07:46:00 -0400

It is the developer edition and personal edition which have some
limitations, not the standard edition... The limitation is not the number of
concurrent users, but limited in the number of worker threads. This prevents
you from using the dev or personal edition as a ig production server,
because performance will not be acceptable... 

-- 
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com> wrote in
message news:eRaAFYBYEHA.2364@TK2MSFTNGP12.phx.gbl...
> > Is the developer edition of SQL Server 2000 *exactly* the same as the
> > enterprise edition - just without the production license?
>
> Yes.
>
>
> > Standard edition is
> > limited to a low number of concurrent users & worker processes
>
> Who told you that? SE is not limited in concurrent users etc, it lacks a
few features that EE has,
> like failover clustering, using lots of memory, some parallelization etc.
> -- 
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
>
> "Stu Lock" <s.lock@cergis.com> wrote in message
news:evIfU7AYEHA.3536@TK2MSFTNGP11.phx.gbl...
> > Hi,
> >
> > Is the developer edition of SQL Server 2000 *exactly* the same as the
> > enterprise edition - just without the production license?
> >
> > It is mainly the performance aspect I am interested in. Standard edition
is
> > limited to a low number of concurrent users & worker processes - is this
> > true with the deve edition.
> >
> > Thanks in advance,
> >
> > Stu
> >
> >
>
>

Relevant Pages

  • Re: Front End options
    ... SQL Server if you follow my recommendations in. ... you could easily support hundreds of concurrent users. ... Does a mdb FE work well regardless of how many tables ... >>subforms well. ...
    (microsoft.public.sqlserver.clients)
  • Re: Could Publisher Server Pull Subscriber Server
    ... I want to save the huge fee fore having a license for the STANDARD version. ... I would like to have a replica of that database in a remote site. ... Why do you need a pull on the SQL Server standard machine? ...
    (microsoft.public.sqlserver.replication)
  • Re: 2 NULLs violate Uniqueness?
    ... This is a detail where SQL Server does not follow the SQL standard. ... Create a view of the nonnull items and put a unique index on it: ... Use a computed column that equals the primary key when F is null, ...
    (microsoft.public.sqlserver.programming)
  • Re: Standard to Enterprise
    ... You'll need to uninstall your Enterprise Edition and install a Standard ... instances of SQL Server services are both Standard Editions or Enterprise ... The Notification Services instance encountered an error in one of its ...
    (microsoft.public.sqlserver.setup)
  • Re: Windows 2003 SP1 standard + SQL 2005 standard
    ... WRT the memory that great finally a definitive answer .. ... you will want SQL Server to startup with the /3GB switch. ... dual core CPUs), the standard license allows scaling up to 4 'actual' ...
    (microsoft.public.sqlserver.setup)