MS SQL Server, SQL Server 7.0 to SQL Server 2000

SQL Server 7.0 to SQL Server 2000

Author	Message
sued #1 / 4	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

Sue Hoegemeie #2 / 4	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

Greg Linwoo #3 / 4	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

sued #4 / 4	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

Page 1 of 1

[ 4 post ]