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
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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 @ 1:15 AM
Points: 825, Visits: 2,660
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: 2 days ago @ 8:10 PM
Points: 2,826, Visits: 8,463
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