[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

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

Posted on 2010-11-24
7
Medium Priority
?
638 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

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

Accepted Solution

by:
Humpdy earned 1500 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

Learn how to optimize MySQL for your business need

With the increasing importance of apps & networks in both business & personal interconnections, perfor. has become one of the key metrics of successful communication. This ebook is a hands-on business-case-driven guide to understanding MySQL query parameter tuning & database perf

Question has a verified solution.

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

In this article I will describe the Detach & Attach 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.
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …

656 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