Post reply

High Space Used in Database

  • August 19, 2012 at 1:42 am

    #150102

    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...

  • August 20, 2012 at 2:00 am

    #1527457

    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.

  • August 20, 2012 at 3:35 am

    #1527476

    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