My darabase server which is sql server 2008 Std. x64 edition throws a memory exception of System.OutOfMemoryException on following operations.
1) when I execute an index script which rebuild my volume tables indexes.
2) When I execute a Stotrd proc.
Once this exception occurs It contimuesly appears on other operations also. When I restart the whole server (OS) it get back to normal. But once this message appears all the activity is effected with this message.
My memory is 8gb and I am consumis 7 GB
I am using xeion quad core dual processor with Windows Server 20088 std x64
View Complete Post