MSSQLSERVER_32042
Applies to: 
SQL Server
Details
| Attribute | Value |
|---|---|
| Product Name | SQL Server |
| 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'. |
Explanation
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.
User Action
Check the loads on the principal and mirror server instances and their network connection for the cause.
See Also
Database Mirroring (SQL Server)
Use Warning Thresholds and Alerts on Mirroring Performance Metrics (SQL Server)
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for