About Me

Barking, Essex, United Kingdom
MCITP DBA ,MCITP BI & Oracle OCP 11G

Wednesday, January 7, 2015

Difference in Log File Size Growth and initial log file size

--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