- Community Home
- >
- Servers and Operating Systems
- >
- HPE ProLiant
- >
- ProLiant Servers (ML,DL,SL)
- >
- Re: ask - Recommended Configuration for Domain Con...
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Forums
Discussions
Discussions
Discussions
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-26-2013 01:10 AM
06-26-2013 01:10 AM
ask - Recommended Configuration for Domain Controll and SQL Server
Hi there,
we plan to upgrade old server to new one. we consider to use tower server.
that server will be used for domain controller under Windows server 2008 R2 (either enterprise or standard, still discuss about this), and also will be installed sql server 2008 data center.
is E3-1220 with 4GB ram will enough? or it too basic?
usage time 3-5 years.
thanks in advance
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-26-2013 03:25 AM
06-26-2013 03:25 AM
Re: ask - Recommended Configuration for Domain Controll and SQL Server
Hi,
It is not reccommended to install SQL server on a domain controller.
The main reason is security, if SQL server is compromised, the possibility of the DC being compromised is increased.
Also it is more difficult to tune a system running multiple applications.
That being said, it can be done, there is nothing stopping you from installing SQL server on a machine with the Domain Controller role.
In my honest opinion, 4GB RAM is way too small to be running SQL server let alone a DC.
SQL Server will chew up a minimum of 400MB RAM just sitting idle.
If you could post more information as to what the SQL server is to process, the db environment, and how many concurrent transactions / users will be using the Database server at one time.
Cheers
Leon
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-26-2013 08:13 PM - edited 06-26-2013 08:17 PM
06-26-2013 08:13 PM - edited 06-26-2013 08:17 PM
Re: ask - Recommended Configuration for Domain Controll and SQL Server
hi, thanks for input.
database wiil be used for data stored from certain application.
concurrent user for database (via application, which installed on client site) up to 4 users, but very rare, mostly only 2 users.
we are not use reporting nor analyst tool for database.
4GB too small? then what size of RAM you recommend?
how about the processor? since that processor categorized as low cost processor. But I'm amazed the clock is 3Ghz and it has 4 cores.
thanks :)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-26-2013 11:17 PM - edited 06-26-2013 11:27 PM
06-26-2013 11:17 PM - edited 06-26-2013 11:27 PM
Re: ask - Recommended Configuration for Domain Controll and SQL Server
Hi,
I tried last night to install SQL server on a DC (virtual testbed) to see how the system will perform using 4GB RAM on a 4 core VM.
I ran into an issue:
The DC role installed fine, however, upon installing SQL Server 2008 / 2008R2 / 2012 onto the 2008R2 DC, the files installed, however, the security groups were not created.
2005 installs fine btw, just seems to be 2008 and above.
So, I would suggest the following:
Use HyperV, install 12-16GB RAM onto the machine, and run the DC from the primary OS, and SQL Server from the Virtualised OS.
Windows Server 2008r2 standard has one additional HyperV license, enterprise has 4 additional licenses.
This allows you to isolate the SQL Server instance from the DC.
HTH
Cheers
Leon
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-26-2013 11:32 PM - edited 06-26-2013 11:34 PM
06-26-2013 11:32 PM - edited 06-26-2013 11:34 PM
Re: ask - Recommended Configuration for Domain Controll and SQL Server
I am posting the explaination in a separate post.
On Win 2008 service SID is supported.
The service SID is added to the security group and the resources are normalized (Access Control Lists) using the group. The exception is Domain Controller where the resources are normalized using the service SID itself.
On Win 2008 R2 and above the service SID enquires the “well known group” which is in the form of “NT Service\Service Name” to get the status of the account so that resources can be normalized using the service SID.
Service SID is added as sysadmin for engine to access the resources.
Therefore the behavior encountered is by design.
On Win 2008 R2 DC, if you install SQL 2008 or above the security groups are never created.
Rather the service SID “NT Service\Service Name” is provisioned to set Access Control Lists on the resources.
Thus you see “DATA” or other folder/reg keys have this account on “Security” tab under folder properties.
The per-service SID is derived from the service name and is unique to that service.
A service SID name for SQL Server service is like “NT Service\MSSQL$<InstanceName>”
In any case, the security group or service SID for SQL is managed by SQL itself.
Cheers
Leon
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-28-2013 01:51 AM
06-28-2013 01:51 AM
Re: ask - Recommended Configuration for Domain Controll and SQL Server
Hi,
thanks for detail describe :)
so, there is an error while we combine DC 2008 with SQL 2008. an the error is security issue. am I right?
if you suggest for 16GB ram, is there tower version which have that much ram?
and, E3-1220 or on its class (1230, 1240) are capable for those tasks to run together, am I right?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-28-2013 03:14 AM
06-28-2013 03:14 AM
Re: ask - Recommended Configuration for Domain Controll and SQL Server
Hi,
Yes, it's a security issue.
Intel Ark advises that the i3-1220 can support up to 32GB DDR3-1066/1333 RAM, so that should not really be an issue.
Considering what you are running, and what will be used, the i3 should be able to run all of the applications without a problem given enough RAM.
Hope this helps.
Cheers
Leon
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-01-2013 03:26 AM
07-01-2013 03:26 AM
Re: ask - Recommended Configuration for Domain Controll and SQL Server
hi,
yes, your explanation very clear :)
btw, we consider not to use virtual machine if possible, because even we use 1 PC, that could be mean we still need more than 1 license for MS windows server.
let say, I ignore about security issue (I assume security issue refer to "system has been compromised/attacked"), is there any consideration to not combine sql server with domain control in one system?
thanks in advance.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-01-2013 08:38 AM
07-01-2013 08:38 AM
Re: ask - Recommended Configuration for Domain Controll and SQL Server
Hi,
Using Windows Server 2008 / 2008R2 / 2012 server, you can physically install SQL Server 2008 / 2008R2 / 2012 on the system with the Domain Controller Role, however, it will not allow the groups to be created.
Windows will not allow a server to be promoted to a Domain Controller with SQL Server installed.
On Win 2008 the service SID is added to the security group and the resources are normalized using the service SID itself. *The Service SID is added as sysadmin, not MSSQLSERVER*.
On Win 2008 R2 and above,the service SID enquires the NT Service\Service Name to get the status of the account so that resources can be normalized using the service SID in all scenarios like Standalone, Cluster or DC.
Of course service SID is added as sysadmin for engine to access the resources.
You can read here how it works, the per-service SID is derived from the service name and is unique to that service. A service SID name for SQL Server service is like “NT Service\MSSQL$<InstanceName>”
The security group or service SID for SQL is managed by SQL itself, not the DC.
You can however, install SQL Server 2005 onto a 2008 / 2008R2 / 2012 Domain Controller.
Cheers
Leon
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-01-2013 08:54 AM - edited 07-01-2013 08:54 AM
07-01-2013 08:54 AM - edited 07-01-2013 08:54 AM
Re: ask - Recommended Configuration for Domain Controll and SQL Server
What I am trying to say is that SQL Server 2008 / 2008R2 and 2012 manages its own groups.
Windows Server 2008 / 2008R2 and 2012 with a Domain Controller role will not allow these groups to be created by SQL Server.
SQL Server 2005 does not install these groups, it uses a completely different management substructure.
All editions of Windows Server come with at least 1 addiitonal licence for HyperV with the exception of the foundation edition, so you do not have to worry about having to purchase an additional licence
Hope this Helps
Cheers
Leon
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-02-2013 03:34 AM
07-02-2013 03:34 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-02-2013 08:50 PM
07-02-2013 08:50 PM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-08-2013 04:20 AM - edited 07-08-2013 08:21 AM
07-08-2013 04:20 AM - edited 07-08-2013 08:21 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-17-2013 06:26 PM
07-17-2013 06:26 PM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-18-2013 12:22 PM
07-18-2013 12:22 PM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-02-2013 02:25 AM
08-02-2013 02:25 AM
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