Some tips for using Very Large Databases in SQL Server 2014 Consider using table and index partitioning. In SQL Server 2014 tables and indexes can be divided into partitions based on value ranges. By using partitioning, you can transfer blocks of data within the database schema more efficiently because maintenance operations can be performed against single partitions instead of an...
Tag: snapshot
SQL Server 2014 Merge Replication Optimization Tips (Part 2)
SQL Server 2014 Merge Replication Optimization Tips (Part 2) Do not forgive to script your replication configuration. Because scripting the replication configuration is a key part of any disaster recovery plan for a replication topology, you should script your replication configuration from the replication wizards or from the Replication folder in Microsoft SQL Server Management Studio. If you do not...
SQL Server 2014 Merge Replication Optimization Tips (Part 1)
SQL Server 2014 Merge Replication Optimization Tips (Part 1) Create an index on each of the columns that is used in the filter’s WHERE clause. If you do not use indexes on columns used in filters the SQL Server must perform a table scan, which can results in performance degradation. Set the "Maximize Throughput for Network Applications" option. This can...
SQL Server 2014 Snapshot Replication Optimization Tips
SQL Server 2014 Snapshot Replication Optimization Tips Do not configure the Distribution Agent to run continuously. Try to schedule the Distribution Agent to run at regular intervals instead of running continuously. By using it, you can decrease the total SQL Server overhead. Consider placing snapshot folder on a disk that is not used to store database or log files. Placing...
Troubleshooting SQL Server 2012 Merge Replication
Troubleshooting SQL Server 2012 Merge Replication If you have problems with SQL Server 2012 merge replication, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2012 service pack. Because some SQL Server 2012 merge replication bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At the time...
Tips for using SQL Server 2012 Merge Replication
Tips for using SQL Server 2012 Merge Replication SQL Server 2012 introduces AlwaysOn Availability Groups. This is a high-availability and disaster-recovery solution that provides an enterprise-level alternative to database mirroring. AlwaysOn Availability Groups maximizes the availability of a set of user databases for an enterprise and supports a failover environment for a discrete set of user databases, known as availability...
Tips for using SQL Server 2012 Transactional Replication
Tips for using SQL Server 2012 Transactional Replication SQL Server 2012 introduces AlwaysOn Availability Groups. This is a high-availability and disaster-recovery solution that provides an enterprise-level alternative to database mirroring. AlwaysOn Availability Groups maximizes the availability of a set of user databases for an enterprise and supports a failover environment for a discrete set of user databases, known as availability...
Troubleshooting problems with SQL Server 2008 R2 Merge Replication
Troubleshooting problems with SQL Server 2008 R2 Merge Replication If you have problems with SQL Server 2008 R2 merge replication, review this troubleshooting checklist to find potential solutions. 1. Check that you use the latest SQL Server 2008 R2 service pack. Because many SQL Server 2008 R2 merge replication bugs were fixed in SQL Server service packs, you should install...
Troubleshooting problems with SQL Server 2008 R2 Transactional Replication
Troubleshooting problems with SQL Server 2008 R2 Transactional Replication If you have problems with SQL Server 2008 R2 transactional replication, review this troubleshooting checklist to find potential solutions. 1. Check that you use the latest SQL Server 2008 R2 service pack. Because many SQL Server 2008 R2 transactional replication bugs were fixed in SQL Server service packs, you should install...
Troubleshooting problems with SQL Server 2008 R2 Snapshot Replication
Troubleshooting problems with SQL Server 2008 R2 Snapshot Replication If you have problems with SQL Server 2008 R2 snapshot replication, review this troubleshooting checklist to find potential solutions. 1. Check that you use the latest SQL Server 2008 R2 service pack. Because some SQL Server 2008 R2 snapshot replication bugs were fixed in SQL Server service packs, you should install...