<div>
Yes if you have &nbsp;at least win2k3 ent edition, std only support 4gb<br />
refer to <a href="http://www.microsoft.com/whdc/system/platform/server/PAE/PAEdrv.mspx" rel="ugc nofollow">http://www.microsoft.com/whdc/system/platform/server/PAE/PAEdrv.mspx</a><br />
<br />
Also, do I need to configure something on my SQL Server? <br />
If you want to allocate specific cpu or assign fix amount of ram, yes you can as needed
</div>


Yes if you have  at least win2k3 ent edition, std only support 4gb
refer to http://www.microsoft.com/whdc/system/platform/server/PAE/PAEdrv.mspx [http://www.microsoft.com/whdc/system/platform/server/PAE/PAEdrv.mspx]

Also, do I need to configure something on my SQL Server?
If you want to allocate specific cpu or assign fix amount of ram, yes you can as needed

<div>
Make some research on the web, do I need to turn on AWE in SQL Server? &nbsp;Also, do I need to add /3GB / PAE in boot.ini?<br />
<br />

</div>


Make some research on the web, do I need to turn on AWE in SQL Server?  Also, do I need to add /3GB / PAE in boot.ini?



<div>
yes you need to enable AWE<br />
you can find more information here<br />
<a href="http://technet.microsoft.com/en-us/library/ms175581.aspx" rel="ugc">http://technet.microsoft.com/en-us/library/ms175581.aspx</a><br />
<a href="http://technet.microsoft.com/en-us/library/ms190673.aspx" rel="ugc">http://technet.microsoft.com/en-us/library/ms190673.aspx</a><br />

</div>


yes you need to enable AWE
you can find more information here
http://technet.microsoft.com/en-us/library/ms175581.aspx [http://technet.microsoft.com/en-us/library/ms175581.aspx]
http://technet.microsoft.com/en-us/library/ms190673.aspx [http://technet.microsoft.com/en-us/library/ms190673.aspx]


<div>
<div class="content wysiwyg-content">
Dear all experts,<br />
<br />
One of my server have the following configuration:<br />
<br />
1 X Quard Cores CPU<br />
10GB Memory<br />
300 GB Hard drive<br />
<br />
Windows 2003 Enterprise Edition (32 Bit) /w SP2<br />
SQL Server 2000 Enterprise Edition (32 Bit)<br />
<br />
To get use all 10GB memory, do I need to modify boot.ini in my Windows? &nbsp;Also, do I need to configure something on my SQL Server? &nbsp;Please kindly advise
</div>
</div>


Dear all experts,

One of my server have the following configuration:

1 X Quard Cores CPU
10GB Memory
300 GB Hard drive

Windows 2003 Enterprise Edition (32 Bit) /w SP2
SQL Server 2000 Enterprise Edition (32 Bit)

To get use all 10GB memory, do I need to modify boot.ini in my Windows?  Also, do I need to configure something on my SQL Server?  Please kindly advise

How to configure the Windows 2003 Server it has 10GB memory

VMware, a software company founded in 1998,  was one of the first commercially successful companies to offer x86 virtualization. The storage company EMC purchased VMware in 1994. Dell Technologies acquired EMC in 2016. VMware’s parent company is now Dell Technologies.

VMware has many software products that run on desktops, Microsoft Windows, Linux, and macOS, which allows the virtualizing of the x86 architecture.  Its enterprise software hypervisor for servers, VMware vSphere Hypervisor (ESXi), is a bare-metal hypervisor that runs directly on the server hardware and does not require an additional underlying operating system.

VMware

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Windows Server 2003 was based on Windows XP and was released in four editions: Web, Standard, Enterprise and Datacenter. It also had derivative versions for clusters, storage and Microsoft’s Small Business Server. Important upgrades included integrating Internet Information Services (IIS), improvements to Active Directory (AD) and Group Policy (GP), and the migration to Automated System Recovery (ASR).