I currently have 2 windows 2000 Cluster servers.
Active/passive mode. I have SQL 2000 installed in the
cluster but the system crawls. I am running 2 very large
databases.
The current cluster servers are dual 600mhz PIII with
1gig of RAM each. These are also AD controllers and act
as file/print/dhcp for the office.
I am adding a single server for SQL2000. I am going to
uninstall SQL 2000 off of the cluster and install it on
the new server. I realize I will no longer have a SQL
cluster, it's going on a single server.
The new server is:
dual 2.4gig XEON, 4 15K 36 gig drives in a raid 0+1 array
2.5 gigs of ram
I want to make this server an AD controller, that way I
can rebuild the cluster when I have time and not have to
worry about recreating users. If I install this new SQL
server as an AD controller I can just dcpromo the two
cluster servers out, rebuild them and put them back into
the domain. Of course I will setup a temp DHCP server and
backup my files before rebuilding.
My question is this,
Is it considered bad practice to install SQL 2000 on an
AD Controller when you already have 2 in the domain? As
you can see it will make life easier but if it's going to
cause significant performance loss I would rather not do
it.
Thanks for the help!