Report

• ramyours2003

  SSChampion

  Points: 12268

  More actions

  December 19, 2011 at 4:13 am

  #261927

  i need to prepare the Capacity Report fro all the servers includes the total disc space , used space and free space and how much the db growth as monthly wise .

  can any one suggest how to gather the details and also send me the script for this .

  Appreciate ur help on this .

• subbu1

  Hall of Fame

  Points: 3281

  More actions

  December 19, 2011 at 8:11 am

  #1423121

  select

  a.FILEID,

  [FILE_SIZE_MB] =

  convert(decimal(12,2),round(a.size/128.000,2)),

  [SPACE_USED_MB] =

  convert(decimal(12,2),round(fileproperty(a.name,'SpaceUsed')/128.000,2)),

  [FREE_SPACE_MB] =

  convert(decimal(12,2),round((a.size-fileproperty(a.name,'SpaceUsed'))/128.000,2)) ,

  NAME = left(a.NAME,15),

  FILENAME = left(a.FILENAME,30)

  from

  dbo.sysfiles a

  Results:

  FILEID FILE_SIZE_MB SPACE_USED_MB FREE_SPACE_MB NAME FILENAME

  ------ -------------- -------------- -------------- --------------- ------------------------------

  1 2.94 2.88 .06 Northwind D:\MSSQL\DATAorthwnd.mdf

  2 1.00 .46 .54 Northwind_log D:\MSSQL\DATAorthwnd.ldf

• ramyours2003

  SSChampion

  Points: 12268

  More actions

  December 20, 2011 at 5:02 am

  #1423562

  thanks for sending i want all the databases in percentage growth instead of getting one db result .

• Koen Verbeeck

  SSC Guru

  Points: 259115

  More actions

  December 20, 2011 at 5:19 am

  #1423566

  ramyours2003 (12/20/2011)

  ---

  thanks for sending i want all the databases in percentage growth instead of getting one db result .

  What have you done so far?

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP