This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | Next revision Both sides next 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] 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 |