April 21, 2010 at 1:54 pm
I have been tasked with giving the amount of growth on my DB.
So, I worte down the size of the MDF (in bytes) yesterday.
I thought I would go in today and get the size of the MDF to gbe able to give my size estimate..
But..
The size of the MDF was the same as yesterday and has the same date as yesterday.
What am I doing wrong..and/or is there a better way to give one days db growth?
April 21, 2010 at 1:57 pm
The physical MDF/LDF files contain empty space so the DB does not need to expand the files everytime a record is inserted.
sp_spaceused (SQL 2000/2005/2008)
There are several DMV's for 2005/2008
In 2008 if you have enabled the management data warehouse, you can track the growth
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
April 21, 2010 at 2:11 pm
Here's a thread on the topic of DB growth & Capacity Planning.
http://www.sqlservercentral.com/Forums/Topic869838-146-1.aspx
April 21, 2010 at 2:43 pm
thanks
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply