none
background processes appear after backup database RRS feed

  • Question

  • Dear all

    I have a sql server 2008 running 30 databases. and I have been using database mirroring with auto failover. it works fine.

    things got weird after I use maintenance plan to do a full backup of all the databases. the backup succeeded but after the backup finished I found out there are at least 30 wait tasks in SQL SERVER (in activity monitor). then I use 'sp_who2' check out the current processes. I was surprised that every database I just backed up has one or two process like this:

    SPID  Status                         Login                                  HostName BlkBy DBName                 Command        CPUTime   DiskIO
    60    BACKGROUND                     sa                                       .        .        NULL                    DB MIRROR        483           288   
    61    BACKGROUND                     sa                                       .        .        People                  DB MIRROR        16            534   

    because I have 30 databases in the sql server, totally I got 40 BACKGROUND processes marked as 'DB MIRROR'. although they are not detrimental to performance but I don't think it is reasonable. Do I need to manually clear up the processes, if yes, how?

    Thanks for your attention. Your words will be appreciated.

    Tuesday, December 29, 2009 12:40 PM

Answers

  • Hi,

    These processing are created for the database mirroring sessions. Each database mirroring requires a mirroring session to run the tasks, such as sending the log records. For more information about Database Mirroring Sessions, please see http://technet.microsoft.com/en-us/library/ms189901.aspx.

    If there are any more questions, please let me know.
    Thanks.


    ***Xiao Min Tan***Microsoft Online Community***
    • Marked as answer by cn2500 Monday, January 4, 2010 12:47 PM
    Thursday, December 31, 2009 7:58 AM
    Moderator

All replies

  • Hi,

    These processing are created for the database mirroring sessions. Each database mirroring requires a mirroring session to run the tasks, such as sending the log records. For more information about Database Mirroring Sessions, please see http://technet.microsoft.com/en-us/library/ms189901.aspx.

    If there are any more questions, please let me know.
    Thanks.


    ***Xiao Min Tan***Microsoft Online Community***
    • Marked as answer by cn2500 Monday, January 4, 2010 12:47 PM
    Thursday, December 31, 2009 7:58 AM
    Moderator
  • Thanks Xiao Min Tan

    I think I got what you said. just worried about the amount of sessions for mirroring when I have 30 databases mirrorred.

    cn2500
    Monday, January 4, 2010 10:00 AM
  • hi Benson, as mentioned in above link by Xiao-Min, these are database mirroring processes - they're not related to backup, they're terminated only when database mirroring is stopped for those databases.
    Sunday, June 27, 2010 8:47 AM