Viewing 6 posts - 1 through 6 (of 6 total)
Lock Pages was enabled by default for the account the SQL is running on 🙁
I've also found the Dynamic Cache Service but nothing changed, SQL server still uses 20-200Mb memory...
March 28, 2011 at 12:49 pm
As far as I know that is not available in Standard edition
March 28, 2011 at 8:17 am
So there is no solution for this kind of problem, the system useage is minimal, page file is hardly used but the OS keep paging out memory... Aren't there...
March 24, 2011 at 9:00 am
Yes, there are we can not afford to use a server dedicated for SQL only but as I mentioned there are more than 4G free memory and the sql server...
March 24, 2011 at 8:52 am
I did, but we are using 32bit OS not 64bit, I read almost everything I found regarding this issue, but nothing helped, there are some other applications but there are...
March 24, 2011 at 8:14 am
There are no limit on sql server memory usage, it's running with default settings:
Minimum was 0Mb increased it to 512Mb without any success
Maximum is: 2147483647Mb
March 24, 2011 at 7:18 am
Viewing 6 posts - 1 through 6 (of 6 total)