ProLiant Servers (ML,DL,SL)
1748010 Members
4571 Online
108757 Solutions
New Discussion

Re: ask - Recommended Configuration for Domain Controll and SQL Server

 
no_name
Frequent Advisor

Re: ask - Recommended Configuration for Domain Controll and SQL Server

hi,

 

thanks for all explanation. we will consider to use SQL 2005. hope the application support that SQL version. many thanks to you.

no_name
Frequent Advisor

Re: ask - Recommended Configuration for Domain Controll and SQL Server

hi,

 

sorry. is there reference model to meet my needs? I prefer for tower model.

 

thanks.

 

Skotte
Frequent Advisor

Re: ask - Recommended Configuration for Domain Controll and SQL Server

Hi,

 

Any Proliant will meet your needs, Gen8 ML350p, or Gen8 ML310e should meet your needs.

Both come with a 420I raid controller with 512MB cache standard and you should consider 8 or 16GB RAM.

If you want to go down the refurbished / second hand road, the Proliant ML350 Gen 7 and Gen 6 both have decent specs, and come with the P410 raid controller.

 

Database best practice states that you should keep the OS separate from the DB data.

To take this one step further, it would be advisable to keep the backup sets separate from the data and the OS.

 

So:

RAID 1 array of 2 500GB SATA or 300GB SAS disks to hold the OS, SQL Server and the system databases

RAID10 array of 4 of the fastest and largest disks you can afford to purchase to hold the SQL data.

 

This would be the absolute minimum reccommended configuration for a database server

 

Hope this helps

 

Cheers

 

Leon

 

no_name
Frequent Advisor

Re: ask - Recommended Configuration for Domain Controll and SQL Server

hi,

thanks for advice. it's pretty high budget.

 

for storage, maybe I will use alternative way. But I need for sure, specification that users will not experience slow in connection/access to database.

 

if my configuration (user ML110):

E3-1230

8 GB ram

300 GB SAS

windows server 2008 standard with Hyper-V

* allocated for Hyper-V

4 GB RAM

2 processors

 

it will be enough?

 

since price for ML350 almost twice of ML110, I consider ML110, if not enough, may be I will use 2xML110

Skotte
Frequent Advisor

Re: ask - Recommended Configuration for Domain Controll and SQL Server

Hi,

 

The ML110 you have specified should be enough for basics.

I would suggest adding a little extra ram since the machine will effectively be 2 servers with 2 separate OSs and SQL server can be a little memory hungry.

 

Cheers

 

Leon

 

 

 

 

no_name
Frequent Advisor

Re: ask - Recommended Configuration for Domain Controll and SQL Server

Hi,

sorry for my late reply.

 

I consider to buy ML110 with full spec:

E3-1220

Ram total 10 GB

HDD 300 GB sas x1

software:

Windows 2008 standard R2 with hyper-v

domain controller

antivirus

 

guest machine (virtual) has spec:

- number processor x2

- Ram allocated: 4 GB

windows server 2008 standard

SQL server 2008

 

cycle of use server: 2-3 years.

we optimize the database one per year.

 

is this enough?

 

thanks