Kurt W. Zimmerman (12/9/2013)
What are you doing to manage the transaction log? If your database is in Full recovery mode you should have a job that performs a transaction log backup.Also would you consider just rebuilding the indexes on those fragmented indexes > than some percent of fragmentation?
Just some random thoughts here.
Good luck.
Kurt
thanks for the random thoughts. 🙂
first step is to put the database in SIMPLE mode and do a full backup.
i normally use the scripts from ola.hallengren.com which checks the level of fragmentation but in this case, this is an SAP database and we do everything according to their best practices, and a reindex of all tables is recommended. secondly (if i understand ola's scripts correctly) the frag check step requires to read the entire table to determine the fragmentation, which adds extra time and i/o. we have a narrow maintenance window and are unsure about the timing.