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?