Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 SQL Reindex and Reorganize

Author  Topic 

dastaub
Starting Member

3 Posts

Posted - 2013-11-15 : 11:08:45
A maintenance job runs that REORGANIZES all the indexes and rebuilds all the statistics. Prior to creating and scheduling this job, I dropped and REBUILT all the indexes on all the tables. This job is created to prevent the need to drop and rebuild indexes while maintaining low fragmentation and updated stats.

Why does the maintenance job that REORGANIZES indexes only 24 hours after all the indexes are REBUILT cause the transaction log to grow to the size of the DB itself?
The tables are a few billion bytes in size and the DB is about 12 billion bytes in size.
I thought a reorganize would cause minimal activity if the indexes it is reorganizing had recently been dropped and rebuilt?

robvolk
Most Valuable Yak

15732 Posts

Posted - 2013-11-15 : 11:17:09
Please do not cross post:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=189684
Go to Top of Page
   

- Advertisement -