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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy