Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

SQL 2000 maintenance plan/Optimization - reorg database and indexes - Running SLOW Expand / Collapse
Posted Monday, June 24, 2013 10:30 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, May 5, 2016 11:17 AM
Points: 1, Visits: 28
I have inherited the management of a SQL 2000 server (running on MS Server 2003 in a vmWare environment) that has been having some performance problems. One thing I noticed while looking at some of the logs for completed data maintenance tasks, is that prior to a specific date the optimization task that did the reorg database and indexes on a specifice database typically took about 45 mins, but, since a specific timeframe (mid March '13) it never takes less than 5 to 8 hours. Around that same timeframe (mid March '13) we have seen severe slowdowns in that environment/sql server but not absolutely sure the two issues are related since the environment slow down is occassional and the long processing time for the reorg is consistent. It was like there was a line drawn in the sand...
I have done INDEXDEFRAG on the tables/indexes that appeared fragmented and I have checked with SHOWCONTIG and the indexes don't look fragmented any more.
I haven't done a rebuild on the indexes yet because I can only imagine it will take a large block of time and that server and data is used almost around the clock.
Any thing stand out to anyone? Any suggestions of things to try to troubleshoot the issue...especially things I can do while the database is still online?
Thanks in advance for any help you can give.
Post #1466832
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse