meta données pour cette page
  •  

Ceci est une ancienne révision du document !

Server Disks

SELECT  DISTINCT @@SERVERNAME AS 'Server Name',
volume_mount_point as VolumeName,
dovs.logical_volume_name AS VolumeLabel,
total_bytes /1024/1024/1024 as VolumeCapacityGB, 
available_bytes /1024/1024/1024 AS VolumeFreeSpaceGB,
(select ((available_bytes/1048576* 1.0)/(total_bytes/1048576* 1.0) *100)) as PercentageFreeSpace
FROM sys.master_files mf
CROSS APPLY sys.dm_os_volume_stats(mf.database_id, mf.FILE_ID) dovs
GO

TOTAL DB et TLOG (vue OS) 

with fs
as
(
    select database_id, type, size * 8.0 / 1024 / 1024 size
    from sys.master_files
)
select 
    name,
    (select sum(size) from fs where type = 0 and fs.database_id = db.database_id) DataFileSizeGB
	,(select sum(size) from fs where type = 1 and fs.database_id = db.database_id) LogFileSizeGB
from sys.databases db

DB and TLOG per File

SELECT DB_NAME() AS DbName, 
file_id, name AS logical_name, physical_name,
size*8.0/1024/1024 AS CurrentSizeGB, 
size*8.0/1024/1024 - CAST(FILEPROPERTY(name, 'SpaceUsed') AS INT)*8.2/1024/1024 AS FreeSpaceGB
FROM sys.database_files
ORDER BY DbName,logical_name ASC