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
Author
Message
Posted Monday, October 28, 2013 11:46 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, November 26, 2014 9:20 AM
Points: 25, Visits: 333
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: Yesterday @ 1:37 AM
Points: 997, Visits: 3,089
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

@SeanPearceSQL

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


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, December 11, 2014 6:43 PM
Points: 2,838, Visits: 8,570
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