mssql 2000 v/s raid 5ee

Hallo all
I know mssql2000 v/s raid 5 is dont work (very slowly). Who knows if i
install mssql 2000 on raid 5ee (win 2003server standard) i will have
better performance or not ? I know the best performance is no raid 10
but i dont have.
Hi,
The performance depends up on the volume of data and amount of access. Take
a look into the below URL .
http://www-03.ibm.com/support/techdo...Index/WP100350
Thanks
Hari
<ebolasty@.op.pl> wrote in message
news:1160926718.834857.267660@.k70g2000cwa.googlegr oups.com...
> Hallo all
> I know mssql2000 v/s raid 5 is dont work (very slowly). Who knows if i
> install mssql 2000 on raid 5ee (win 2003server standard) i will have
> better performance or not ? I know the best performance is no raid 10
> but i dont have.
>
sql

mssql 2000 v/s raid 5ee

Hallo all
I know mssql2000 v/s raid 5 is dont work (very slowly). Who knows if i
install mssql 2000 on raid 5ee (win 2003server standard) i will have
better performance or not ? I know the best performance is no raid 10
but i dont have.Hi,
The performance depends up on the volume of data and amount of access. Take
a look into the below URL .
http://www-03.ibm.com/support/techd...bIndex/WP100350
Thanks
Hari
<ebolasty@.op.pl> wrote in message
news:1160926718.834857.267660@.k70g2000cwa.googlegroups.com...
> Hallo all
> I know mssql2000 v/s raid 5 is dont work (very slowly). Who knows if i
> install mssql 2000 on raid 5ee (win 2003server standard) i will have
> better performance or not ? I know the best performance is no raid 10
> but i dont have.
>

mssql 2000 v/s raid 5ee

Hallo all
I know mssql2000 v/s raid 5 is dont work (very slowly). Who knows if i
install mssql 2000 on raid 5ee (win 2003server standard) i will have
better performance or not ? I know the best performance is no raid 10
but i dont have.Hi,
The performance depends up on the volume of data and amount of access. Take
a look into the below URL .
http://www-03.ibm.com/support/techdocs/atsmastr.nsf/WebIndex/WP100350
Thanks
Hari
<ebolasty@.op.pl> wrote in message
news:1160926718.834857.267660@.k70g2000cwa.googlegroups.com...
> Hallo all
> I know mssql2000 v/s raid 5 is dont work (very slowly). Who knows if i
> install mssql 2000 on raid 5ee (win 2003server standard) i will have
> better performance or not ? I know the best performance is no raid 10
> but i dont have.
>

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 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.
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

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