Chris Skorlinski Microsoft SQL Server Escalation Services A customer called today about an unexplained slowness in SQL Server 2008 on Windows 2008 R2. All SQL data looked great, no blocking, no obvious IO bottlenecks, just overall slow performance...

Chris Skorlinski Microsoft SQL Server Escalation Services SQL Server Transaction LogReader Agent timeout executing sp_replcmds occurs most often when a large transactions has been written to the Published database transaction log, or there are a large...

Chris Skorlinski Microsoft SQL Server Escalation Services A customer recently noticed their Published database transaction log would continue to grow until they backed up the Distribution database.  DBCC OPENTRAN() Oldest distributed LSN    ...

Chris Skorlinski Microsoft SQL Server Escalation Services Latency problems are often caused when series of transactions are trying to move a large batch of commands from the Publisher to the Distributor to the Subscribers.   The queries below show...