Networks

Ask something
Question Locked

Very Odd Application Behavior

0 helpful
4 replies

by bart777 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Ok, here's a strange one.
I have a 3rd party app that is giving me a migraine.

On one server it seems to work just fine. It does a posting process to a SQL server in about 20 minutes.
On another server (Same hardware and config) the same process takes 4 hours. Actually the process works on 2 servers and not the other 9.
After doing comparisons I cannot find anything that would lead me to an answer.
NIC drivers are the same.
File security is the same.
All servers were built at the same time.
All are IBM 3650's. Citrix Preseantation Server 4.5 R02, Win2k3 SP2.
Broadcom Nics with the 4.1.3 driver at Gig full.
Switch is configured to gig full as well.
The behavior is the same if you attach to the Production or Test database servers. The one thing we can see on the SQL server is the process is very spiky. CPU will jump to 40% and then back down when the offending servers attach. When the working servers run the post the CPU goes up and stays at 30-40%. When we do a SQL trace we see that a certian query runs over and over again.
The application actually calls the query from the SQL server itself.

I'm about ready to just scrap this whole farm and stick with mt old XPE farm.

Anyone have any other ideas?

4 replies

by Former member

What are you trying to make this app do?
what is the purpose of this app?
More info on the app in question would be nice. :)

Please post back if you have any more problems or questions.

by bart777

This is a poultry farm application used across the eastern seaboard.

It's an older application that talks to a SQL server backend.

The only thing I want it to do is behave as it does on the older 8 servers and the 2 new servers. I have 10 that work and 9 that don't. That's what's drving me insane.

I'm trying to figure out how an application can perform a SQL select statement one way on the old servers and the 2 new servers and do it differently on the other 9 servers? It just doesn't add up. I can't put my finger on anything that will fix this.

I've tried it thru ICA, RDP, on the desktop, to no avail.

Now where did I put that Excedrin?!

by bart777

Sometimes I would just like to fly up to Seattle and slap some programmers at MS!!!!!

The problem turned out to be a bad security update. I had it on all but the developement boxes because they are not on the same update schedule as the production servers. Took out all of the newer updates and the program works as it should again.

Now I have to go to Walgreens and get more asprin.

This discussion is closed to new replies.