Number of ERRORLOG files

Name:	Number of ERRORLOG files
Platform:	Sqlserver
Category:	Security
Premium package:	Security and compliance package
Description:	Checks the number of error log files created on the operating file system.
Long description:	Checks the number of error log files created on the operating file system. The SQL Server error log contains important information about major server events. Retaining more error logs helps prevent loss from frequent recycling.
Version:	1.22
Default schedule:	28 1 1 *
Requires engine install:	Yes
Compatibility tag:	[CDATA[.[type=‘instance’ & databasetype=‘sqlserver’]/instance[maj_version > ‘2005’ & hasengine=‘YES’ & eng_inst_priv = 0 & (engine_edition = ‘Microsoft SQL Server’ \| engine_edition = ‘Azure SQL Managed Instance’)

Parameters
Name	Default value	Description
return status	1	Return status value (ALARM – 2, WARNING – 1, or OK – 0) when the number of error log files (created on the operating file system) is less than “minimum error log files” parameter value.
history threshold	365	The maximum number of days to keep statistics for in the historic tables.
minimum error log files	7	The number of error log files (created on the operating file system).

Feedback