Post upgrading question

I have moved my SQL 7.0 to a brand new machine with SQL
2000 using the copy database Wizard. however it seems to
be too slow now. Does anyone know what I can do to speed
this up? Should I do anything particulary after upgrading.
Thanks for any help -RobOne thing is sp_updatestats.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Rob" <rob@.nul.ca> wrote in message
news:f1ba01c40c37$363f7700$a101280a@.phx.gbl...
> I have moved my SQL 7.0 to a brand new machine with SQL
> 2000 using the copy database Wizard. however it seems to
> be too slow now. Does anyone know what I can do to speed
> this up? Should I do anything particulary after upgrading.
> Thanks for any help -Rob|||Hi Rob,
I agree with Tibor. Also, I'm including some supplemental information below:
319942 HOW TO: Determine Proper SQL Server Configuration Settings
http://support.microsoft.com/?id=319942
298475 HOW TO: Troubleshoot Application Performance Issues
http://support.microsoft.com/?id=298475
243589 HOW TO: Troubleshoot Slow-Running Queries on SQL Server 7.0 or Later
http://support.microsoft.com/?id=243589
243588 HOW TO: Troubleshoot the Performance of Ad-Hoc Queries
http://support.microsoft.com/?id=243588
HOW TO: Troubleshoot Application Performance with SQL Server
http://support.microsoft.com/?id=224587
Please try the suggestions in the above articles, which will help you
troubleshoot the performance issue of SQL Server.
Regards,
Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.