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: Monday, October 20, 2014 8:01 AM
Points: 123, Visits: 462

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


UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Today @ 3:44 AM
Points: 1,483, Visits: 8,544
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 @ 5:00 AM
Points: 40,612, Visits: 37,076
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