In which system table can I see the used space of the logfile file?

朗基奴斯

sysfile looks at the allocation size of the logfile file
 You can see the space usage of data files in sysindexes, but where is the usage of logfile space?
   Not found, thank you all

恶魔右指

sysdatabases this is the database information

mill1128

Yes i don't know

恶魔右指

Here are the join relationships of the tables:
declare @object_id int
set @ object_id = object_id ('ta')
  select name from syscolumns where id = @ object_id and colid in (
   select colid from sysindexkeys where @ object_id = id and indid in (
    select indid from sysindexes where @ object_id = id and name in (
     select name from sysobjects where xtype = 'PK' and parent_obj = @ object_id
   )))

朗基奴斯

No, to log space information, use DBCC SQLPERF (LOGSPACE)
Can be found out, but I want to know in which table the usage of this log space is placed. I haven't found it for a long time

fanfan1980

sysaltfiles

朗基奴斯

The one is the same as in sysfiles, only the space allocated to him is recorded, and it does not indicate how much space the log has used.

朗基奴斯

Does anyone know?

朗基奴斯

Which prawn to answer, still can't find it.

vgf10002

Log File (s) Used Size (KB) of each database in sysperfinfo