ms-sql 2000 configuration

Hello everybody !
I have dedicated server for database (ms-sql) with configuration"
- 8xCPU (Xeon MP)
- 8GB RAM
- 3 RAID 10 partitions for database, log and other files
- Windows 2003 Enterprise OS
So, How to set memory & CPUs in Enterprise Manager ?
Fixed size memory i.e. 7GB for SQL and the rest for system or should I use
"Dynamically configure SQL server memory" option ?
Is it necessary to use "Reserve physicial memory for SQL server" option ?
Is it good idea to use all of 8 CPUS for SQL ?
If anybody knows help me to do that...
Thanks in advance.Hi
"Greg" wrote:

> Hello everybody !
> I have dedicated server for database (ms-sql) with configuration"
> - 8xCPU (Xeon MP)
> - 8GB RAM
> - 3 RAID 10 partitions for database, log and other files
> - Windows 2003 Enterprise OS
> So, How to set memory & CPUs in Enterprise Manager ?
> Fixed size memory i.e. 7GB for SQL and the rest for system or should I us
e
> "Dynamically configure SQL server memory" option ?
> Is it necessary to use "Reserve physicial memory for SQL server" option ?
> Is it good idea to use all of 8 CPUS for SQL ?
> If anybody knows help me to do that...
> Thanks in advance.
If this box is dedicated to SQL Server then you should not need to set the
min/max memory values and all CPUs could be allocated to SQL Server. If you
are using the server for other processes (such as DTS packages) then you may
want to change the configuration, but you may want to monitor the system
performance first to find out if this is an issue.
You should make sure that you AWE configured correctly.
http://support.microsoft.com/kb/274750 Also make sure that you have service
packed the system to SP4 then you have also applied the post SP4 hot fixes
http://support.microsoft.com/kb/899761
John