August 19, 2012 at 1:42 am
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
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
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