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

Version 4

    Purpose

     

    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. 

     

    Resolution

     

    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

     

    virtualsocket.JPG

     

    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