SQL optimal configuration

Hi,
We use sql 2000 for our inhouse applications. About 200+ users access it and
it runs on dual Xeon 3Ghz machines DELL branded. We use RAID1 for c:\ OS;
RAID1 for G:\ SQL system files; RAID10 for SQL database drive and RAID1 for
the sql logs.
CPU power seems enough, but we have disk access problems mainly with writing
of the data. Is there disk configuration rule as such? Do you think we are
using wrong types of arrays?
SQL 2000 Ent runs on both W2k and W2003 in our company.

Thanks
--
George
.

Relevant Pages

  • Transaction Logs
    ... I have installed a dual node active passive W2K3 Clusters with SQL 2K. ... The cluster has RAID10 for data and RAID1 for Quorum and Transaction Logs. ...
    (microsoft.public.sqlserver.clustering)
  • Cant add/edit/delete records in Access Data Project
    ... I have created an ADP to allow some users access to an SQL DB. ... I used this account when configuring the connection in the ADP. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: SQL optimal configuration
    ... > Mike Epprecht, Microsoft SQL Server MVP ... >> We use sql 2000 for our inhouse applications. ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL optimal configuration
    ... Mike Epprecht, Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.setup)
  • Odd SQL IN usage?
    ... Got an odd SQL string that I need to produce that is most probably simple to ... Now on the stats page I want to give users access to view ONLY sent ... campaigns to which they have access to view, I was considering the IN SQL ... working within just a single SQL query? ...
    (comp.databases.ms-sqlserver)
Loading