February 21, 2007 at 1:12 pm
My post of twofold.
First, We build cubes using analysis services where data is stored in SQL 2K DB. This month I am noticing that it is taking foreever to build cubes. To give u an example. Previous one cubes used to take 4 hours. Now taking 40 hours. Only change is that we had added one more log file to the DB. Hence we have 400 GB DB with two log files. Does anyone have experienced any issue building cubes in Analysis services when underlying DB has multiple log files?
Secondly, Now I have this DB with two transaction log files. I was thinking of merging the two log files into one file. But so far no luck how to achieve that. Does anyone have a suggestion on how do I merge two log files into one ? Our DB is in Simple recovery status as we do not undergo much updation.
Thanks
February 26, 2007 at 8:00 am
This was removed by the editor as SPAM
May 14, 2007 at 8:54 am
Somehow managed to take all data out and put DB back with one log file. Cubes are behaving as usual. It does not take 40 hours anymore, rather taking 1 hr -4 hrs based cube size.....
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply