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 backup is creating blocking in prod server Expand / Collapse
Author
Message
Posted Thursday, October 31, 2013 6:27 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 5:21 AM
Points: 123, Visits: 446

hi all,

guys need your help and suggestion

T- log backup is creating blocking in prod server.what to do plz suggest.
Post #1510145
Posted Thursday, October 31, 2013 7:08 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 7:12 AM
Points: 1,539, Visits: 8,132
Ivan Mohapatra (10/31/2013)

hi all,

guys need your help and suggestion

T- log backup is creating blocking in prod server.what to do plz suggest.


http://www.sqlskills.com/blogs/paul/a-sql-server-dba-myth-a-day-3030-backup-myths/

Bearing in mind point 30-01 in that article, what makes you believe the backup is causing blocking?


BrainDonor
Linkedin
Blog Site
Post #1510161
Posted Thursday, October 31, 2013 7:35 AM


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 @ 2:44 PM
Points: 42,443, Visits: 35,498
How have you identified that the log backup is the blocker? What is the lock type that it is holding? What is trying to get that lock?


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 #1510171
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse