Subject | Analyse database growth |
---|---|
Author | Fabiano Bonin |
Post date | 2007-10-18T17:31:40Z |
Yesterday i had a database with 100mb, and today morning it had 9GB.
I'm pretty sure this growth was caused by some recursive trigger or
procedure that was kept running for a loong time and then aborted, but
i would like to investigate the specific cause of this problem to fix
my application.
I did a backup/restore and the restored database is with 100MB again.
I have a copy of the 9GB database. Is there some way to see what happened there?
Regards,
Fabiano.
I'm pretty sure this growth was caused by some recursive trigger or
procedure that was kept running for a loong time and then aborted, but
i would like to investigate the specific cause of this problem to fix
my application.
I did a backup/restore and the restored database is with 100MB again.
I have a copy of the 9GB database. Is there some way to see what happened there?
Regards,
Fabiano.