Queries run slower on Server 2003 than Server 2000
We've just purchased a new SQL server, with Windows 2003 Enterprise and
SQL 2000 Enterprise (SP3) installed on it. It's has 4 dual 3.2 Intel
processors, 4GB of Ram, for one of our databases.
The problem is, SQL is performing MUCH (50%) slower than on the older
server. The old server has Windows 2000 Enterprise and SQL 2000
Enterprise (SP3). It has significantly less memory, diskspace,
processor's.
>From information I've read upgrading to MS Server 2003 from 2000 should
result in atleast a 20-30% increase in performance.
Can you ?
Rob
|