--check the files and size and location
select DB_NAME(database_id)as [database name], physical_name as [file location], type_desc,state_desc,
CONVERT(bigint,size/128.0) as [file size in MB ] from sys.master_files with (nolock)
where database_id > 4
--things to check
-- tempdb has a dedicated drive ( not on same drive as the data files)
--log files are on a separate drives
--are there multiple data drives
No comments:
Post a Comment