iMC with sqlserver shows the MSSQL ERRORLOG overload

PLAT

2023-06-03 00:39:12 Published

0 Followed
0Collected ，544Browsed

Liangjinbao

Network Topology

irrelevant

Problem Description

The customer uses iMC and sqlserver databases, the database generates errorlog, overload the disk capacity,

Process Analysis

sqlserver will generate 5 errorlog files, it is just a log recored, nothing about the business,

Solution

Methods is as follows:

By default, SQL Server saves seven ErrorLog files named ErrorLog and Errorlog.1-6. If a file is too large, run the following command to delete it. Because these errorlogs are generated in a loop, an EXEC sp_cycle_errorlog will generate a new errorlog and delete Errorlog.6. So it's first in, first out (queue like that) so you iterate through it six times and you refresh the errorlog all the time.

sql commands:

EXEC sp_cycle_errorlog

And you can refer to the Microsoft official site to do the size limit

https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/scm-services-configure-sql-server-error-logs?view=sql-server-ver16

Please rate this case:

0 Comments

No Comments

iMC with sqlserver shows the MSSQL ERRORLOG overload

Network Topology

Problem Description

Process Analysis

Solution

Add Comments: