Memory Leaks in SQL Server 2005

  • Hi ,

    I am facing the below issue when i am loading the data in the tables.

    FactDailyCauDatSc [35661]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native Client” Hresult: 0x80004005 Description: "Cannot get the column information from OLE DB provider "STREAM" for linked server "(null)".". An OLE DB record is available. Source: "Microsoft SQL Native Client” Hresult: 0x80004005 Description: "The OLE DB provider "STREAM" for linked server "(null)" reported an error. The provider ran out of memory.".

    i tried the to open the instance properties through management studio its saying the below error

    cannot show the request dialog.

    could not load the DLL xplog70.dll or one of the DLL's it references.Reason: 8(not enough storage is available to process this command.). (Microsoft sql server, Error: 17750).

  • Restarting the SQL Services will resolve this issue temporarily. However in the long run you may want to check the memory requirements or consider increasing the mem_to_reserve value.

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

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

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