Any Cox | Microsoft Premier Field Engineer We recently encounter the a problem where Replication Distribution Agent failed with error below while trying to replicate the “execution” of a stored procedure. Msg 0, Level 20, State 0, Line 0 A severe error occurred on the current command. The results, if any, should be discarded. Executing
Read More »
Problem Customer observes high latency in SQL Server 2005 Merge replication. In sysprocesses you see that Merge agents are being blocked by another Merge agent & the blocker Merge agent SPID is sleeping with “AWAITING COMMAND”. Root Cause If you take output of “select open_transaction_count from sys.dm_exec_requests where session_id = <blocker SPID>” & find that
Read More »
Anurag Sharma | Microsoft SQL Server Escalation Services Background In many cases customer often have large databases published and creating a snapshot of such large database is always a pain. And, even when published databases are of manageable size, a slow or unreliable network link can further complicate the issue. From SQL Server 2005 onwards
Read More »
Here are some thoughts on using Transactional (or Peer-2-Peer) Replication Subscriber to support both REPORTING and DISATER RECOVERY. Normally “subscriber” target server would have different set of non-clustered indexes to support REPORTING capabilities. The Publisher’s indexes, check-constraints, triggers, etc, would only be added when Publisher goes down and the Subscriber comes online as the new
Read More »
During performance troubleshooting we often need to look at difference between two different databases. We’ve used SQL Server Tablediff Utility for the data changes but doesn’t help with schema changes. For schema differences you can use Database Compare tool available for Visual Studio. How to: Compare the Data of Two Databases http://msdn.microsoft.com/en-us/library/aa833428.aspx Schema Comparison with
Read More »