I assume a state-of-the-art installation therefore nothing weird like DC and SQL-Server on the same machine. Think about an installation following the commendations of microsft and all the recommended settings on both servers in a windows 2008R2 domain with sql2008R2.
| ||||
|
feedback
|
closed as not a real question by SvenW, gbn, jscott, Sam♦, Chris S♦ Mar 7 '11 at 4:48
It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. See the FAQ for guidance on how to improve it.
|
Ideally, SQL Server should run on a dedicated server - no IIS, no DC, no other apps! This is primarily for security and performance reasons - memory, and disc IO particularly - but it also makes troubleshooting easier. If this is not about SQL Server Express, the licencing costs of SQL Server surely justify a dedicated box. In clustered SQL Server environments, the installer prohibits SQL Server being installed on a box that is a DC. See also: http://www.sql-server-performance.com/faq/domain_controller_performance_p1.aspx | |||
|
feedback
|
