Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Reindexing job slowing down SQL2K after upgrade from SQL7 Expand / Collapse
Author
Message
Posted Friday, October 26, 2007 2:53 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, April 30, 2008 6:17 PM
Points: 1, Visits: 4
I run a maintenance job once a week that includes reindexing. The server was recently upgraded from SQL7 to SQL2K. Now after the maintenance job runs the response of the database slows down. There is nothing new happening on this SQL server other than the upgraded SQL version. If I stop the SQL2K server and then restart it after the maintenace job has been run, normal performance is restored. Any thoughts on what may be happening here?
Post #415629
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse