How much memory should I assign?

Hi.
I wonder how much memory I should assign for MS SQL Server MEMORY
configuration variable.
If I have 100GB of data, what percentage of the data size is fit for memory?
20%? Or, 2~3% is adequate?
Any advice or hints would be appreciated.I would look at what percentage of system memory you want to allocate to =SQl server rather than comparing with size of DB. At 7 or 2k SQl server =will try and take almost all the available memory, and release back if =another process requires it. If you are running other apps on the same =system it can sometimes be beneficial to limit the upper end of this via =sp_configure.
Mike John,
"Kim Keuk Tae" <seiyanotenshi@.hotmail.com> wrote in message =news:eJYaPs7uDHA.640@.TK2MSFTNGP11.phx.gbl...
> Hi.
> > I wonder how much memory I should assign for MS SQL Server MEMORY
> configuration variable.
> > If I have 100GB of data, what percentage of the data size is fit for =memory?
> > 20%? Or, 2~3% is adequate?
> > Any advice or hints would be appreciated.
> > > >|||Thanks Mike.
I think I missed to explain my intend.
If I have to construct a sysem which has 100GB of data, and I don't have any
H/W, I suggest my customes some H/W specification, CPU, MEMORY, and DISKS...
This is a sizing, or capacity planning. If I calculated our application
would have 100GB of data, What memory should I
suggest to my customers? 20%, or 20GB of memory(that's too much, of
course)...
I wonder if there is a rule to choose which size of memory in proportion to
the data size.
I am very poor at sizing.
"Mike John" <Mike.John@.knowledgepool.spamtrap.com> wrote in message
news:OLKFje9uDHA.2456@.TK2MSFTNGP12.phx.gbl...
I would look at what percentage of system memory you want to allocate to SQl
server rather than comparing with size of DB. At 7 or 2k SQl server will try
and take almost all the available memory, and release back if another
process requires it. If you are running other apps on the same system it can
sometimes be beneficial to limit the upper end of this via sp_configure.
Mike John,
"Kim Keuk Tae" <seiyanotenshi@.hotmail.com> wrote in message
news:eJYaPs7uDHA.640@.TK2MSFTNGP11.phx.gbl...
> Hi.
> I wonder how much memory I should assign for MS SQL Server MEMORY
> configuration variable.
> If I have 100GB of data, what percentage of the data size is fit for
memory?
> 20%? Or, 2~3% is adequate?
> Any advice or hints would be appreciated.
>
>|||Kim,
You cannot really size memory based purely on data size - it may be huge =but hardly ever be used, an hence a very small machine would be fine. =You really need a lot more informatioj - number of users, number of =transactions per day etc. Even with that you will still be making some =educated guesses. If I remember right there was a document on =Microsoft's site regarding sizing - have you looked there?
Mike John
"Kim Keuk Tae" <seiyanotenshi@.hotmail.com> wrote in message =news:O0jB1$$uDHA.3436@.tk2msftngp13.phx.gbl...
> Thanks Mike.
> > I think I missed to explain my intend.
> > If I have to construct a sysem which has 100GB of data, and I don't =have any
> H/W, I suggest my customes some H/W specification, CPU, MEMORY, and =DISKS...
> > This is a sizing, or capacity planning. If I calculated our =application
> would have 100GB of data, What memory should I
> suggest to my customers? 20%, or 20GB of memory(that's too much, of
> course)...
> > I wonder if there is a rule to choose which size of memory in =proportion to
> the data size.
> > I am very poor at sizing.
> > > "Mike John" <Mike.John@.knowledgepool.spamtrap.com> wrote in message
> news:OLKFje9uDHA.2456@.TK2MSFTNGP12.phx.gbl...
> I would look at what percentage of system memory you want to allocate =to SQl
> server rather than comparing with size of DB. At 7 or 2k SQl server =will try
> and take almost all the available memory, and release back if another
> process requires it. If you are running other apps on the same system =it can
> sometimes be beneficial to limit the upper end of this via =sp_configure.
> > Mike John,
> > > "Kim Keuk Tae" <seiyanotenshi@.hotmail.com> wrote in message
> news:eJYaPs7uDHA.640@.TK2MSFTNGP11.phx.gbl...
> > Hi.
> >
> > I wonder how much memory I should assign for MS SQL Server MEMORY
> > configuration variable.
> >
> > If I have 100GB of data, what percentage of the data size is fit for
> memory?
> >
> > 20%? Or, 2~3% is adequate?
> >
> > Any advice or hints would be appreciated.
> >
> >
> >
> >
> >sql