Welcome to Aussie SQL Server Bloggers Sign in | Join | Help

Wednesday, 1 February 2006 - Posts

Parallelism on OLTP often kills performance (so turn it off)...

One of my customers is currently converting to SQL Server 2005 Ent Edn 64bit & was disappointed today to observe a query which had been running well on SQL 2000 perform extremely badly on SQL 2005 in the test lab. So I asked for the 2000 / 2005 execution