[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 640
  • Last Modified:

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
0
Amiga500
Asked:
Amiga500
  • 4
  • 3
1 Solution
 
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
 
HumpdyCommented:
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!

 
Amiga500Author Commented:
CPU useage is all good
0
 
HumpdyCommented:
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
 
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

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now