Database Expansion

• Dana Bibeault

  Hall of Fame

  Points: 3670

  More actions

  December 7, 2007 at 12:48 pm

  #76844

  We will be iexpanding our database about 40GB in the very near future. The current size is 250GB and there is 88GB free on the SAN. So, there is enough space for the expansion. Can anyone guess at how long it would take to expand all at once? Should we do 10GB at a time or do all 40Gb at once. Any guesses how long it would take. Using SQL 2000 SP4 standard edition with 4GB memory quad processors.

• Prakash Heda

  SSCertifiable

  Points: 5539

  More actions

  December 7, 2007 at 4:52 pm

  #758246

  both way its fine....though just to avoid any unforseen issues, database blocking....preferable 10gb at once....

  Prakash Heda
  Lead DBA Team - www.sqlfeatures.com
  Video sessions on Performance Tuning and SQL 2012 HA

• Jeff Moden

  SSC Guru

  Points: 1004434

  More actions

  December 8, 2007 at 10:10 am

  #758302

  Double posting is so rude... waste time answering one only to find answer on the other.

  http://www.sqlservercentral.com/Forums/Topic430841-5-1.aspx

  http://www.sqlservercentral.com/Forums/Topic430840-146-1.aspx

  --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)