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