My environment is SQL 2008 Standard x86 with SP2 running on Server 2008 Standard, with 4Gb ram and AWE enabled. I also have -g1024 set as a startup parameter.
I am getting the following error in the SQL error log: Failed Virtual Allocate Bytes: FAIL_VIRTUAL_RESERVE 327680
Then later: Error: 701, Severity: 17, State: 123. There is insufficient system memory in resource pool 'internal' to run this query.
Which are repeated until the server eventually stops processing queries.
I strongly suspect that the issue is to do with linked servers as I am linking to a Sybase ASE 15 server using the "Microsoft OLEDB Provider for ODBC Drivers" provider. How can I prove whether or not this is the case and/or troubleshoot this issue?
Edit: Here is the current output for MEMORYCLERK_SQLGENERAL under error conditions..
VM Reserved 0 VM Committed 0 AWE Allocated 0 SM Reserved 0 SM Committed 0 SinglePage Allocator 2168 MultiPage Allocator 2056