Solved

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

Posted on 2010-11-24
7
627 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
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
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…

863 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now