Friday, February 24, 2012

Developer edition performance

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
> 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
>
|||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...
> Yes.
>
> 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...[vbcol=seagreen]
is
>

No comments:

Post a Comment