Browse by Tags

SQL Server replication FAQ and important measures to consider when replication performance is sufferred

Published 7 February 8 9:41 AM | SSQA.net

Here we are going to highlight the majority of tasks you need to perform whenever user complains or you observe about SQL Server Replication performance is affected, adversly. For any performance tuning issues there will be other factors involved including...

Filed under: sql server, performance, replication, snapshot, best practices, agent, publisher, subscriptions, FAQ, schedule

FIX: A memory leak occurs when you call the Initialize method and the Terminate method of the SQLDistribution object in a loop in an application that you develop by using Microsoft ActiveX replication controls in SQL Server 2005

Published 24 September 7 1:2 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition, SQL Server 2005 Enterprise Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and All Modifications FIX...

Filed under: application, sql server, performance, replication, kba, 2005, memory leak, terminate, activex, initialize

What should I choose Load Balancing or Data Partitioning?

Published 12 September 7 5:42 AM | SSQA.net

One of our client had such requirement to cater a load balancing for their application and needed to upgrade to higher versions of SQL Server & Operating systems. The current setup at their end is a SQL Server 2000 Active/Passive Cluster and the transactions...

Filed under: sql server, performance, high availability, tuning, replication, active/passive, latency

FIX: The merge agent does not use a specified custom user update to handle conflicting UPDATE statements in SQL Server 2005

Published 11 September 7 4:37 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition Notification Contents: New and All Modifications FIX: The merge agent does not use a specified custom user update to handle conflicting...

Filed under: sql server, performance, update, replication, kba, statistics, conflict

Dust out few tasks to gain transactional replication performance in SQL 2005

Published 16 August 7 4:20 AM | SSQA.net

Coming to the basics of Transactional Replication, that starts with a simple snapshot of publication database data. Similar to the name the process is carried upon the fashion of transactions and subsequent data changes and schema modifications made at...

Filed under: sql server, performance, integration, tuning, ssas, ssms, replication, transactional, hardware

Adjust or tweak transactional replication within a high speed network environment

Published 9 July 7 4:29 AM | SSQA.net

Question: Is there anyway we can adjust the transactional replication speed according to network capacity, like speedy replication with big data packets for fast networks and replication with smaller data packets for slow networks? Answer: There isn't...

Filed under: sql server, performance, security, replication, agent, transactional