Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Mirrored DB log file growth is High Expand / Collapse
Author
Message
Posted Tuesday, March 5, 2013 11:45 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, September 25, 2013 1:15 PM
Points: 3, Visits: 32
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.
Post #1427185
Posted Wednesday, March 6, 2013 1:16 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 3:05 PM
Points: 369, Visits: 1,209
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?

_____________________________________________________
Microsoft Certified Master: SQL Server 2008
XDetails Addin - for SQL Developers
blog.sqlxdetails.com - Transaction log myths
Post #1427225
Posted Wednesday, March 6, 2013 3:26 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 3:05 PM
Points: 369, Visits: 1,209
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/
http://sqltwist.com/archives/179


_____________________________________________________
Microsoft Certified Master: SQL Server 2008
XDetails Addin - for SQL Developers
blog.sqlxdetails.com - Transaction log myths
Post #1427265
Posted Wednesday, March 6, 2013 11:35 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, May 15, 2014 8:21 AM
Points: 59, Visits: 205
One question - how often are you backing up your log?
Post #1427552
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse