|
| PORTAIL | ANNUAIRE | ARTICLES | COMPARATEUR HÉBERGEURS | DEVIS | FORUMS | RÉDUCTEUR D'URL |
|
|
|
|
||||||
| ms.sqlserver.setup Questions about SQL Server. |
 |
|
|
LinkBack | Outils de la discussion |
26/09/2006, 17h03
|
#1 (permalink) |
Messages: n/a
Hébergeur: |
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 |
|
|
26/09/2006, 17h13
|
#2 (permalink) |
|
Messages: n/a
Hébergeur: |
Re: Queries run slower on Server 2003 than Server 2000
Have you rebuilt the indexes since moving the databases to the new server?
(That is necessary...) -- Arnie Rowland, Ph.D. Westwood Consulting, Inc Most good judgment comes from experience. Most experience comes from bad judgment. - Anonymous "RobertTheBruce" <robert_bruce@hargreaveslansdown.co.uk> wrote in message news:1159286610.381690.65140@i3g2000cwc.googlegrou ps.com... > 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 > |
|
|
|
| Outils de la discussion | |
|
|
