MSSQLSERVER_32040
New: 17 July 2006
Details
Product Name |
SQL Server |
Product Version |
9.0 |
Product Build Number |
9.00.2047 |
Event ID |
32040 |
Event Source |
MSSQLSERVER |
Component |
SQLEngine |
Message Text |
The alert for 'time behind' 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 age of the oldest unsent transaction 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 age of the oldest unsent transaction is a performance metric that can help you evaluate the potential for data loss as measured by the number of minutes of unsent transactions. This metric is especially relevant for high-performance mode sessions. However, this metric is also 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
Other Resources
Database Mirroring Sessions
Using Warning Thresholds and Alerts on Mirroring Performance Metrics