Solved

Server 2003 speed issue

Posted on 2014-09-04
4
149 Views
Last Modified: 2014-09-30
I have a 2003 x86 server, all patched up, recently had a bespoke software package updated, since then all the clients reporting long lags when accessing the server data (bespoke clients installed locally), now the software company is blaming the server for speed, but I can copy a 1GB file over the LAN to server in around 15 seconds on Gigabit, so it doesn't seem like there LAN is slowing the software down.
Looking at the server, there are no major errors, and all other software such as Outlook to Exchange works fine, but the manufacture still insist that the server and the network is at fault, what software can I run to generate tests to show the server and the network is working fine ?
Prior to the update, their software on the server with their clients software locally all worked ok, but it is difficult to try to convince them their software may be to blame for this, and the speed issue came after the update because the next day everyone noticed this massive lag.
Thanks for any help on this.

Server is on Q6600/4GB/RAID10 on 4HDD
0
Comment
Question by:Combemartin
  • 2
  • 2
4 Comments
 
LVL 23

Expert Comment

by:rhandels
ID: 40303032
It is pretty hard to find a solution for this. Looking at the specs of the server and the story you tell it seems to be a software issue. You updated the software on the server, right? You also updated the software on the clients, right?

Is the application in need of a database? If so, did you install the database on the same server as the application? What happens if you look at the task manager? Is memory and CPU not going though the roof?? How large is your IO Queue?? Could it be you don;t have enough IOPS??

Files being copy from 1 place to another could be slow if you have a multitude of small files instead of 1 big large file. But still, if this were the case it is still a vendor issue because all and every machine would have that issue.
0
 

Author Comment

by:Combemartin
ID: 40303078
Hi,
Yes, it is a database system, written almost 20 years ago so it is still on a file per record base, currently there are around 950'000 records all as individual files, the software uses its own indexing to by pass the speed issue, both the server software and wks software were updated the same time as it always do,

Largest IO Read is the database @ 1'120'000'000 (next is Exnhange store @ 25'000'000) and also the largest Write at 179'000'000, according to them, its a minor update and the prev version worked fine, as a database programmer many years ago, I am guessing it has to do with the database read/write too often hence using the HDD more than ever and this in turn slowed all LAN access for their clients to read/write the database from the server.
0
 
LVL 23

Accepted Solution

by:
rhandels earned 500 total points
ID: 40303134
That would be my guess also looking at the numbers you are pointing out here. I still think it is a programming issue. Someone programmed something wrong if they say that this is just a small update. No way the performance of the server could cause such a steep degradation in performance.

I'm afraid you don't have some spare SSD disks laying around? You could try (if you would like to, takes some time) to install the database on an SSD drive, this would give you much more IOPS in general so performance would be greater.
0
 

Author Closing Comment

by:Combemartin
ID: 40353485
Thanks, I doubt we will get them to accept the speed issue as they always seem good at blaming the hardware.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

So you have two Windows Servers and you have a directory/folder/files on one that you'd like to mirror to the other?  You don't really want to deal with DFS or a 3rd party solution like Doubletake. You can use Robocopy from the Windows Server 200…
Numerous times I have been asked this questions that what is it that makes my machine log on so slow, there have been cases where computers took 23 minute exactly after taking password and getting to the desktop. Interesting thing was the fact th…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

757 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

20 Experts available now in Live!

Get 1:1 Help Now