Datafile percentages

• johnymoss

  SSC Veteran

  Points: 279

  More actions

  July 3, 2013 at 3:03 am

  #274640

  Does anyone have any handy T-SQL for datafile percentages?

  What I am looking for is the percentage of the datafiles size in relation to each other

  for example:

  total size 4GB

  Primary 10%

  Log 15%

  Data 1 20%

  Data 2 20%

  Index 35%

  Many thanks J.