processor and ram

hi guys,
i need some advice.
we have here:
win2003r2sp2-32bit 4gb ram dual quad-core xeon (8 cpushown and
managable)
2 instances sql2000sp4, both with default settings, both equally
used ...
what would now be the recomended settings to provide the best
solution.
how should ram and procs be splitted to maximize performance?
ram for system: 1gb
ram for sql#1: 1.5gb
ram for sql#2: 1,5gb
proc 0+1 : system
proc 2-4: sql#1
proc 5-7: sql#2
or what do you guys think?
thanx in advance
juergen ladrick
I would definately let SQL and the OS manage processor resources. There is
also a good case to leave both instances's memory dynamic. Either way, we do
not have enough info to say how it should be split.
Jason Massie
Web: http://statisticsio.com
RSS: http://feeds.feedburner.com/statisticsio
"Juergen Ladrick" <juerji@.arcor.de> wrote in message
news:1ef6f2dd-60c8-4fde-9305-d665945d8eba@.s13g2000prd.googlegroups.com...
hi guys,
i need some advice.
we have here:
win2003r2sp2-32bit 4gb ram dual quad-core xeon (8 cpushown and
managable)
2 instances sql2000sp4, both with default settings, both equally
used ...
what would now be the recomended settings to provide the best
solution.
how should ram and procs be splitted to maximize performance?
ram for system: 1gb
ram for sql#1: 1.5gb
ram for sql#2: 1,5gb
proc 0+1 : system
proc 2-4: sql#1
proc 5-7: sql#2
or what do you guys think?
thanx in advance
juergen ladrick
|||You need to provide more information regarding your performance requirements
and the characteristics of teh workloads for each instance. No specific
recommendations can be made based soly on the info you have provided.
Linchi
"Juergen Ladrick" wrote:

> hi guys,
> i need some advice.
> we have here:
> win2003r2sp2-32bit 4gb ram dual quad-core xeon (8 cpu′shown and
> managable)
> 2 instances sql2000sp4, both with default settings, both equally
> used ...
> what would now be the recomended settings to provide the best
> solution.
> how should ram and procs be splitted to maximize performance?
> ram for system: 1gb
> ram for sql#1: 1.5gb
> ram for sql#2: 1,5gb
> proc 0+1 : system
> proc 2-4: sql#1
> proc 5-7: sql#2
> or what do you guys think?
> thanx in advance
> juergen ladrick
>