High Space Used in Database

  • I am getting alerts for high space used in database 90% in my one of the production server. Can any one please help me how to trouble shoot for this...

    I will appreciate for your respance...

  • Data file more than 90% full, find big tables and delete data no longer needed, add more space to the file, as a counter measure check the auto growth settings in case it fills up over night when your not in the office to take action.

  • Do you have enough free disk space?

    Please run this script and post the output here:use <dbname>

    go

    select f.file_id, f.physical_name, g.name 'File Group', size/128 'Size(MB)', FILEPROPERTY(f.name , 'SpaceUsed')/ 128 'Space Used (MB)'

    from sys.database_files f

    left outer join sys.filegroups g

    on g.data_space_id = f.data_space_id

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply