Ekinlikler
31 Mar 23 - 2 Nis 23
En büyük SQL, Fabric ve Power BI öğrenme etkinliği. 31 Mart – 2 Nisan. 400 ABD doları tasarruf etmek için FABINSIDER kodunu kullanın.
Bugün kaydolunMSSQLSERVER_32043
Applies to: 
SQL Server
| Attribute | Value |
|---|---|
| Product Name | SQL Server |
| Event ID | 32043 |
| Event Source | MSSQLSERVER |
| Component | SQLEngine |
| Symbolic Name | SQLErrorNum32043 |
| Message Text | The alert for 'unrestored log' has been raised. The current value of '%d' surpasses the threshold '%d'. |
This database mirroring event is issued on the mirror server instance to indicate that the amount of unrestored log 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.
An unrestored log is a log that has been received by the mirror server instance and written to disk but is waiting to be restored to the mirror database. The amount of unrestored log in kilobytes (KB) is a performance metric that can help you evaluate the current failover time. The time that is required to apply the unrestored log is the main factor in failover time, along with a short additional time that is required to recover the database and bring it online.
Not
For an automatic failover, the time for the system to notice the failure is independent of the failover time.
Check the loads on the principal and mirror server instances and their network connection for the cause.
Database Mirroring (SQL Server)
Use Warning Thresholds and Alerts on Mirroring Performance Metrics (SQL Server)