查数据库的日志文件的大小

DECLARE @t TABLE(
	[Database Name] NVARCHAR(100)
	,[Log Size (MB)] DECIMAL(15,2)
	,[Log Space Used (%)] DECIMAL(15,2)
	,[Status] INT
)
INSERT INTO @t
EXEC ('DBCC SQLPERF(LOGSPACE)')

SELECT * FROM @t 
--WHERE [Database Name]='?' --写你要查的数据库的名称

;WITH filesize AS(
    SELECT database_id,TYPE,SIZE * 8.0 / 1024 SIZE
    FROM   sys.master_files
)
SELECT NAME,
       state_desc,
       recovery_model_desc,
       (
       	   SELECT SUM(SIZE) FROM filesize
           WHERE  TYPE = 0 AND filesize.database_id = db.database_id
       ) AS DataFileSizeMB,
       (
           SELECT SUM(SIZE) FROM filesize
           WHERE  TYPE = 1 AND filesize.database_id = db.database_id
       ) AS LogFileSizeMB
FROM   sys.databases AS db