Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Peter99
Constraint Violating Yak Guru
498 Posts |
 Posted - 2014-09-23 : 16:28:10
|
| Is there any way to see why database size grow and when?Any script or GUI option.Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-09-23 : 16:57:43
|
| You would have to build something to track each index/heap and then compare the data to previous rows.But often times, database growth is due to rebuilding an index. If there was a sudden growth, check what got rebuilt around that timeframe. SQL needs space in the log and database files to do those transactions.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
db growth