More DBA job interview questions and answers at
http://dba.fyicenter.com/Interview-Questions/
(Continued from previous question...)
If you received a "Performance Critical" status in the SQL Server 2005 replication monitor, what does this mean?
Answer
The latency between transaction commits at the publisher and subscriber exceeds the warning level.
Explanation
This status can actually mean two different things. Either the latency between the commit of a transaction at the publisher and the same commit at the subscriber is exceeding some level in a transactional level or not enough rows are being processed in a merge replication scenario.
(Continued on next question...)
