Viewing 5 posts - 1 through 5 (of 5 total)
ps (7/7/2009)
General rule of the thumb is,30% rebuild
thanks for that ps.
I know manually truncating the logs is hurting performance, and shrinking isnt a good idea, but when i come...
July 7, 2009 at 7:27 am
Thanks for the suggestions, i'll have a look at giving some of them a try. We're currently reindexing when the avg fragmentation is above 10%, do you think it...
July 7, 2009 at 6:55 am
another point that may or may not be useful. there are a couple of databases that have a 5gb log file, when you use DBCC SQLPERF(logspace) it says its...
July 7, 2009 at 4:23 am
george sibbald (7/6/2009)
reindex jobs can produce a lot of transaction log activity, especially if a database is dominated by one large table. check log usage during your reindex window.
It does...
July 7, 2009 at 4:09 am
yeah but with logs being shipped every half hour shouldnt that clear out the log file? It shouldnt need to grow that big surely.
I know it gets to silly...
July 6, 2009 at 7:15 am
Viewing 5 posts - 1 through 5 (of 5 total)