Sample Header Ad - 728x90

Many Small SQL Error Logs

1 vote
1 answer
52 views
I am looking at my SQL Server error logs and noticed that they cycle frequently. Even though the files are small, some are only around 250 lines, they often cycle a number of times per day. This limits the range of time covered by the retained logs. In the *Configure SQL Server Error Logs* screen, the size of the file is not limited, and I do not have an agent job that is recycling the logs. I am also not in the habit of restarting the server several times per day. Any information you can provide to help me track down the cause would be most appreciated. From what I can see, it doesn't seem to be a restart. Each of the queries below returns a datetime that is within 4 seconds of one another on a date in March when we had our system maintenance:
SELECT sqlserver_start_time FROM sys.dm_os_sys_info
SELECT login_time FROM sys.dm_exec_sessions WHERE session_id = 1
SELECT create_date FROM sys.databases WHERE name = 'tempdb'
Asked by Slothy (61 rep)
Apr 4, 2023, 04:25 PM
Last activity: Apr 9, 2023, 09:44 AM