April 5, 2004 at 9:28 am
Hello,
I was hoping someone has had some experience with this error:
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'SQLOLEDB' reported an error. The provider ran out of memory.
I get this error when running a query from one SQL server (A) using a linked server to another SQL server (B). This particular query has run fine for a long time, and all of a sudden is now returning the above error.
Facts:
Things I have tried:
I have seen some documentation stating that one thing to try is setting the -g256 parameter at startup to increase the memory allocations outside of the sql server memory pool. I understand the default is 128 MB for these processes. This is a production environment so I cannot readily change startup parameters and restart the SQL service. Does anyone have any ideas of what may be causing this?
Thanks,
ajroney
April 5, 2004 at 10:20 am
We've had similar issues with using IBM's Client Access drivers for the AS/400. The only resolution was to reboot the server, both from IBM and MS. The memory size of 128 si shared by ALL data access drivers, and can be easily eaten by a linked server. I'd schedule a restart and change the parameter and see if this helps.
April 6, 2004 at 6:24 am
if you are using MDAC 2.7 then install MDAC 2.7 RTM refresh SP1 on both servers and restart them.
I hope this help u.
Alamir Mohamed
Alamir_mohamed@yahoo.com
April 7, 2004 at 8:01 am
thank you all for your responses. Setting the -g startup parameter and failing the cluster over seems to have resolved the issue.
ajroney
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply