Hi,
We are running v814 with 8 GB of RAM and 3.5 GB allocated to shared memory.
It's never been a problem for us before. We ran into a situation
yesterday where we received the message above. At that time our total
available memory took a dive to 4GB and cached memory stayed around 4 GB.
Soon after that some process ended and everything returned to normal. It
alsted around 10 minutes. Too bad I didn't see the query or process at the
time it was running.
~DjK
_________________________________________________________________
Try the next generation of search with Windows Live Search today!
http://imagine-windowslive.com/minisites/searchlaunch/?locale=en-us&source=hmtagline
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
