Post reply

Memory usage for Copy job in Log shipping configuration

  • April 2, 2010 at 5:16 pm

    #386635

    Hi,

    1. From where the log shipping copy job takes memory when it copies the log backup to Secondary from Primary?

    2. Since the copy job runs on secondary, Is the copy job uses memory from Primary server or Secondary server?

    3. If it uses memory from Primary server, is the memory used for copy job from buffer pool or the Memory allocated for OS (We have 16 GB RAM and set Max meory to 12GB & left 4GB to OS)?

    Thanks for your advice

  • April 2, 2010 at 9:04 pm

    #1145205

    The copy is a file system copy, not a SQL Server copy. The backup is taken, and should use minimal memory from SQL Server to get the pages from the file to disk. Then that backup file for the log is copied.

    The server performing the job is doing the work.

  • April 2, 2010 at 10:07 pm

    #1145215

    Thanks Steve,

    The copy is a file system copy, not a SQL Server copy. The backup is taken, and should use minimal memory from SQL Server to get the pages from the file to disk. Then that backup file for the log is copied.

    The server performing the job is doing the work.

    So in my case, the copy job is running from Secondary server and so the memory should be utilized from secondary to get this job done & has no effect on Primary Server's memory while Log shipping copy job running. Is that right?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply