Afficher un message
Vieux 26/09/2006, 17h03   #1
RobertTheBruce
Aucun Avatar
 
Messages: n/a
Hébergeur:
Par défaut 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

  Réponse avec citation
 
Page generated in 0,05349 seconds with 9 queries