Configuring Virtual CPUs To Optimize Performance With SQL Server Express And Shavlik Protect

Version 4



    Shavlik Protect supports multiple virtual processors with multiple cores. However, Microsoft SQL Server 2012 Express Edition SP1 recognizes a maximum of 1 Virtual Socket with 4 cores for that socket. See Compute Capacity Limits by Edition of SQL Server . Shavlik Protect will utilize all cores of a virtual machine configured with a scenario of 4 virtual sockets and 1 core per socket, but SQL Express sees only 1 virtual socket and 1 core.  Timeout issues have occurred when Shavlik Protect is processing and sending information using a virtual machine's full multiprocessor capability while the SQL Express instance has difficulty maintaining pace with its Single Socket 4 core limit. 




    To sync the capabilities of Shavlik Protect and Microsoft SQL Express. Configure the virtual machine that is running the Shavlik Protect Console to use only one virtual socket and a maximum of 4 cores for that socket.  Configure a maximum of 4 virtual sockets and 4 cores per socket for  Microsoft SQL Server 2012 Standard, Web, and Business Intelligence Editions




    Additional Information


    See Compute Capacity Limits by Edition of SQL Server for more information on Virtual Processor utilization by Microsoft SQL


    Affected Product(s)


    Shavlik Protect 9.X