MS SQL Std on Win 2k Pro

Hello.
Is it possible to run MS SQL 2000 Server Standart Edition on Windows 2000
Pro, not Windows 2000 Server ?
bn
> Is it possible to run MS SQL 2000 Server Standart Edition on Windows 2000
> Pro, not Windows 2000 Server ?
No - check possible combinations at
http://www.microsoft.com/sql/evaluat...0/default.asp.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
|||As stated in the link Dejan provided, you need a server OS to run Standard
Edition. However, the Developer Edition provides the same features as the
Enterprise Edition with licensing restrictions and can run on a client OS
like XP Pro.
Hope this helps.
Dan Guzman
SQL Server MVP
"bala nemate" <headq[@.]bamba.lt> wrote in message
news:%23shu6EKlEHA.2140@.TK2MSFTNGP15.phx.gbl...
> Hello.
> Is it possible to run MS SQL 2000 Server Standart Edition on Windows 2000
> Pro, not Windows 2000 Server ?
> bn
>
sql

MS SQL Std on Win 2k Pro

Hello.
Is it possible to run MS SQL 2000 Server Standart Edition on Windows 2000
Pro, not Windows 2000 Server ?
bn> Is it possible to run MS SQL 2000 Server Standart Edition on Windows 2000
> Pro, not Windows 2000 Server ?
No - check possible combinations at
http://www.microsoft.com/sql/evaluation/sysreqs/2000/default.asp.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com|||As stated in the link Dejan provided, you need a server OS to run Standard
Edition. However, the Developer Edition provides the same features as the
Enterprise Edition with licensing restrictions and can run on a client OS
like XP Pro.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"bala nemate" <headq[@.]bamba.lt> wrote in message
news:%23shu6EKlEHA.2140@.TK2MSFTNGP15.phx.gbl...
> Hello.
> Is it possible to run MS SQL 2000 Server Standart Edition on Windows 2000
> Pro, not Windows 2000 Server ?
> bn
>

MS SQL Server Memory Supported

We are using SQL 2000 and being moved from old NT Servers having 2 G of RAM to new hardware with Win 2003 installed and 8GB of RAM.
Now can SQL 2000 use more than 2G of RAM on Win2003, if yes do we need to do any settings
Pls advise
Thanks
sanjay
Hello,
Only SQL server 2000 Enterprise Edition support more than 2 GB RAM. Other
editions will support only a
maximum of 2 GB.
If it is Enterprise edition then have a look into the below site to enable
more than 2 GB RAM to SQL server using AWE:-
http://www.sql-server-performance.com/awe_memory.asp
Thanks
Hari
MCDBA
"Sanjay" <Sanjay@.discussions.microsoft.com> wrote in message
news:DFD9B463-7A8F-48BA-BB9B-AB52BB35310F@.microsoft.com...
> We are using SQL 2000 and being moved from old NT Servers having 2 G of
RAM to new hardware with Win 2003 installed and 8GB of RAM.
> Now can SQL 2000 use more than 2G of RAM on Win2003, if yes do we need to
do any settings
> Pls advise
> Thanks
> sanjay

MS SQL Server Memory Supported

We are using SQL 2000 and being moved from old NT Servers having 2 G of RAM to new hardware with Win 2003 installed and 8GB of RAM.
Now can SQL 2000 use more than 2G of RAM on Win2003, if yes do we need to do any settings
Pls advise
Thanks
sanjayHello,
Only SQL server 2000 Enterprise Edition support more than 2 GB RAM. Other
editions will support only a
maximum of 2 GB.
If it is Enterprise edition then have a look into the below site to enable
more than 2 GB RAM to SQL server using AWE:-
http://www.sql-server-performance.com/awe_memory.asp
Thanks
Hari
MCDBA
"Sanjay" <Sanjay@.discussions.microsoft.com> wrote in message
news:DFD9B463-7A8F-48BA-BB9B-AB52BB35310F@.microsoft.com...
> We are using SQL 2000 and being moved from old NT Servers having 2 G of
RAM to new hardware with Win 2003 installed and 8GB of RAM.
> Now can SQL 2000 use more than 2G of RAM on Win2003, if yes do we need to
do any settings
> Pls advise
> Thanks
> sanjaysql

MS SQL Server Memory Supported

We are using SQL 2000 and being moved from old NT Servers having 2 G of RAM
to new hardware with Win 2003 installed and 8GB of RAM.
Now can SQL 2000 use more than 2G of RAM on Win2003, if yes do we need to do
any settings
Pls advise
Thanks
sanjayHello,
Only SQL server 2000 Enterprise Edition support more than 2 GB RAM. Other
editions will support only a
maximum of 2 GB.
If it is Enterprise edition then have a look into the below site to enable
more than 2 GB RAM to SQL server using AWE:-
http://www.sql-server-performance.com/awe_memory.asp
Thanks
Hari
MCDBA
"Sanjay" <Sanjay@.discussions.microsoft.com> wrote in message
news:DFD9B463-7A8F-48BA-BB9B-AB52BB35310F@.microsoft.com...
> We are using SQL 2000 and being moved from old NT Servers having 2 G of
RAM to new hardware with Win 2003 installed and 8GB of RAM.
> Now can SQL 2000 use more than 2G of RAM on Win2003, if yes do we need to
do any settings
> Pls advise
> Thanks
> sanjay

MS SQL 2005: Performance – normal CPU vs CPU DUO/4 CORE

Hello,Is performance of web application (ASP.NET + SQL Server 2005 Wrg edition + Win Server 2003 Web edition) running on server with one core duo/4 CPU generally comparable to the performance of the same application running on the same server with 2/4 physical CPU's?Thank you for your ideas!Jan

Hi Jan,

Of cource on a multiple core CPU, the ASP.NET and SQL Server performance will be better than a single core CPU.

Because the IIS and SQL Server will optimize the performance according to the core units. In this case, better performance is gain.