2 Replies Latest reply on Jun 18, 2015 12:12 PM by Charley Saint

    sql server performance in particular in a VM environment

    Paul Tormey
    Paul Tormey Jun 17, 2015 11:17 PM

      How many of you have Solidworks ePDM running in a VMWare environment?

       

      In particular, running the Archive Server and the Database Server applications on separate VM hosted servers.

       

      Are there any Solidworks recommendations on running in a VMWare environment?

       

      Any Solidworks ePDM technical articles that are worth reading?

        • Re: sql server performance in particular in a VM environment
          Andries Koorzen
          Andries Koorzen Jun 18, 2015 10:44 AM (in response to Paul Tormey)

          Hi Paul

           

          We are succesfully running EPDM on seperate VMs and have some clients doing so as well.

           

          The main considerations for the EPDM VMs are:

           

          • Static IP addresses for all VMs
          • Static MAC addresses for all VMs
          • Sufficient resources for the VM over and above the host operating system

           

          Hope this helps

          • Re: sql server performance in particular in a VM environment
            Charley Saint
            Charley Saint Jun 18, 2015 12:12 PM (in response to Paul Tormey)

            Hey Paul,

             

            The big problem we usually see with SQL on VM's is disk saturation. If you were seeing poor performance on a physical server with internal disks then you could just pop into performance monitor and see disk saturation and that would be the end of it. In a VM that disk utilization may be coming from an entirely different VM because it's a shared disk. Long story short, performance problems are harder to diagnose on a VM, but if you know where to look and have a good virtualization team then you should be fine.