Is it recommended to install SQL Server on a Windows domain controller?

Question

Is it recommended to install SQL Server on a Windows domain controller? The DC is a Compaq ML 370 2x9Gb(RAID1) + 4x18Gb(RAID5), and is in a remote office supporting 20 users. The DC also doubles as a file server. Any assistance will be greatly appreciated.


Answer

While SQL Server can run on a domain controller, it is not recommended if you are seeking the best performance. For best performance of SQL Server, the server should be dedicated to SQL Server, and not shared with other functions, such as a domain controller or a file server.

It is hard to tune servers that run multiple application, as different application may require mutually exclusive configurations. One example of this is SQL Server running on a file server. For best performance on Windows, the “Maximize data throughput for network applications” option should be selected in order for SQL Server to run optimally. But for file servers, the “Maximize data throughput for file sharing” should be selected for optimal performance. These two settings are mutually exclusive. So if you have a server that is running both SQL Server and acting as a file server, only one of the two can be optimized, and the other one will suffer performance.

Of course, if your SQL Server is not very busy, and you don’t ever expect it to be, then sharing server resources can made sense. Only you can decide if compromising SQL Server’s performance is the appropriate decision.

Another possible issue with running SQL Server on a domain controller is security. With both running on the same physical server, should one of them be compromised, then is is possible that it might be easier to compromise the other one also.




Related Articles :

  • No Related Articles Found

No comments yet... Be the first to leave a reply!

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |