March 5, 2013 at 11:45 pm
Hi all,
I have mirroring setup in SQL 2008r2 server, Everything working fine.
But MirroredDB LDF file growth is very high. How restrict the LDF file growth.
With,
Bharath.
March 6, 2013 at 1:16 am
You don't. You should monitor your log on both principal and mirror, is agent that applies the log on the mirror working, and state of the mirroring session. Investigate the cause. What percentage of the log is active on the principal and mirror? Dbcc loginfo. Sys.databases.log_reuse_wait_desc. Is you network speed high enough to accomodate log generation rate?
March 6, 2013 at 3:26 am
Here are some links that might help:
http://msdn.microsoft.com/en-us/library/ms190030%28v=sql.105%29.aspx
SEND queue, REDO queue from performance counters:
http://www.mssqltips.com/sqlservertip/2228/sql-server-database-mirroring-performance-monitoring/[/url]
http://sqltwist.com/archives/179
March 6, 2013 at 11:35 am
One question - how often are you backing up your log?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply