RAM

[Toni Eibner]

If I were basically given free reign to order as much memory as I need
for my SQL Server 6.5, how do I know how much to give it? Currently
we have 256 MEG running fine, but we plan on increasing our user
connections drastically within the next 2-3 months (from 50 to 250 users).
I also would like to plan for future growth as much as possible.

Is anyone able to give me any suggestions?
Thanks!
Toni E.

[Winston Castro]

SQL Server manages very well the memory assigned to it.
Don`t exist any rule but some books recomend the follow relation between RAM and memory for SQL :

Physical RAM
on a computer
dedicated to
SQL Server Memory dedicated to sp_configure `memory`
(MB) {x} SQL Server (MB) {y} setting (in 2-KB pages)
---------------------------------------------------------------------------

16 5.468 2,800 (minimum, not recommended)
24 8 4,096 (SQL Server 6.5 default)
32 16 8,192
48 28 14,336
64 40 20,480
128 100 51,200
256 216 110,592
512 464 237,568

More information about this topic you can find in Microsoft Technet PSS ID Number: Q168697


Regards
Winston Castro



On 9/21/98 10:24:31 AM, Toni Eibner wrote:
> If I were basically given free reign to order as much memory as I need
for
> my SQL Server 6.5, how do I know how much to give it? Currently
we have
> 256 MEG running fine, but we plan on increasing our user
connections
> drastically within the next 2-3 months (from 50 to 250 users).
I also
> would like to plan for future growth as much as possible.

Is anyone able
> to give me any suggestions?
Thanks!
Toni E.