Please, any one can give me some suggestion about this subject ?
The facts are following: SQL Server 2000 Standard Edition (SP4)
One week ago I switched the recovery model of my database (50 GB size) to simple. I had my reasons. Since then, the procesing time of my OLAP cubes has dramatically raised, in procent of 500-800%.
For exemple, one cube with a 30 minutes processing time before, now is 8 hours.
And the biggest one, with a time of 1.5 hours nor is at 20 hours. I'm destroyed.
After I have notices that, I switched back to full mode, but the situations remains the same. I don't know what to do any more.
Thanks in advance to all willing to give me some sugestions.
Hi Simona,
Your transaction log is bigger now!Switch to simple recovery model and shrink the transaction log.
sql
No comments:
Post a Comment