I'm using Sql 2000 database, with DB size of 3 Gb. A particular (update) query took 30 min. in my normal desktop machine to finish. When I run the same query, with the same db, in an Intel Xeon (dual core) based server, it took 18 min to
But the same udpate took almost 55 min. in an Intel Xeon (Quad-core) based server. I don't understand why it's taking such a long time.
My doubt is SQL 2000 is not utilitising the power of multi-core processors ? Is this right ?
Will the update be faster, if I upgrade from SQL 2000 to SQL 2008 ? ie Is SQL 2008 (Including express edition) will utilise the power of multi-core processors ?
View Complete Post