Just wanted to give a heads up about a SQL Replication Distribution Agent Latency problem we observed today. The Distribution Agent to 1 subscriber was only delivering about 500 cmds/sec while other subscribers were getting 4000 cmds/sec. We noticed the Distribution Agent was running under a different PacketSize, made that change, no noticeable improvement. While
Read More »
We had this question about SQL 2008 virtual cluster. Question: Is it possible to add node in existing SQL Server 2008 or 2008 R2 Failover cluster instance without downtime (without stopping SQL Server or MSCS services)? Answer: Absolutely! SQL Server 2008 was designed with rolling installation and upgrades in mind. To confirm: I built a
Read More »
Normally, the Snapshot create publication script only needs to lock the table long enough to generate a Create Table script for the Distribution Agent to apply to the Subscriber. However, the create Publication was being blocked on the Publisher. We discovered a database trigger used to AUDIT all schema modification on the Publisher was root
Read More »
Sateesh Yele Microsoft SQL Server Support Issue: Restore of a replicated database fails with the following message. Msg 3724, Level 16, State 2, Procedure sp_MSdrop_peertopeer_tables, Line 32 Cannot drop the table 'dbo.MSpeer_lsns' because it is being used for replication. Consider the following scenario. Transactional Replication is set on the database from a script and sp_addarticle
Read More »
How to Archive your SQL Errorlogs into a Table Chris Skorlinski Microsoft SQL Server Escalation Services Have you noticed your SQL Server errorlogs taking up a lot of disk space? Ever wonder what was logged a few weeks ago, but the logs have already rolled over? Why not create a SQL Agent job and archive
Read More »