How to determine free datafile space during Index build?

• SQL_EXPAT

  SSCrazy

  Points: 2708

  More actions

  April 14, 2009 at 7:16 am

  #133047

  I'n creating a clustered index on a 800 mill row and am worried my used datafile space might be hitting the max size.

  How can I monitor this in SQL2000? sp_spaceused hangs or is blocked rather.

  tks

  thanks

  SQL_EXPAT

• MANU-J.

  SSC-Dedicated

  Points: 31126

  More actions

  April 15, 2009 at 4:21 pm

  #978490

  Why don't you try fetching that info using the standard reports if your instance version is SP2 or later.

  MJ

• Laerte Poltronieri Junior-367636

  Hall of Fame

  Points: 3314

  More actions

  April 15, 2009 at 8:43 pm

  #978567

  You can estimate the size of your clustered index...

  http://msdn.microsoft.com/en-us/library/ms178085.aspx

  http://msdn.microsoft.com/en-us/library/ms191183.aspx

  $hell your Experience !!![/url]

• SQL_EXPAT

  SSCrazy

  Points: 2708

  More actions

  April 16, 2009 at 6:25 am

  #978749

  the reports are blocked by the CREATE INDEX

  thanks

  SQL_EXPAT

• SQL_EXPAT

  SSCrazy

  Points: 2708

  More actions

  April 16, 2009 at 6:26 am

  #978752

  yes, but this doesn't tell me how much free space you'll need for the SORT.

  thanks

  SQL_EXPAT

• Laerte Poltronieri Junior-367636

  Hall of Fame

  Points: 3314

  More actions

  April 16, 2009 at 6:50 am

  #978762

  Sort operation, but this is estimate.

  http://msdn.microsoft.com/en-us/library/ms179542.aspx

  The second link shows a example with sort too

  http://msdn.microsoft.com/en-us/library/ms191183.aspx

  $hell your Experience !!![/url]