Wait Types in Log backups

• sejal p gudhka

  SSCrazy

  Points: 2102

  More actions

  December 14, 2009 at 8:35 pm

  #218733

  I have log backup running from last 1 hr for one of my production databases. I have checked except log backups there is nothing going on in that particular database.

  But I see 4 different kpid for one spid in sysprocess table for that log backup and one spid for log backup which is blocked by another spid for log backup. But there is only one log backup running.

  Below are the records from sysprocess tables.

  cmdSPIDKPIdBlockedwaittypelastwaittypewaitresourcecpuphysical_iomemusage

  BACKUP LOG 55326800x0087BACKUPIO 270304557542

  BACKUP LOG 55423600x0000MISCELLANEOUS 550000

  BACKUP LOG 55102000x0087BACKUPIO 993800

  BACKUP LOG 55296400x0087BACKUPIO 2606300

  BACKUP LOG 924560550x0004LCK_M_U DB: 8 [BULKOP_BACKUP_LOG] 4702

  I would like to know why there are two spid for one log backup and what does lastwaittype of LCK_M_U means and waitresouce of DB: 8 BULKOP_BACKUP_LOG]

  means?

  Any help will be appreciated.

• Chuck Lathrope

  Mr or Mrs. 500

  Points: 568

  More actions

  January 1, 2010 at 11:06 am

  #1098107

  I think your issue is very poor performance on the backup disk, or even your source disk. Test against a faster disk and see if speed increases.

  -Chuck