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 12»»

Sudden Increase in Database Size Expand / Collapse
Author
Message
Posted Tuesday, May 3, 2011 1:37 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Saturday, January 18, 2014 4:04 PM
Points: 1,118, Visits: 856
Hi,

There was a sudden increase in the size of the production database. The database size grew by around 1GB & the transaction log file size also grew by around 1.3 GB. Under normal circumstances the database grows at the rate of 10-20 MB per day. I did check the size of tables & the indexes, there was not much change. We make a backup of transaction logs every hour & i came to notice that between size of the backup file at 4PM was 1.38 GB whereas under normal circumstances size of backup file ranges from 1MB-16MB.

How can I come to know what transaction has caused the sudden increase in the database size.

regards,
Nithin
Post #1102149
Posted Tuesday, May 3, 2011 2:03 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, July 9, 2014 6:20 PM
Points: 1,202, Visits: 1,928
Looping

Thanks

Post #1102157
Posted Tuesday, May 3, 2011 2:25 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 2:17 AM
Points: 42,466, Visits: 35,533
Did an index rebuild job run around that time?


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1102164
Posted Tuesday, May 3, 2011 2:50 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Saturday, January 18, 2014 4:04 PM
Points: 1,118, Visits: 856
Nope. Did not rebuild the index yesterday.
Post #1102171
Posted Tuesday, May 3, 2011 3:17 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, July 2, 2014 2:36 AM
Points: 462, Visits: 522
to get an overall idea.

what is the overal size of the database and transaction log?
what are the autogrow values of the files?
what is the free space of the database and the transaction log?
Post #1102181
Posted Tuesday, May 3, 2011 3:47 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Saturday, January 18, 2014 4:04 PM
Points: 1,118, Visits: 856
Database Size:10,417 MB Space Used:10238 MB
Log File Size: 1,524 MB Space Used: 22 MB



Auto Growth for Data File:By 10 percent, unrestricted growth
Auto Growth for Log File: By 10 percent, unrestricted growth

Data File Free Space: 177 MB
Log File Free Space:1501MB
Post #1102193
Posted Tuesday, May 3, 2011 3:56 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, July 9, 2014 6:20 PM
Points: 1,202, Visits: 1,928
Can u give sql server Log and Transaction Log of that time...

Thanks

Post #1102196
Posted Tuesday, May 3, 2011 4:16 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Saturday, January 18, 2014 4:04 PM
Points: 1,118, Visits: 856
Date,Source,Severity,Message
05/02/2011 23:00:10,Backup,Unknown,Log was backed up. Database: This is an informational message only. No user action is required.
Post #1102201
Posted Tuesday, May 3, 2011 4:34 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Monday, July 18, 2011 3:54 AM
Points: 492, Visits: 481
any operation performed that was not a part of daily routine

Regards,

Syed Jahanzaib Bin Hassan
MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

My Blog
www.aureus-salah.com


Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

My Blog
www.aureus-salah.com
Post #1102215
Posted Tuesday, May 3, 2011 4:44 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Saturday, January 18, 2014 4:04 PM
Points: 1,118, Visits: 856
No operations were performed. All jobs are scheduled towards the End Of Day.
Post #1102216
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse