You can tell SQL Server the max amount of ram to use in the
confgiuration
tab. Right click over your server in EM, select configure. Go to the
COnfiguration tab, and find memory. Set it to 1/2 of what you want,
since
its in 2k block. For Example 40000 would be 80mb.
> Will this make Emerald & SQL faster?
Definately.
> What is the optimal amount of ram for SQL, Emerald with 500MB database?
I like to have the same amount of RAM as the size of the database. This
isn't always feasible, but the rule is the more ram you have, the faster
SQL Server will run.
> Would adding Seagate Backup Exec Enterprise to this server detract from
> it's performance?
Only when its doing a backup. BE typically uses over 50% of the CPU to
backup (unless you have a slow network). At night its typically not
an issue (but you better have a lot of ram).
-- Dale E. Reed Jr. (daler@iea-software.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com