Database running on client machines runs slow when more than one user is using them at one time`
Posted on 2009-12-30
I have just installed a server in a small medical practice. There are 4 workstations 3 running XP pro one running Vista business. The server is running SBS 2008. Now each workstatiion has a database program on it the server has the data on it. Each workstation has a mapped drive to the data on the server the database program points to this. Now when you go into the program (it uses access 2007) you log in and you then get the consultant menu. Whe you select the appropriate consultant the tables link and you then get the consultants menu. Then to see the patient details you click on the patient screen buttton. Then you get the patient details up where you can enter data etc. Now normally when you select the consultant and the database loads it takes about 10 secs maybe less, However if another user is in the pateint details screen eitheir entering data or it is just idle. This loading process can take up to a minute or two and if the other logs out of the pateint details creen during this it suddenly speeds up to normal speed. Now each workstation has a 10/100 broadcom network card and the server has has a broad com gigabit network card. These are are CAt5 cabled to a PowerConnect 2816 Web-Managed Switch, 16 GbE Ports. Now when i acces the shared folders its blazingly quick. If i drag folders from the server to a workstation it is like lghtening. It only takes seconds to log on to the workstations I just dont get why its slowing with the database application. It didnt used to when it was just on a peer to peer only on the machine that was acting as a server. When I look at the network stats when this is going on the use of bandwidth is miniscule. Can any one help?