I have a 2-node cluster on SQL Server 2016 Standard with failover clustering configured with Dynamic Quorum.
There is one thing that made me confused: do we really need a Witness in this case?
Since I've enabled Dynamic Quorum, my cluster will not go down if one of the nodes goes down.
But some guys said, for the best practice, we still need to configure a Witness. So my question is: will a Witness make any difference?