Viewing 9 posts - 1 through 9 (of 9 total)
Doing the configuration with sp_configure or the GUI do not make a difference.
Behaviour is still the same as described in my first posting...
--> After rebooting (OS) / restarting (SQLSErver) drops...
November 2, 2010 at 12:06 pm
My problem is not that it is not working, I can use > 7GB (from the 8GB in the box).
But after rebooting or restarting SQL Server I suddenly can only...
October 25, 2010 at 12:42 am
nevhirion (10/21/2010)
How much RAM is in the server? Have you added the /3GB switch in the boot.ini file?
There is 8GB in the server, it's 64-bit so /3GB is not applicable...
October 22, 2010 at 3:54 am
We are upgrading from SQL2K and our customer is using some functionality not available in de x64 version: JET-drivers, DTS, and some COM-objects to interface with other applications, ...
October 19, 2010 at 1:14 pm
SQL Server is running on 32-bit subsystem (WOW64). WOW64 is a feature of 64-bit editions of Microsoft Windows that allows 32-bit applications to execute natively in 32-bit mode. Applications function...
October 19, 2010 at 11:31 am
It is not needed for SQL 64-bit, but is needed (I think) for SQL 32-bit on a 64-bit OS, since SQL 32-bit runs under WOW64....
October 19, 2010 at 10:43 am
george sibbald (10/19/2010)
the max value is dynamic for SQL2005 and above. Is something else grabbing the memory? does it increase to 7GB of its own accord over time?
I think...
October 19, 2010 at 10:30 am
george sibbald (10/19/2010)
have you given the service account the lock pages in memory right?
Yes, I think otherwise the memory will be limited to 2 GB
October 19, 2010 at 9:59 am
Viewing 9 posts - 1 through 9 (of 9 total)