10-11-06, 14:10 #1Registered User
- Join Date
- Oct 2006
Unanswered: Query completes on one box but not another
I've got an issue where a join takes about 3 minutes to run on a development server (2 X 1.4 GHz/ 2GB / Win2K3SP1 / SQL2KSP4 (8.00.2187) standard) and does not finish (even after 10 Hours!) on a monster (8 X ? GHz/ 12GB / Win2K3SP1 / SQL2KSP4 (8.00.2187) clustered Enterprise) data center test machine.
This is a join between a table with 360K rows and another with 5.6 Mil rows. Identical data, schema, indexes, auto-stats, etc. between the two boxes. I see no CXPackets, so the parallel processing issue doesn't seem to apply.
Any ideas what to look for?
10-20-06, 19:46 #2Registered User
- Join Date
- Sep 2004
I'm not a SQLserver user, so this is just a guess from my DB2 background.
Apparently the optimizer chose different access paths in both cases, despite of identical indexes and statistics. Maybe the optimizer got (badly) influenced by the higher performance of the second box?
I guess you can ask the systems for their respective access paths?--_Peter Vanroose,
__IBM Certified Database Administrator, DB2 9 for z/OS
__IBM Certified Application Developer
__ABIS Training and Consulting