We have SQL Server 2012 database which pulls data using a linked server to a Netezza database. We have had a memory issue reported in an overnight batch.
OLE DB provider "MSDASQL" for linked server [name] returned message "ERROR: reserve exceeded : Out of memory "
Can any one give me a clue on how to diagnose this error, as we have had it a couple of times recently. As far as we know no infrastructure or configuration has changed on either side of the linked server.
We are not sure if this means the SQL Server box with the provider or the Netezza box.
Google has failed me on this.