User Tools

Site Tools


public:8086_issue:vss_e_writererror_nonretryable

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

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