Performance and Memory issues on Sql 2000 running Windows 2003 Enterprise R2
Hi,
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
David
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
David
ASKER
Hi,
I forgot to add that we are using Sql Server 2000 Enterprise edition.
Also the database is about 52 GB in size.
I forgot to add that we are using Sql Server 2000 Enterprise edition.
Also the database is about 52 GB in size.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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)