Home > Archive > MS SQL Server > November 2005 > New SQL Server Install Advice









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author New SQL Server Install Advice
Skc

2005-11-11, 7:23 am

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
Danny

2005-11-11, 7:23 am

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@microso
ft.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



Skc

2005-11-11, 9:23 am

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@microso
ft.com...
>
>
>

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com