• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 166
  • Last Modified:

Server 2003 speed issue

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
Combemartin
Asked:
Combemartin
  • 2
  • 2
1 Solution
 
rhandelsCommented:
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
 
CombemartinAuthor Commented:
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
 
rhandelsCommented:
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
 
CombemartinAuthor Commented:
Thanks, I doubt we will get them to accept the speed issue as they always seem good at blaming the hardware.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

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