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 queries.
Their new system consists of
P4-2.80GHz with H
4GB PC3200 ram in dual channel mod
Intel D875PBZL motherboar
Adaptec 8 channel SATA RAID controller in PCI slot 2 or
2 x Seagate 80GB SATA mirrored for Win2K Server and SQL 2000 developer editio
6 x Seagate 80GB SATA RAID10 with 4 x approx 55GB partition
PCI video car
The Old system consisted of
Intel P4 2.0gh
2gb ddr ra
on board promise hardware raid running the OS drive in mirror on 2x7200rpm ide
drive
pci promise hardware raid running DATA drive in 3 drive stripe on 3x7200rpm
ide drive
win 2k server sp4 + patche
ms sql 2k developer editio
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 ar
1. Have they changed the quantity of data being querie
2. Have they changed the index's on the table being querie
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/maintenance scripts
If you still have access to the old Server try running the same queries against 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 may be a network issue concerning 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 decrease
What about Win2K server running on an HT enabled processor? Will Win2003 Server Standard address or utilise the HT better?|||anyone?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment