I have just walked into a new network setup and there are issues I do not know how to address.
There is a DC server running server 2003 sp2 with 9 systems connected to domain. No issues there. This DC is handling DHCP and DNS.
There is another server running server 2003 sp2 not in domain, just workgroup. there are 9 point of sales systems in the same workgroup. Let's call this server the POS server.
The POS server is also running SQL 2005 Standard edition and doing replication of the POS databases through VPN tunnels to two other stores.
Replication is working fine.
All local systems are in the same subnet.
POS server has static IP and is using PDC for primary DNS and 126.96.36.199 for secondary DNS.
POS workstations are using workgroup settings and static ip's. Only IP address and subnet mask setup. No Gateway or DNS as these systems do not have internet privileges.
Most POS systems have 10/100 nics, a few have GB nics.
The POS server has two GB nics, one is disabled.
Setup has all GB managed switches. None of the switches show any collisions or dropped packets.
There are no errors in the Windows logs or the SQL logs.
They are having lag issues with the POS systems in the workgroup completing sales.
Invoices are recorded and then disappear, sales do not complete, workstations hang at the end of a sale.
It has been suggested to me that the issue could be that the POS server does not have enough bandwidth to handle SQL doing replication along with 9 workstations hitting SQL for sales and that the communication between the POS program and SQL is spotty which is creating all the strange issues.
One thing that was mentioned was that it would help to increase the bandwidth into the POS server. I have been reading about binding the adapters but cannot find the proper way (if there is one) to use my secondary adapter to help give me more bandwidth on the POS Server side.
My experience is with single DC networks and I do not know if this thing is even setup right.
Any help is sincerely appreciated and I hope I have given enough information to get this started.
Thank you in advance,