reserver memory should be fixed or dynamic?

Hello -
I want to use the reserve physical memory option to get test if this will
give me any added (faster) performance on a database.
If I use 'dynamic' with 'reserve physical memory', is the maximum amount of
memory allocated or minimum?
Should I use fixed with 'reserve' to set aside as much memory instead?
I guess I'm not sure what 'dynamic' with 'reserve physical' means. Any
clues?
Thanks,
bruceHave a look at BOL for "set working set size". You want to use a fixed
amount
"Do not set set working set size if you are allowing SQL Server to use
memory dynamically. Before setting set working set size to 1, set both min
server memory and max server memory to the same value, the amount of memory
you want SQL Server to use"
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"NO.bruceradtke.SPAM@.NO.earthlink.net.SPAM"
<bruceradtke@.NO.earthlink.net.SPAM> wrote in message
news:v3%Hb.14005$IM3.12306@.newsread3.news.atl.earthlink.net...
> Hello -
> I want to use the reserve physical memory option to get test if this will
> give me any added (faster) performance on a database.
> If I use 'dynamic' with 'reserve physical memory', is the maximum amount
of
> memory allocated or minimum?
> Should I use fixed with 'reserve' to set aside as much memory instead?
> I guess I'm not sure what 'dynamic' with 'reserve physical' means. Any
> clues?
>
> Thanks,
> bruce
>