32042

Product Name

Event ID

32042

Event Source

MSSQLSERVER

Component

SQLEngine

Symbolic

Name

SQLErrorNum32042

Message Text

The alert for ‘unsent log’ has been raised. The current value of ‘%d’ surpasses the

threshold ‘%d’.

This database mirroring event is issued on the principal server instance to indicate that the

amount of unsent log has reached a user-specified threshold value. Typically, this event occurs

because the performance of the system has changed. Either the bandwidth between the two

systems has decreased, or the load has increased.

The amount of unsent log is a performance metric that can help you evaluate the potential for

data loss in terms of the number of kilobytes (KB) of unsent log. This metric is particularly

relevant for high-performance mode sessions. However, this metric is also a relevant for high-

safety mode session when mirroring is paused or suspended because the partners become

disconnected.

Check the loads on the principal and mirror server instances and their network connection for

the cause.

ﾉ

Expand table