How to Use Fixed memory Size in SQL Server 2005

Hi all,
I will label myself a total newbie and i desperately need direction.
Here it goes...I installed SQL Server 2005. I am trying to follow
direction and set the memory to use fixed memory size. I can not find
this option anywhere. I have the memory tab on which i have Server
memory options. here i have "Use AWE to allocate memory" , mimunim
server memory, maximum server memory and other memory options section.
Normally as per the what i understood, i should also have the option
to use fixed size on this tab...but i dont!!!
I thought this might have been because maybe, i dont have advanced
options, so i ran a script from the internet to set my show options to
'1'. This also did not change anything.
So can anyone please help me do what i need to so that i can have the
"Use fixed memory size" option!
Thanks in advance.
SheinazSet the min and max server memory to whatever you set as the fixed
memory size. This is documented in the Books on Line.
http://msdn2.microsoft.com/en-us/library/ms191144.aspx
Roy Harvey
Beacon Falls, CT
On 26 Oct 2006 15:11:35 -0700, sheinaz@.gmail.com wrote:
>Hi all,
>I will label myself a total newbie and i desperately need direction.
>Here it goes...I installed SQL Server 2005. I am trying to follow
>direction and set the memory to use fixed memory size. I can not find
>this option anywhere. I have the memory tab on which i have Server
>memory options. here i have "Use AWE to allocate memory" , mimunim
>server memory, maximum server memory and other memory options section.
> Normally as per the what i understood, i should also have the option
>to use fixed size on this tab...but i dont!!!
>I thought this might have been because maybe, i dont have advanced
>options, so i ran a script from the internet to set my show options to
>'1'. This also did not change anything.
>So can anyone please help me do what i need to so that i can have the
>"Use fixed memory size" option!
>Thanks in advance.
>Sheinaz