Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Server 2003 speed issue

Posted on 2014-09-04
4
Medium Priority
?
159 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
[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
  • 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 2000 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

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

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

Organizations create, modify, and maintain huge amounts of data to help their businesses earn money and generally function.  Typically every network user within an organization has a bit of disk space to store in process items and personal files.   …
Many of us need to configure DHCP server(s) in their environment. We can do that simply via DHCP console on server or using MMC snap-in on each computer with Administrative Tools installed in a network. But what if we have to configure many DHCP ser…
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 …
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …

715 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