High CPU usage on one CPU core when using a multi-core server for Veeam ONE database

KB ID: 1624
Products: Veeam ONE
Version: all
Published:
Last Modified: 2016-10-19

Challenge

On the SQL Server 2008 R2 Express where Veeam ONE database is located, one of CPU cores is consistently showing high utilization (almost always close to 100%), even if other CPU cores are idle (5-9% utilization).

Cause

This is by Microsoft design. SQL Server 2008 R2 Express is limited to use only one CPU core at a time. If it is installed on a server with multiple CPU cores, it will still use only one CPU core at a time. More information can be found here.

Solution

To get a more scalable database back-end system, upgrade the SQL Server 2008 R2 from the Express to the Standard edition (at least).

More Information

If you have any questions or problems, please contact Veeam Support at http://www.veeam.com/support.html
5 / 5 (2 votes cast)

Report a typo on this page:

Please select a spelling error or a typo on this page with your mouse and press CTRL + Enter to report this mistake to us. Thank you!

Orphus system