Datafile administration

• sb5473

  SSC Enthusiast

  Points: 127

  More actions

  June 6, 2008 at 5:28 am

  #154416

  Hi,

  how can I know the percentage of usage of my datafiles (sql server 2005), as regards the tlog files I use dbcc sqlperf(logspce), is there a similar command for datafiles?

  the dimension of backup full is the space allocated for datafiles or is it relative to the phisical space used?

  Thanks a lot for your answers! 😀

• Kev Riley

  SSCrazy Eights

  Points: 9075

  More actions

  June 6, 2008 at 6:22 am

  #825385

  There is an undocumented DBCC command you can use DBCC SHOWFILESTATS.

  Check here http://www.databasejournal.com/features/mssql/article.php/3414111 for a explanation of its usage and a sample script from Greg Larsen

  Kev

• Ignacio A. Salom Rangel

  SSC-Insane

  Points: 20443

  More actions

  June 7, 2008 at 5:23 pm

  #825843

  Thanks for the tip!

  ---

  
  
  My blog
  

• sb5473

  SSC Enthusiast

  Points: 127

  More actions

  June 9, 2008 at 1:49 am

  #825991

  Thanks a lot for your reply, I will try today.

  For sure it will be useful!:P