Re: OPtimize SQL & Emerald

Dale E. Reed Jr. ( (no email) )
Thu, 09 Jul 1998 11:00:41 -0700

John Lange wrote:
>
> We are setting up a new SQL server and have a few questions.
>
> New System:
> PII 233 - 128MB - 9GB UW SCSI - 3C905B-TX & 10/100MB Hub, etc.
>
> I notice that SQL on our current server only uses about 8 MB ram.
>
> How do I tell SQL to use all the ram in the system - ie: 96 to 128 MB ram?

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