Forum Discussion

Anandha_Kannan_'s avatar
Anandha_Kannan_
Level 4
11 years ago

SQL backup utilizing more memory

Hi All,

SQL backup parent job completed successfully but child job not initiated.. we found error like memory ultization high in server, then we modified the script by

reducing MAXTRANSFERSIZE 6 to 1 then backup successfully. Anyone one tell me what is difference in keeping MAXTRANSFERSIZE 6 or 1 2 3..etc..

which is the best practice either MAXTRANSFERSIZE 6 or MAXTRANSFERSIZE 1....?? by keeping MAXTRANSFERSIZE 1 will the backup take long time to complete???

7.5
Backup and Recovery
NetBackup
Windows Server (2003-2008)
  • RamNagalla's avatar
    RamNagalla
    11 years ago

    MAXTRANSFERSIZE
    MAXTRANSFERSIZE is the buffer size used by SQL Server for reading and writing backup images. This parameter is set either in the NetBackup SQL GUI (Under Options | Set NetBackup Client Options) or in the batch file (see "Overview of Batch Files" on page 126 of the Veritas NetBackup (tm) for Microsoft SQL Server System Administrator's Guide for Windows). It can be set from 64 KB to 4 MB in size, and the default is 64 KB.  

    Think of MAXTRANSFERSIZE as a "holding area" where data is temporarily placed before sending it to the media server. The size of MAXTRANSFERSIZE will be the size of a buffer area where data is held. When the buffer is full, data is then transferred to the media server.

    so MAXTRANSFERSIZE 6 is supporeed.. but it seems you are not having the enough memory to support that. 

    so you can try to recude the vulue to decrees the load on Memory.. 

    rememeber hight value always gives the better perfromace as long as it is supported by the hardware(memory) the value range is 1-6

1 Reply

Sort By
  • RamNagalla's avatar
    RamNagalla
    Moderator
    11 years ago

    MAXTRANSFERSIZE
    MAXTRANSFERSIZE is the buffer size used by SQL Server for reading and writing backup images. This parameter is set either in the NetBackup SQL GUI (Under Options | Set NetBackup Client Options) or in the batch file (see "Overview of Batch Files" on page 126 of the Veritas NetBackup (tm) for Microsoft SQL Server System Administrator's Guide for Windows). It can be set from 64 KB to 4 MB in size, and the default is 64 KB.  

    Think of MAXTRANSFERSIZE as a "holding area" where data is temporarily placed before sending it to the media server. The size of MAXTRANSFERSIZE will be the size of a buffer area where data is held. When the buffer is full, data is then transferred to the media server.

    so MAXTRANSFERSIZE 6 is supporeed.. but it seems you are not having the enough memory to support that. 

    so you can try to recude the vulue to decrees the load on Memory.. 

    rememeber hight value always gives the better perfromace as long as it is supported by the hardware(memory) the value range is 1-6