Database size using sp_spaceused

• Shilong Zhao

  Newbie

  Points: 1

  More actions

  August 27, 2007 at 9:15 pm

  #118090

  Hello,

  I am helping to check and report the size of a database weekly.  I use stored procedure sp_spaceused to get database_size every monday.  But in the past three weeks, I always got the same size of 108.50MB.  It is weird because data are uploaded into database everyday, and database size should increase. 

  I am new on this.  I did google it and couldn't find good answer.  Can anyone help me?

  Thanks a lot,

  Shilong

   

   

• Jeff Moden

  SSC Guru

  Points: 1004646

  More actions

  August 27, 2007 at 11:01 pm

  #729693

  The database has been grown already by either a percentage or a fixed amount and if the new data fits into what was allotted, it will not grow again even if you add new data until the data no longer fits.

  You need to read up about GROWTH and files sizes in Books Online.  Lookup database properties and the like.  Also, you say you are "helping to check and report the size of a database weekly".  Doesn't whoever you're helping already know this?  Why didn't you ask him/her?

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)
  

• MarkusB

  SSC-Dedicated

  Points: 37370

  More actions

  August 28, 2007 at 12:43 am

  #729701

  If you look at the full result of sp_spaceused you should see that data and Index_size have been growing whilt unused is getting smaller. The database itself won't grow, until the unused space is too small to allacate the new data.

  Markus

  [font="Verdana"]Markus Bohse[/font]