>SQL SERVER works on all three SQL SERVER (primary, backup or member).
>
>I want to know which one is the best suitable for SQL SERVER and give us the best preformce of SQL SERVER.
The current recommendation is that SQL Server should NOT be installed on a domain controller. This way resources can be dedicated to SQL Server and not shared with the periodic maintenance of the domain.
-Mike