find out Log and Data file growth?

• sumith1andonly1

  SSCrazy

  Points: 2250

  More actions

  January 16, 2013 at 6:33 am

  #272893

  Query to find out Log and Data file growth are set to a constant value

• Ant-Green

  SSC Guru

  Points: 113507

  More actions

  January 16, 2013 at 6:36 am

  #1577798

  select * from sys.master_files

  growth = increment

  is_percent_growth = 1 = growth(%)

  is_percent_growth = 0 = groeth(MB)