Applications accessing files on the domain locking up and slow to respond

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
invisimaxAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Larry Struckmeyer MVPCommented:
Some info that might be helpful:

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.
0
natcomCommented:
On a problematic server perform a clean boot and check if the issue still exists
1. Click Start->Run...->type msconfig and press Enter 2. Click Services tab and select Hide All Microsoft Services and Disable All third party Services.
3. Click Startup tab and Disable All startup items
4. Click OK and choose Restart
5. After reboot, check whether the problem still occurs.


and According to my experience, it is reported that some anti-virus applications, such as Symantec Endpoint Protection,may affect the file sharing function.
0
invisimaxAuthor Commented:
This turned out to be a bad block in the hard drive that was causing issues accessing the data stored in that location
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
invisimaxAuthor Commented:
This was not software related but rather a failing hard drive
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SBS

From novice to tech pro — start learning today.