Ms SQL Server queries available disk space, size and utilization of database data files and log files

In ms SQL Server, you can use the following methods to query the disk space usage, database data files, log files, and Utilization:

1. query the remaining space of each disk partition:
Exec master. DBO. xp_fixeddrives

2. query the data files and log files of the database (including the file group, current file size, maximum file size, file growth settings, file logical name, and file path)
Select * from [database name]. [DBO]. [sysfiles]
The conversion file size is measured in MB:
Select name, convert (float, size) * (8192.0/1024.0)/1024. From [database name]. DBO. sysfiles

3. query the disk usage of the current database:
Exec sp_spaceused

4. query the size and utilization of log files of each database on the database server
DBCC sqlperf (logspace)

For more information about databases, see sqlperf of SQL Server online help and how to use sp_spaceused.