I ran into a problem with a Transactional Publication today. I’d moved the database from old hardware, to newer hardware, and in the process, restored the SQL 2000 database onto SQL 2008 (running in SQL 2000 compatibility mode) I’d re-created the publication, and initialized it. After about half an hour, I checked the Replication Monitor, and noticed that it said: Performance : Critical...
Fixing – Log Reader Performance : Critical (Seen in SQL Replication Monitor)
F