Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Unusual Database growth SQL Server 2000 Expand / Collapse
Posted Monday, October 28, 2013 11:46 AM


Group: General Forum Members
Last Login: Wednesday, July 23, 2014 10:32 AM
Points: 22, Visits: 319
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.
Post #1509062
Posted Tuesday, October 29, 2013 5:32 AM

SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 6:37 AM
Points: 906, Visits: 2,863
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


About Me
Post #1509283
Posted Friday, November 1, 2013 5:24 AM



Group: General Forum Members
Last Login: Wednesday, September 10, 2014 1:06 PM
Points: 2,829, Visits: 8,479
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.

Post #1510551
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse