SQL Server 7.0 to SQL Server 2000 
Author Message
 SQL Server 7.0 to SQL Server 2000

Just migrated our test server from NT 4.0 / SQL Server 7.0 to Windows
Advanced Server / SQL Server 2000.  It is on the same box which has ~320 Meg
of ram and a single 550 MHz processor.

Now my developers are testing their programs which ran quite well against
the 7.0 setup.  However, with the new setup, things are perceptibly SLOWER.
What used to take just a few seconds to process takes between a minute to
two minutes, for the same program.

Are there some suggestions as to what to try?  I'm going to verify the
configuration is the same--that the network library is adequate (TCP/IP and
Named Pipes).

I would appreciate any help you might have.  THANKS!!

Sue



Sat, 02 Oct 2004 09:00:55 GMT
 SQL Server 7.0 to SQL Server 2000

Try updating the statistics if you haven't done that since
the upgrade.

-Sue



Quote:
>Just migrated our test server from NT 4.0 / SQL Server 7.0 to Windows
>Advanced Server / SQL Server 2000.  It is on the same box which has ~320 Meg
>of ram and a single 550 MHz processor.

>Now my developers are testing their programs which ran quite well against
>the 7.0 setup.  However, with the new setup, things are perceptibly SLOWER.
>What used to take just a few seconds to process takes between a minute to
>two minutes, for the same program.

>Are there some suggestions as to what to try?  I'm going to verify the
>configuration is the same--that the network library is adequate (TCP/IP and
>Named Pipes).

>I would appreciate any help you might have.  THANKS!!

>Sue



Sat, 02 Oct 2004 09:04:27 GMT
 SQL Server 7.0 to SQL Server 2000
Hi Sue..

How was the database migrated? (Were all of the indexes migrated!)

You might want to try profiling long running queries (filtering on duration)
to identify culprit queries / stored procs.

Just my $.02 worth.

HTH

Cheers,
Greg Linwood


Quote:
> Just migrated our test server from NT 4.0 / SQL Server 7.0 to Windows
> Advanced Server / SQL Server 2000.  It is on the same box which has ~320
Meg
> of ram and a single 550 MHz processor.

> Now my developers are testing their programs which ran quite well against
> the 7.0 setup.  However, with the new setup, things are perceptibly
SLOWER.
> What used to take just a few seconds to process takes between a minute to
> two minutes, for the same program.

> Are there some suggestions as to what to try?  I'm going to verify the
> configuration is the same--that the network library is adequate (TCP/IP
and
> Named Pipes).

> I would appreciate any help you might have.  THANKS!!

> Sue



Sat, 02 Oct 2004 09:08:06 GMT
 SQL Server 7.0 to SQL Server 2000
Running the update statistics process was perfect.  Thanks so much!!


Quote:
> Just migrated our test server from NT 4.0 / SQL Server 7.0 to Windows
> Advanced Server / SQL Server 2000.  It is on the same box which has ~320
Meg
> of ram and a single 550 MHz processor.

> Now my developers are testing their programs which ran quite well against
> the 7.0 setup.  However, with the new setup, things are perceptibly
SLOWER.
> What used to take just a few seconds to process takes between a minute to
> two minutes, for the same program.

> Are there some suggestions as to what to try?  I'm going to verify the
> configuration is the same--that the network library is adequate (TCP/IP
and
> Named Pipes).

> I would appreciate any help you might have.  THANKS!!

> Sue



Mon, 04 Oct 2004 08:21:26 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. SQL Server 7.0 and SQL Server 2000

2. SQL SERVER 7.0 TO SQL SERVER 2000

3. difference between SQL Server 7.0 and SQL Server 2000 full-text search

4. link SQL SERVER 7.0 and SQL SERVER 2000?

5. SQL Server 7.0 vs SQL Server 2000: invalid column width

6. sql server 7.0 and sql server 2000

7. torn page detection and upgrade from SQL server 7.0 to Sql server 2000

8. Install SQL Server 7.0 when SQL Server 2000 is installed

9. Migration from SQL Server 7.0 to SQL Server 2000

10. Migration Data from SQL SERVER 7.0 to SQL SERVER 2000

11. Performance problem: SQL Server 7.0 vs SQL Server 2000

12. Upgrading from SQL Server 7.0 to SQL Server 2000


 
Powered by phpBB® Forum Software