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.
| 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 |
 |
|
|
|
|
|
SQL Reindex and Reorganize