Need some suggestions at best practices asap please...

Need some suggestions at best practices asap please...

Post by Watercoo » Sun, 27 Apr 2003 05:56:11



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!

 
 
 

Need some suggestions at best practices asap please...

Post by Keith Kratochvi » Sun, 27 Apr 2003 06:48:00


The new box sounds like it will be better than your current setup :)

Personally, I would not choose to install SQL Server on a domain controller if at all possible.
Leave this machine dedicated to SQL Server!

--
Keith, SQL Server MVP


> 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!


 
 
 

1. Result Sets easy one I need help need Asap Please guys

I was wondering with a ResultSet I want to display results in a JListBox

lets say my ResultSet returns customer names

the result set returns
kevin
mat
david

IN THE TABLE CALLES CUSTOMER THE FILEDS EXIST
CustomerID,Name,PhoneNumber

then I want to put thouse names in a list box
but what I want to do is when the user clicks in one of those names in the
list box
I want to be able to display the PhoneNumber in a JTextField box
is this possible to do?

2. specify the IP Addess and port for SQL BE (in Access Project BE)

3. V_I_S_U_A_L___V_O_I_C_E___P_R_O___DEVELOPER NEEDED ASAP!!!!!!!!! GOOD PAY

4. All Tri State People

5. Best practice to interact with a DB - advice needed

6. Info on FilePro

7. Suggestions please on best method of transferring data

8. failover server

9. Suggestions please on the best method of transferring data

10. Good Flowchart Program Suggestion Please

11. *********BEST PRACTICE 98%. Need two more Points

12. Suggestions for a good SQL book, please...