Kbase P167552: Performance is slow after migrating to a new server (IBM blade) due to excessive I/O.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
13/07/2010 |
|
Status: Unverified
SYMPTOM(s):
Performance is slow after migrating to a new server (IBM blade) due to excessive I/O.
The database server was direct connected to the SAN where the database files were located.
The new server is connected to the same SAN, but now through fibre channels.
According to perfmon statistics, the disk read queues have increased from an average of 3-5 to sometimes 50.
Disk diagnostics run by the hardware vendor is showing that one of the disks is not functioning properly (I/O rates are below expected levels for that particular disk model) even though no errors are reported.
FACT(s) (Environment):
Database runs with poor performance - queries that normally took seconds to run are taking minutes.
Database runs with fine performance on a Windows black box system.
The database server's network interface cards (NIC's) are multi homed.
There are two NIC's per server.
The SAN array has 2 fibre channels.
Ethernet traffic has been confined to one switch and fibre channel traffic has been confined to the other switch.
New disks have been added to the SAN.
Windows Server 2003
OpenEdge 10.1B03 Service Pack
Database data extents reside on RAID 0 partitions.
Database AI and BI extents reside on RAID 10 partitions.
CHANGE:
Database was migrated from a black box Windows system to an IBM blade.
CAUSE:
Bad disk in the SAN array.
FIX:
Replace the bad disk.