Troubleshooting SQL Server 2017 In-Memory OLTP If you have problems with In-Memory OLTP in SQL Server 2017, review this troubleshooting checklist to find potential solutions. 1. You may notice a temporary decrease in performance for In-Memory OLTP transactions when using In-Memory OLTP with Always On availability groups. This problem occurs when the availability group is configured to use the synchronous-commit...
Tag: availability group
Troubleshooting problems with AlwaysOn availability group in SQL Server 2016
Troubleshooting problems with AlwaysOn availability group in SQL Server 2016 If you have problems with AlwaysOn availability group in SQL Server 2016, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2016 service pack. Because many SQL Server 2016 AlwaysOn availability group’s bugs were fixed in SQL Server service packs, you should install the latest...