SBS 2008 Slow XP Clients hanging on applications that access network data

Hi Chaps,

We have an SBS 2008 install which has been running fine for around 8 months, now we have an issues when users are using a custom application that access data from the SQL server, the application hangs / runs very slowly. The same happens when users access Sage, the data files are also on a network drive, this is with XP clients.

Many Thanks
Amiga500Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
HumpdyConnect With a Mentor Commented:
have you checked your network traffic as a bottlekneck ?

when it's slow, I would turn on SQL profiler to see if the database is acting up.
0
 
HumpdyCommented:
can you see how much disk space is left ?
is the SQL Server been properly maintained, Backups, reindexes etc ?
Does your SQL Logs give any errors, timeouts or anything ?
has anything changed recently or were things just getting progressivly worse ?
0
 
Amiga500Author Commented:
Hi,

We have over 200GB disk space left, SQL Backups & ReIndexes are being done, there are no errors or timeouts that I can see.

I wouldnt say things are getting progressivly worse, its just random times when applications that need to access network data will freeze or hang.
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
HumpdyCommented:
you know if there is high CPU usage on the server at these times ?
0
 
Amiga500Author Commented:
CPU useage is all good
0
 
Amiga500Author Commented:
will fire up the profiler and see how we get on
0
 
Amiga500Author Commented:
A wee bit more info on how to perform the SQL profiler stuff would have been nice :)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.