January 4, 2003 at 8:21 am
Hi Forum,
We have a quite large (100 GB) SAP database which I cannot bring it down for more then a night.
My problem is that a REINDEX on the single COEP table (over 20 millions of records, 14 GB) is taking almost 3 hours and blowing my log file. And within an SAP database there are over 25000 tables.
Sometimes I have some consistancy errors.
If you have any VLDB could you tell me what kind of maintenance tasks are you running on your db (I do regullary CHECKDB, UPDATE STAT, UPDATE USAGE), but no reindex yet.
Any advice would be useful
Thanks
Bye
Gabor
January 4, 2003 at 2:59 pm
Thats a good start, you definitely need to rebuild the indexes. I dont know that you can reduce the log usage. You might use the defrag option to do it online and maybe (have not tested) that might generate small transactions so you do could log backups to maintain the log size at something reasonable. Are you doing a single index at a time, or all at once?
How big does the log file get? Is it just a matter of space?
Andy
January 5, 2003 at 6:42 am
Yes it's matter of space AND time.
I have an 18 GB partition for the log.
Normally I have 5 GB allocated and that's fine for the allday operation.
But when I do a reindex then I'm getting out of disk space.
And my second problem is that I do not have too big maintenance windows.
How do you basically maintain your VLDB's?
Bye
Gabor
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply