Some tips for using Transactional Replication in SQL Server 2016 (Part 2) Set the “Maximize Throughput for Network Applications” option. This can increase SQL Server performance, because Windows will allocate more RAM to SQL Server than to its file cache. Consider locating both the publisher and the distributor on the same physical server. You can place the publisher and the […]
Tag: Log reader agent
Some tips for using Transactional Replication in SQL Server 2016 (Part 1)
Some tips for using Transactional Replication in SQL Server 2016 (Part 1) Try to keep transactions as short as possible. Because SQL Server send changes from the Publisher to Subscriber as INSERT, UPDATE, and DELETE statements you should keep transactions as short as possible to help the Distribution Agent to transfer transactions through the network. By the way, keeping transactions […]
Troubleshooting Upgrading to SQL Server 2014
Troubleshooting Upgrading to SQL Server 2014 Should you have problems with upgrading to SQL Server 2014, review this troubleshooting checklist to find potential solutions. 1. Check the hardware requirements. To upgrade to SQL Server 2014, you should have the following hardware: – Intel or compatible platform with processor speed: 1.0 GHz minimum for a 32-bit x86 implementation and a 1.4 […]