不定时更新
select @@version;
select * from ( SELECT OBJECT_NAME(ii.id) TableName ,rows FROM sysindexes ii INNER JOIN sysobjects oo ON ( oo.id = ii.id AND oo.xtype = 'U ') WHERE ii.indid < 2 ) a where TableName LIKE 'dbo_%_CT' ORDER BY rows desc ;
DBCC SQLPERF(LOGSPACE)
SELECT NAME,DATABASE_ID, LOG_Reuse_Wait, Log_Reuse_Wait_Desc FROM Sys.DATABASES WHERE Name = 'dbname'