--To check the
log file usage
SELECT RTRIM(instance_name) + ' (used in kb)',
cntr_value
FROM sys.dm_os_performance_counters
WHERE
counter_name = 'Log
File(s) Used Size (KB)'
--To check the
initial file size of the log size
Use sp_helpfile
--To check the
log file initial size and percentage of the log file usage
DBCC SQLPERF(LOGSPACE);
GO
No comments:
Post a Comment