Please can Anyone assist with the following problem;
We are running a query that uses the physical memory allocated to the SQL instance and on using all available physical memory the query fall over with the following error
Msg 701, Level 17, State 123, Line 1
There is insufficient system memory to run this query.
SQL 2005 x64 SP2 Enterprise
2 Node Cluster Environment 1 SQL Instance and Analysis services but the analysis services Service currently disabled.
Physical memory 8Gb with 6Gb allocated to the SQL instance
Lock pages in memory Set
AWE NOT enabled
On viewing Page file activity with performance monitor none of the page file is being used and hence query dies when all of allocated physical memory used up.
This is also backed up by the fact that when we reduce the allocated physical memory to 3Gb the query fallsover all the sooner.
No other Users or processes are running on this SQL instance at the same time.
Any help appreciated as this server is still in a pre-production phase and I am unable to put into full production until this issue is resolved.