Friday, March 23, 2012

New SQL Server Install Advice

I have a new Dell PowerEdge 2800 running windows 2003. I have 2 RAID
containers as the machine has a PERC 4 controller. The machine has x2 73GB
SCSI and x4 146GB SCSI HDD.
Container 1
--
The OS C drive (partition of 12GB) is in RAID 1 and so is E drive which has
56GB free.
Container 2
--
A D drive for Data I created and also L for Log which I assigned as dynamic
drives.
Is this setup Ok for running SQL2000. The Data files will reside in D and
the Log files will reside in L. Is this Ok for the read/write access that
occurs when SQL is accessed?
Please help.
skcI assume there is at least one processor and some memory on the server as
well.
It will work. It depends on what performance, capacity, and availability
you are needing.
"Skc" <Skc@.discussions.microsoft.com> wrote in message
news:46CDFADB-7AC6-4719-B0A8-8154D6977397@.microsoft.com...
>I have a new Dell PowerEdge 2800 running windows 2003. I have 2 RAID
> containers as the machine has a PERC 4 controller. The machine has x2
> 73GB
> SCSI and x4 146GB SCSI HDD.
> Container 1
> --
> The OS C drive (partition of 12GB) is in RAID 1 and so is E drive which
> has
> 56GB free.
> Container 2
> --
> A D drive for Data I created and also L for Log which I assigned as
> dynamic
> drives.
> Is this setup Ok for running SQL2000. The Data files will reside in D and
> the Log files will reside in L. Is this Ok for the read/write access that
> occurs when SQL is accessed?
> Please help.
> skc|||Xeon 2.8 x2 and 2GB RAM.
We want max. performance. Is this OK?
Furthermore, I installed SQL2000 and it came with 4 CDs:
1> SQL 2000 Standard (Personal)
2> SQL 2000 Standard
3> SP4
4> Reporting Tools
I installed Disk #1, asked me no product key, I selected 5 CALS from the
dropdown (which was how many I bought) and that was it. I have the SQL
Service running and the SQL Tools (enterprise manager). What is the
difference between the 2 Cds mentioned above?
In Enterprise Manager, when I right-click the (local) Server, it says I have
Microsoft SQL Server Std Edition installed. This is very odd, I hope I have
done this right as it did not ask for a serial product key or anything.
Please verify the above it OK.
"Danny" wrote:
> I assume there is at least one processor and some memory on the server as
> well.
> It will work. It depends on what performance, capacity, and availability
> you are needing.
> "Skc" <Skc@.discussions.microsoft.com> wrote in message
> news:46CDFADB-7AC6-4719-B0A8-8154D6977397@.microsoft.com...
> >I have a new Dell PowerEdge 2800 running windows 2003. I have 2 RAID
> > containers as the machine has a PERC 4 controller. The machine has x2
> > 73GB
> > SCSI and x4 146GB SCSI HDD.
> >
> > Container 1
> > --
> > The OS C drive (partition of 12GB) is in RAID 1 and so is E drive which
> > has
> > 56GB free.
> >
> > Container 2
> > --
> > A D drive for Data I created and also L for Log which I assigned as
> > dynamic
> > drives.
> >
> > Is this setup Ok for running SQL2000. The Data files will reside in D and
> > the Log files will reside in L. Is this Ok for the read/write access that
> > occurs when SQL is accessed?
> >
> > Please help.
> >
> > skc
>
>

No comments:

Post a Comment