A complete collection of Sql server Interview Questions,sql server performance,stored procedure, trigger,Sql query,security,ms sql server 2005,database backup,restore,free ebook,tutorials.
Apr 2, 2008
If you received a "Performance Critical" status in the SQL Server 2005 replication monitor, what does this mean?
The latency between transaction commits at the publisher and subscriber exceeds the warning level. 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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment