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 |
|
tracy5436
Yak Posting Veteran
50 Posts |
 Posted - 2010-05-14 : 18:40:51
|
| Hi,My database size has grown considerably in the last few months - from 6 gb to 11 gb. Every day it seems to grow 200 mb, and there is no great volume of data being input. Maintenance procedures have been run on the database, such as database consistency check commands, update statistics, and recompile stored procedures. The recovery model is set to simple.What could be causing this ? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-05-15 : 04:34:58
|
| There is a script here:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=61762which will tell the the size (and slack space) of each table.Suggest you run that daily for a few days and see which tables are changing. There might be a table that ought to be being purged [of "stale" data] but isn't |
 |
|
|
|
|
|
Database size growth