[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Performance and Memory issues on Sql 2000 running Windows 2003 Enterprise R2

Posted on 2009-02-17
Medium Priority
Last Modified: 2012-05-06

We upgraded to new hardware this weekend and a new OS on our Sql server Database system.  We moved from Windows 2000 running Sql Server 2000 databases and moved to WIndows 2003 Enterprise 2003 R2 running Sql Server 2000 and named the machine the same name and same IP address and ported the databases over to the new system.   We believe we could be having memory leaks or issues but not certain.

We are currently running on a IBM 3850 with a DS3300 for storage and our 3850 is configured as follows.

Windows 2003 Server Enterprise R2 at Sp2
Sql server 2000 at SP4
Boot ini switch we have 3GB and PAE enabled.
13.7 GB max memory for sql
16 GB Ram on server
paging = 48GB  
We also are running Trendmicro Officescan version 8 with exclusions.

Does anyone know of anything that we might be missing or have overlooked in this configuration or something else we might check.  

We have about 500 processes at any one time running on the system.

Thanks for your help

Question by:dtmhelp
  • 2
LVL 81

Expert Comment

ID: 23661725
You do not need the /3GB switch since you are not using AWE.
Since you do not have Enterprise version of SQL, you can not use AWE.
Check the advanced settings under properties of my computer, performance settings\advanced should be processor and memory priority for application rather than background services.
You can also get the Server Performance adviser and run tests to see where your performance hit is.

How big is your database?
You can use perfmon to look at memory and processor performance to see whether the hit is coming from swapping memory (paging)

Author Comment

ID: 23662023

I forgot to add that we are using Sql Server 2000 Enterprise edition.

Also the database is about 52 GB in size.

LVL 81

Accepted Solution

arnold earned 2000 total points
ID: 23663849

Setup SQL to run with AWE. Note you should first double check that all the updates to your sql 2000 EE are applied including the hotfix dealing with AWE from the links below. Make sure the user used to run sql has lock pages in memory rights.
Remove the /3GB from the boot.ini
Hotfix SQL 2000 SP4 might be outdated:

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Know the reasons and solutions to move/import EDB to New Exchange Server. Also, find out how to recover an Exchange .edb file and to restore the file back.
By default Outlook 2016 displays only one time zone in the Calendar. The following article explains how to display two time zones in one calendar view.
This Micro Tutorial will give you a basic overview of Windows DVD Burner through its features and interface. This will be demonstrated using Windows 7 operating system.
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…
Suggested Courses

873 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question