I continue to run into this issue over and over in the field so I wanted people to be aware of this possible problem. In a Database Availability Group (DAG), if your databases are randomly mounting...
Updated Jul 01, 2019
Version 2.0
Blog Post
With the help of Lalita Jat, another PFE team member, we have an additional answer about the 'high performance' setting within the Windows Server OS:
• If the server is set to High Performance - Windows places the system in the highest performance state and disables the dynamic scaling of performance in response to varying workload levels. Therefore, special care should be taken before setting the power plan to High Performance as this can increase power consumption unnecessarily when the system is underutilized.
• We will have to disable “Allow the computer to turn off this device to save power” option of Power management from NIC. Setting the server in High Performance would not stop the NIC to go in sleep mode whenever there is no activity, as that is a setting at an OS level. The setting on NIC will take preference in this situation.
Hopefully this answers the question about the high performance setting.