December 12, 2010 at 9:58 pm
We are running SQL Server 2008 Stnd 64-bit. The production database was about 100mb, but overnight it grew by almost 500%. I checked the actual space used on disk by the tables and the growth is consistent across all tables, regardless of actual record growth.
The key question would be, "what changed". The one thing that occurred during that time frame is that we removed the witness from our mirroring setup. Mirroring is still running.
Any ideas on what would cause this sort of unexplained database growth?
thanks-
December 12, 2010 at 10:09 pm
What about the log file growth and recovery model?
December 12, 2010 at 10:45 pm
Any reindexing/index rebuilts or maintenance plans?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
December 13, 2010 at 12:09 am
Heavy DML operation/migration ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply