Server performance degraded after system upgrade

[Tawfiq Choudhury]

We were running a 4 processor server with 8 GB RAM and 800GB hard disk space on Windows 2000 server and SQL Server 2000.
Recently we have upgraded the server to 8 processor and added another
800GB. The OS was upgradded to Windows 2003 enterprise edition.
All the processor are 2.5GHz Xeon preocessors.
The OS is installed in a built in array(5i controller) of the server
and the SQL server is installed in a external array(6400 controller).

Before the upgrade the OS(Windows200) and the SQLServer was both in the
external array. OS was in one logical drive (C:) and Sqlserver in
another logical drive (D:). The built in array was not used.

For upgrading the system we have added 2X36.4 GB harddisk in the built
in array and clean installed the OS(Windows 2003). Now there is one 1.6TB (14X146 GB) external array,RAID 5.
The external array is the logical drive D: and the OS(RAID1) is the logical drive C:.

After installing the OS the D: drive was formatted and the data restored from backup.

After upgradation the performance of the server has gone down significantly from what
it was giving before the upgrade.

It seems that multiprocessing is not ocurring.

The model of the server is HP DL740

I will really apprecaite if anyone can give any clue on how to improve the performance.


Thanks in advance.


Taw.

[Ken Wong_7]

If you are using 5i for OS, I think you need to check the virtual swap file setting and if it is under the 5i. The swapping may be not as fast as 6400, it is not u320 as well as you may not get the optional BBWC(cache).

Not sure if it is the main reason and pls correct me if anything wrong. Ken

[Duncan Edmonstone]

Although yo said you upgraded the server OS to enterprise edition, what about the database software? You don't indicate what edition of SQL Server you are using - Standard Edition will not use more than 4 CPUs - You must use Enterprise edition...

HTH

Duncan