sanket kokane (11/5/2012)
GilaMonster (11/5/2012)
sanket kokane (11/5/2012)
What I was mean to say is consider enabling /PAE as your last option.If running SQL on 32-bit OS with more than 4GB of memory, /PAE is a requirement if that memory it to be used by SQL.
Yes, and that to be done carefully with the help of your well experienced system administrator.
I had done this once with one of my server last year,when we try to restart server (yes you need to restart your server after enabling the /PAE or /3GB option) ,it was not getting up.
One of my system administrator friend saves my life by restarting it with safe mode and then removing /PAE option, server got up . 🙂
I hear you on that one and not like that option/switch very much.
There are some niche applications that i have programmed with that do not recommend using this option. For me its a gray area.