public:8086_issue:vss_e_writererror_nonretryable
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | |||
|
public:8086_issue:vss_e_writererror_nonretryable [2020/11/11 20:30] edward.chan |
public:8086_issue:vss_e_writererror_nonretryable [2020/11/12 16:37] (current) edward.chan |
||
|---|---|---|---|
| Line 131: | Line 131: | ||
| <html> | <html> | ||
| To resolve this issue, either: | To resolve this issue, either: | ||
| - | <br/> | + | <br> |
| - | <br/> | + | |
| - | 1. Create additional backup sets (to be performed at different time) for the excess databases. | + | <ol> |
| - | <br/> | + | <li><font color=black>Create additional backup sets (to be performed at different time) for the excess databases. |
| - | <br/> | + | <br> |
| - | or | + | <br> |
| - | <br/> | + | or |
| - | <br/> | + | |
| - | 2. Increase the maximum number of worker threads on the MS SQL Server. | + | </font></li> |
| - | <br/> | + | <br> |
| - | <br/> | + | |
| - | To configure the max worker threads option: | + | <li><font color=black>Increase the maximum number of worker threads on the MS SQL Server. |
| - | <br/> | + | <br> |
| + | <br> | ||
| + | To configure the max worker threads option: | ||
| + | <br> | ||
| + | <br> | ||
| <ul> | <ul> | ||
| <li> | <li> | ||
| - | <font color=black>In Object Explorer, right-click a server and select <b>Properties</b>.</font> | + | <font color=black>In the Object Explorer, right click a server and select <b>Properties</b>.</font> |
| </li> | </li> | ||
| + | <br> | ||
| <li> | <li> | ||
| <font color=black>Click the <b>Processors</b> node.</font> | <font color=black>Click the <b>Processors</b> node.</font> | ||
| </li> | </li> | ||
| + | <br> | ||
| <li> | <li> | ||
| <font color=black>In the <b>Max worker threads</b> box, type or select a value for the max worker thread.</font> | <font color=black>In the <b>Max worker threads</b> box, type or select a value for the max worker thread.</font> | ||
| </li> | </li> | ||
| </ul> | </ul> | ||
| - | For more details, refer to the following article: <a class="postlink" href="https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-the-max-worker-threads-server-configuration-option">https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-the-max-worker-threads-server-configuration-option</a> | + | <br> |
| + | <br> | ||
| + | For more details, refer to the following article: <a href="https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-the-max-worker-threads-server-configuration-option">https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-the-max-worker-threads-server-configuration-option</a> | ||
| <br> | <br> | ||
| <br> | <br> | ||
| <font color=#FF0000> | <font color=#FF0000> | ||
| Important: | Important: | ||
| - | </font> | + | |
| <br> | <br> | ||
| - | Please consult with an experienced database administrator or certified SQL Server technician before making any change to the maximum worker threads. | + | Please consult with an experienced database administrator or certified SQL Server technician before making any change to the maximum worker threads.</font> |
| + | |||
| + | |||
| + | </font></li> | ||
| </html> | </html> | ||
| ===== Keywords ===== | ===== Keywords ===== | ||
| - | MS SQL Server, worker threads, max, databases | + | mssql, sql, worker threads, max, databases |
public/8086_issue/vss_e_writererror_nonretryable.txt · Last modified: 2020/11/12 16:37 by edward.chan
