SQL Server Performance

"maxtransfersize" option in SQL Maintenance Plan

Discussion in 'General DBA Questions' started by fssherwani, May 3, 2007.

  1. fssherwani New Member

    Hi All -
    I had log backup jobs setup which started to fail intermittently for last couple of weeks. The SQL server complained of "insufficient system memory". The jobs were backed up as part of maintenance plan
    BUT use of "maxtransfersize" option in the backup script resolved the issue.
    Here is my question.... Is there a way to use "maxtransfersize" option in sql maintenance plan?

    Our environment is SQL 2000 (SP4) on Win 2003 SP2.

    Regards
    fssherwani, May 3, 2007
    #2

  2. MohammedU New Member

    I believe "insufficient system memory" is related to MemToLeave memory issue not the maxtransfersize option issue...

    MS advised to use maxtransfersize in the following article..

    You experience slow performance when you back up the database in SQL Server 2000
    http://support.microsoft.com/default.aspx?scid=kb;en-us;904804


    MohammedU.
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.
    MohammedU, May 3, 2007
    #2

  3. satya Moderator

    See this KBAhttp://support.microsoft.com/kb/873482 too on the hotfix if this particularly falls under that issue.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
    satya, May 4, 2007
    #2

Share This Page