• GilaMonster - Wednesday, March 29, 2017 5:09 AM

    andrew gothard - Wednesday, March 29, 2017 5:06 AM

    If you have low use, over provisioning and many cores your CPU ready time and performance is really going to suck - maybe not now, but at some point.

    Depends what else the VM is sharing the host with.

    Quite true, but if the host is at all busy it's going to get nasty.  Highish utilization (as long as you're not running at 90 - maxed out all the time, obviously) is generally the way to go.  Also, with VMware (no idea about HyperV, we don't use it on our SQL Server infrastructure) if you're under provisioned and need more cores, that's online.  If over provisioning is killing your performance, removing cores requires a reboot to take effect.
    In terms of what it's sharing with - I really like, and I mean really, really like if your infrastructure can work with it - SQL Server dedicated infrastructure where possible.  SQL Server and other stuff (app / file server) doesn't play nicely in a lot of cases - although with some stuff you're going to find SQL Server and app server on the same VM is your best call.

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.