Monday, March 26, 2012

New system is slower than the old? Urgent help req'd please =(

My customer just purchased a system to replace their old system that handles
SQL. The new system apparently is abt 3-4 seconds slower in executing queri
es.
Their new system consists of:
P4-2.80GHz with HT
4GB PC3200 ram in dual channel mode
Intel D875PBZL motherboard
Adaptec 8 channel SATA RAID controller in PCI slot 2 or 3
2 x Seagate 80GB SATA mirrored for Win2K Server and SQL 2000 developer editi
on
6 x Seagate 80GB SATA RAID10 with 4 x approx 55GB partitions
PCI video card
The Old system consisted of:
Intel P4 2.0ghz
2gb ddr ram
on board promise hardware raid running the OS drive in mirror on 2x7200rpm i
de
drives
pci promise hardware raid running DATA drive in 3 drive stripe on 3x7200rpm
ide drives
win 2k server sp4 + patches
ms sql 2k developer edition
What could be causing it to be slower?Henry,
It all depends on if the queries that are being executed are the same on the
new system as the old system, other questions that need to be asked are
1. Have they changed the quantity of data being queried
2. Have they changed the index's on the table being queried
3. Are they maintaining the databases correctly - please don't say that the
database was migrated to the new server but none of the house keeping/mainte
nance scripts.
If you still have access to the old Server try running the same queries agai
nst the database whilst running a trace on proifiler this hsould show you if
the queries are genuinly being run more slowly. If they are not then this m
ay be a network issue conce
rning the new server.
Ed|||Could it be possible that the way the RAID is setup it's slower? i mean the
config of the HDs?
Does there seem to possibly be any hardware issue causing the performance de
crease?
What about Win2K server running on an HT enabled processor? Will Win2003 Ser
ver Standard address or utilise the HT better?|||anyone?

No comments:

Post a Comment