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

Database File Autogrowth Expand / Collapse
Author
Message
Posted Friday, July 26, 2013 12:43 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, July 30, 2014 4:00 PM
Points: 96, Visits: 252
I have a SQL Server 2005 on Windows Server 2003 all the latest service packs

I am managing my database file growth like a good little DBA and making sure there is plenty of free space in them. Every two weeks I check the db and tran log files and expand manually as needed. I am puzzled because I noticed that one db file is autogrowing even though there is plenty of free space. I am also monitoring the growth of the data and it grows at about 1GB per week and the file has 18GB free space. I also found out that autogrowth occurs every Sunday night 100MB at a time (which is how its set) to about 1.5GB.

Why would my db file be autogrowing when I am checking the file free space

Current file Specs
Mdf file: Space used 429.57GB, Space Reserved 448.52
LDF File: Space used 281.51MB, Space Reserved 64651.49MB

Your help is appreciated


Jeff
Post #1478155
Posted Friday, July 26, 2013 12:51 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 8:42 PM
Points: 17,710, Visits: 15,579
Do you have an index maintenance routine running on Sundays?

Do you have a very large batch job that runs on Sundays that might possibly create and drop tables?




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1478161
Posted Friday, July 26, 2013 4:09 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, July 30, 2014 4:00 PM
Points: 96, Visits: 252
I have a full Index rebuild that happens Sunday at 1 AM.

Your help is appreciated.


Jeff
Post #1478235
Posted Monday, July 29, 2013 2:50 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, May 30, 2014 8:15 AM
Points: 1,056, Visits: 2,687
SORT_IN_TEMPDB you might not have set it so sorting will happen in same DB which might have increased the space growth

Regards
Durai Nagarajan
Post #1478484
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse