MS SQL Server - Re: Urgent: Problems of memory in cluster SQL 2000 + SP4 + Hot Fix

Author

Re: Urgent: Problems of memory in cluster SQL 2000 + SP4 + Hot Fix

Kamal Hassan

2006-12-01, 7:13 pm

Hi Prado,

I have a very similar configuration/situation and still can not see more
than 2.4 GB of memory allocated to SQL Server.

By the way, the sql service account has the "lock pages in memory".

Any help will be greatly appreciated.

Kamal.

"Prado" wrote:
[color=darkred]
> Hi again,
>
> finally, we have discovered the problem, the user account that starts SQL
> Services didn't have rights of "Lock Page in Memory" on the local policy. We
> changed this issue and after restarting the services SQL runs correctly. You
> can see more information about it in the next link
> http://msdn.microsoft.com/library/d...erver_1fnd.asp.
>
> Thanks you all,
>
> Prado
>
>
> "Tom Moreau" escribió:
>

Prado

2006-12-13, 7:12 pm

Hi,

I'm sorry but I don't remember all the tests that we made, but one of the
tests was change the position of the parameters /PAE and /3GB in the
boot.ini.

Another suggestions from a spanish discussion groups was to be sure that
the parameter "max memory size" in SQL have a fixed value because dinamically
doesn't work fine with SQL 2000 and all the memory must be take it when the
service start. Somebody spoke about a bug with the number of the value,
depends if the value was odd or pair. Here you have the link to this discuss
http://groups.google.es/group/micro...d95597
f1

Also, you can check the SQL Server counter for Target Memory Server, here
you can check the maximum memory recognized by SQL Server.

I hope that this can help you. Good luck.

Regards,

Prado

"Kamal Hassan" wrote:
[color=darkred]
> Hi Prado,
>
> I have a very similar configuration/situation and still can not see more
> than 2.4 GB of memory allocated to SQL Server.
>
> By the way, the sql service account has the "lock pages in memory".
>
> Any help will be greatly appreciated.
>
> Kamal.
>
>
>
> "Prado" wrote:
>

Sponsored Links