Post reply

Unusual Database growth SQL Server 2000

  • October 28, 2013 at 11:46 am

    #278521

    How to find the reason for user database growth in last few days back.

    I also need a query to find the SQL database table growth rate and statistics.

    User database growth occupied 15gb of the drive space which never happened before. How to investigaet what caused the database growth.

  • October 29, 2013 at 5:32 am

    #1662291

    To determine tables growth rates you need to keep a record of table sizes periodically. I store table sizes on a daily basis to draw growth reports.

    The SQL Guy @ blogspot[/url]

    @SeanPearceSQL

    About Me[/url]

  • November 1, 2013 at 5:24 am

    #1663380

    You could try looking at your transaction log backups, and see what time of day they were very large. Then try to figure out what was running at that time.

    I keep 30 days of server side trace files, so I can look there to see what was runnng at a particular time.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply