1. To check the available disk space, you may use the undocumented system extended stored procedure xp_fixeddrives, which can return the available free space (MB) for each fixed drive. You can run it as follows:
Exec master.dbo.xp_fixeddrives
2. As for the database data file and transaction log space allocation and utilization, you may use the following query to query this:
1) You may check the file size (in MB) by query the sysfiles table as follows:
select name, convert(float,size) * (8192.0/1024.0)/1024. from dbo.sysfiles
2) To check the utilization, you may use sp_spaceused:
Exec sp_spaceused
The database_size column is the sum of data files and log files, and the "unallocated space" column is the total unallocated space in the database.
To check the log file@#s utilization, you may use:
DBCC SQLPERF(LOGSPACE)
For more information regarding the sysfiles table, dbcc sqlperf(logspace) and sp_spaceused, please refer to SQL Server Books Online.
In fact, you can view the similar information in SQL Enterprise Manager: in Enterprise Manager, right click the database, click View -> Taskpad, then you can see the data and log files size and utilization at the right
延伸阅读
文章来源于领测软件测试网 https://www.ltesting.net/
