I wouldn't go just by task manager. If your running multiple apps on the
same box they can adversely affect the performance of sql server. Do you
have an upper memory limit set for sql server currently? How much ram do
you have in total?
Andrew J. Kelly
SQL Server MVP
"hutch" <hutchnospam.com> wrote in message
news:0ba201c347c4$43425a90$a501280aphx.gbl...> There are several things running. When I check task
> manager only 1/3 memeory is being used.
> After checking msdn and reading about the error it looks
> like there is something not cleaning up after itself
>> you running> >-----Original Message-----
> >Sounds like your pressed for memory on that server. Are> operations> >anything else other than sql server on the machine?
> >Andrew J. Kelly
> >SQL Server MVP
> >"Hutch" <chutchinsonnospam.com> wrote in message
> >news:00ce01c347bd$347045b0$a101280aphx.gbl...> >> We are running into an error today that I have not seen
> >> before
> >> "Could not perform the requested operation because the
> >> minimum query memory is not available. Decrease the
> >> configured value for the 'min memory per query' server
> >> configuration option."
> >> After I receive the error I can not perform any> reboot> >> in EM or query yzer. The solution I have found this
> >> morning is to stop and restart the services, a full> min> >> has to be scheduled and can not be done till late today.
> >> The error appears as though it is not able to read the> >> >> query value. If anyone has found a solution a tip we
> >> greatly help
> >> Thanks
> >> Hutch