• Repost - originally posted 30-10-2012

Error log configuration

The default retention for SQL Server error logs is 6. This may cause issues if there are a number of SQL Server restarts, you could lose the log with the error in it that you need to investigate.

I always try to increase that retention from 6 to at least 16 (SSMS -> Management -> SQL Server Logs -> Configure). Change the maximum number of error logs - maximum of 99.

Try to keep the size of these logs manageable by regular cycling of the logs.

We do this by executing the stored procedure cycle errorlog and include this as a step in our weekly maintenance.

This way each log is for a week and we should retain the last 16 weeks


Recent Posts

See All

Cardinality estimator

Recently I was asked by a software vendor to review a particular query that ran in under a second on a SQL Server 2014 installation at a compatibility level of 110 (SQL Server 2012), but when run unde

Index fragmentation

A law firm client, occasionally has issues with their legal software, that is provided by the global leader in this field. The response from the software provider is always the same - you have index f

Deleting large amounts of data

I had a client call me about wanting to delete a large amount of data from their database. They knew what tables they wanted to delete from. They also knew that deleting large amounts of data causes t