jitendra.padhiyar (12/24/2012)
I think AWE will help me, but i am not sure whether it will be in effect without restarting sql server. Please guide me how can I release memory without restarting sql server.
ONLy if you are using 32 bit machine and also it requires sql server restart. see the link http://msdn.microsoft.com/en-us/library/ms190673(v=sql.105).aspx
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)