Slow Network Traffic In Dual Server 2003 Environment
Posted on 2005-04-12
Here is my setup...
There are two servers on our network. These two new, beefier servers are taking the place of an old Server 2000 machine. Both servers are currently operating on Windows 2003 Standard Edition, one server (server1) is a domain controller and the other server (server2) is a member of this domain. Server 2 is running SQL 2000 with SP3. Server 1 is just a file server that functions solely as a domain controller. Both servers have been updated to service pack 1 right after the initial install.
Everything is working correctly on server 1. There are no errors in the event logs. All computers can see each other on the network and they can open files from both servers quickly and easily. The problem I am having is this. We have an application that runs off of a SQL database. There is a lot of disk space consumed by the data created from this program. Whenever this application is open on a client computer, data transfer lags. In the program you can fill out different fields in a document and they are stored in this database. When you switch fields or open another document, there is a considerable lag. It was not like this on the old server.
I have made sure that the permissions are set on the folders on Server 2 so that Domain Users have full control (at the discretion of the software company). All of the data for this application is located on Server 2. Users authenticate through Server 1 and access Server 2 via a mapped drive.