Monday, March 12, 2012

MS SQL Developer Edition vs MS SQL Production Edition

Hi,
I am not very knowledgable of the MS SQL Server 2000 product range, but
according to a developing team we are in contact with, they have an
application experiencing long query times when several users are performing
queries against their MS SQL Server, which is a Developer Edition version of
MS SQL. As we're soon going to go live with the application, I would like to
know the differences between Developer Edition and any of the Production
Editions, ex. MS SQL Server Standard or Enterprise Edition. It is likely to
believe that a Production Edition have better performance, scalability and
stability compared to the Developer Edition, but this is just my thoughts.
Can someone please let me know the major differencies between Production
Editions and Developer Edition. Do you think that we will notice any
performance improvements moving to MS SQL Server Std./Ent. Edition?
Thanks in advance
// Bj?rnWith the new SQL 2005 product, it's hard to find informations about SQL 2000
on Microsoft website.
Take a look:
http://www.mssqlcity.com/FAQ/Genera...00_editions.htm
And for the new SQL 2005, take a look here:
http://www.microsoft.com/sql/editions/default.mspx
Carlos A.
"Bj?rn Pettersson" wrote:

> Hi,
> I am not very knowledgable of the MS SQL Server 2000 product range, but
> according to a developing team we are in contact with, they have an
> application experiencing long query times when several users are performin
g
> queries against their MS SQL Server, which is a Developer Edition version
of
> MS SQL. As we're soon going to go live with the application, I would like
to
> know the differences between Developer Edition and any of the Production
> Editions, ex. MS SQL Server Standard or Enterprise Edition. It is likely t
o
> believe that a Production Edition have better performance, scalability and
> stability compared to the Developer Edition, but this is just my thoughts.
> Can someone please let me know the major differencies between Production
> Editions and Developer Edition. Do you think that we will notice any
> performance improvements moving to MS SQL Server Std./Ent. Edition?
> Thanks in advance
> // Bj?rn|||"Bjrn Pettersson" <BjrnPettersson@.discussions.microsoft.com> wrote in
message news:21181F56-24A3-4E0A-8C9E-CEE43E91C5AA@.microsoft.com...
> Hi,
> I am not very knowledgable of the MS SQL Server 2000 product range, but
> according to a developing team we are in contact with, they have an
> application experiencing long query times when several users are
> performing
> queries against their MS SQL Server, which is a Developer Edition version
> of
> MS SQL. As we're soon going to go live with the application, I would like
> to
> know the differences between Developer Edition and any of the Production
> Editions, ex. MS SQL Server Standard or Enterprise Edition. It is likely
> to
> believe that a Production Edition have better performance, scalability and
> stability compared to the Developer Edition, but this is just my thoughts.
> Can someone please let me know the major differencies between Production
> Editions and Developer Edition. Do you think that we will notice any
> performance improvements moving to MS SQL Server Std./Ent. Edition?
>
No. Developer edition is exactly the same as Enterprise Edition, exept for
the license. If an app performs poorly on Developer Edition it will not
perform any better on Enterprise.
David

No comments:

Post a Comment