news:1161900531.090882.263030@i42g2000cwa.googlegroups.com...
> 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
>

"shei***@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
>
>

:-)

"Roy Harvey" <roy_har***@snet.net> wrote in message
news:qu74k2l4vgv2vj2568ed1c2qq3h47gj4e7@4ax.com...
> On 27 Oct 2006 06:51:51 -0700, shei***@gmail.com wrote:
>
>>I figured out the reason i dont have the lock memory option is
>>because the version of SQL Server 2005 was installed on top of the
>>trial version, so it was not a clean install, and so possibly this is
>>the reason why all my options are not available to me.
>
> I do not believe there IS an option for fixed memory other than
> setting min and max to the same number.  At least I could not find any
> alternative in my copy of Management Studio (which was a clean
> install) or the documentation (which has been updated).
>
> Roy

news:1161957111.743790.5630@i42g2000cwa.googlegroups.com...
> Hi everyone,
> thanks for all your feedback. I set min=max and things already look
> better. I figured out the reason i dont have the lock memory option is
> because the version of SQL Server 2005 was installed on top of the
> trial version, so it was not a clean install, and so possibly this is
> the reason why all my options are not available to me. the 2005 trial
> version is 9...something and the SQL Server 2005 -licensed version is
> 8. something. I guess that's the difference.
>
> But already, with your suggestions i was able to reduce mem usage of
> the cpu so we're on the right track... i will probably do a clean
> install later on to get everythign right.
>
> Thanks again!
>
> sheinaz
>

> Something is not right here!
>
> "the SQL Server 2005 -licensed version is 8. something. "
>
> ALL versions of SQL Server 2005 are 9.something! As far as I am aware, there
> are NO versions of SQL 2005 that are version 8.something.
>
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
>
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
>
> You can't help someone get up a hill without getting a little closer to the
> top yourself.
> - H. Norman Schwarzkopf
>
>
> <shei***@gmail.com> wrote in message
> news:1161957111.743790.5630@i42g2000cwa.googlegroups.com...
> > Hi everyone,
> > thanks for all your feedback. I set min=max and things already look
> > better. I figured out the reason i dont have the lock memory option is
> > because the version of SQL Server 2005 was installed on top of the
> > trial version, so it was not a clean install, and so possibly this is
> > the reason why all my options are not available to me. the 2005 trial
> > version is 9...something and the SQL Server 2005 -licensed version is
> > 8. something. I guess that's the difference.
> >
> > But already, with your suggestions i was able to reduce mem usage of
> > the cpu so we're on the right track... i will probably do a clean
> > install later on to get everythign right.
> >
> > Thanks again!
> >
> > sheinaz
> >