to view space in mdf file

• Maverick100877

  SSCertifiable

  Points: 5240

  More actions

  December 28, 2006 at 9:42 pm

  #170891

  Hi

  We have the dbcc sqlperflog(logspace) to view the used and free space in transaction logs. But how do we see the used and free space in the data files(mdf and ndf).

  Sp_helpdb only gives me the size of the database but I would like to see the used and available free space(like we  have the taskpad view in enterprise manager).

   

• MohammedU

  SSCoach

  Points: 19644

  More actions

  December 29, 2006 at 8:22 am

  #680508

  There is no command to get this other than DBCC showfilestats ...

  Use DBCC showfilestats to get the total  and used extents for a database and then calculate the space.

  MohammedU
  Microsoft SQL Server MVP