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

T-Log Growth (sp_repldone not running) Expand / Collapse
Author
Message
Posted Tuesday, June 11, 2013 1:55 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, November 12, 2014 2:56 PM
Points: 20, Visits: 192
Recently I encountered an issue where the transaction logs in my production databases have been growing up to 1 TB and I have not been able to shrink them. After some initial investigation I found that the log_reuse_wait_desc in sys.databases is REPLICATION for all databases in question. This made sense as these databases are set up for transactional replication. I then executed sp_repldone as many online resources suggest and that cleaned up the transaction log. However, the issue keeps resurfacing so running sp_repldone once a day is far from a permanent solution.
It is my understanding that the log reader agent is responsible for running sp_repldone on a regular basis. However, I do not see this happening when I run a profiler trace on the server. Does anyone know how the log reader agent calls sp_repldone or why it isn't running? Any insight would be appreciated.

Server - SQL Server 2008 R2 SP1 Enterprise Edition
Post #1462365
Posted Tuesday, June 11, 2013 4:36 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 7:43 AM
Points: 40,438, Visits: 36,894
Is the log reader agent running? Are the replication publications working?


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1462417
Posted Wednesday, June 12, 2013 8:53 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, November 12, 2014 2:56 PM
Points: 20, Visits: 192
Yeah, the log reader agent is running. I did try restarting it but that didn't help. Everything is syncing like it should keeping tables on the subscriber up to date.
Post #1462678
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse