Post reply

OLE DB provider ''SQLOLEDB'' reported an error. The provider ran out of memory

  • August 10, 2005 at 6:22 am

    #90540

    Is there anyway to expand or resize the MemToleave memory area without restarting the sql server when the following error appears:

    OLE DB provider 'SQLOLEDB' reported an error. The provider ran out of memory.

    It happened on a QA server when running a query on a linked server and the issue only disappeared after rebooting.

    I have read it is possible to resize this area of memory using SQL startup parameter -g, but I need to find a way to get rid of this problem in seconds if it happens in Production.

    Thanks,

    Jose

  • August 10, 2005 at 7:23 am

    #581003

    No, there is no way to change the size of the MemToLeave area while running. As far as I know the -g startup parameter is the only way to configure it at all.

    --
    Chris Hedgate http://www.hedgate.net/
    Contributor to the Best of SQL Server Central volumes
    Articles: http://www.sqlservercentral.com/columnists/chedgate/

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

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