Solved

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

Posted on 2010-11-24
7
628 Views
Last Modified: 2012-05-10
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
0
Comment
Question by:Amiga500
  • 4
  • 3
7 Comments
 
LVL 10

Expert Comment

by:Humpdy
ID: 34205586
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
 

Author Comment

by:Amiga500
ID: 34205744
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
 
LVL 10

Expert Comment

by:Humpdy
ID: 34205777
you know if there is high CPU usage on the server at these times ?
0
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 

Author Comment

by:Amiga500
ID: 34205801
CPU useage is all good
0
 
LVL 10

Accepted Solution

by:
Humpdy earned 500 total points
ID: 34205891
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
 

Author Comment

by:Amiga500
ID: 34205928
will fire up the profiler and see how we get on
0
 

Author Closing Comment

by:Amiga500
ID: 34544032
A wee bit more info on how to perform the SQL profiler stuff would have been nice :)
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I work for a company that primarily works with small businesses as their outsourced IT vendor. As such the majority of these customers utilize some version of Small Business Server. Due to the economics of running a small business, many of these cus…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question