we have a company that uses mostly 2 programs quickbooks and their utility billing, both of which access databases stored on the server, starting yesterday morning when trying to do more productive things within the software they most commonly go not responding or time out completely for long periods of time..
I've done a trace route to the server and beyond and i don't see any latency to the server, i've also rebooted the switch.. There is approximately 12 computers on this domain and 2 large copiers.
I've monitored the network traffic on the server and it never jumps past like 500K, But even the other uses who have autocad files stored on the server are having autocad go not responding.
But when i'm in the server or try to access a file via windows explorer everything works fine, just using them in the software their intended for goes not responding.
Their billing program uses access. And accessing the file from access or explorer is fine, when trying to compact and repair the database is locking up. There is a front end of this software that runs a user interface and when using that it's absolutely not usable.
I've put as much information in here as i can remember. If yo uwould like to know anything else just ask
What version of Small Business Server?
Have you run the SBS BPA and fixed everything it finds? If not do so: www.sbsbpa.com
Did these issues begin recently, or where they present from the beginning of life for this SBS? What about prior to this SBS, what was hosting and how did it respond?
Have you changed the patch cord to the server, and the port in the switch for the server. I say for the server as you indicate the issue is from more than one station.
Errors in the event logs that might be relevent? Messages on screens when the issues occur?
Size/speed and capacity/free space on the server hard drives? Amount of RAM in the server, and percent used/free?
Clean boot on the Server... stop all AV products, stop Exchange Services... does that help?
There is more to ask, but lets start there.