Asif
2011-09-09 12:54:38 UTC
Dear All,
We are a large financial institution having IT solutions over diverse
platforms. Coming to the point we have a set of ASP.Net applications
that were running on Dell Power Edge 1950, Windows 2003 32 Bit
Standard Edition Service Pack 2 . The applications performance were
fine.
Later Management has decided to migrate the applications over Dell
R910 Server, Windows 2008 R2 64 Bit Server Standard with service pack
1. The migration steps were just to install all the software
components, no change has been made in the applications, the
applications were simply copy pasted to the new environment.
Since the migration the users start raising issues regarding
application performance. We have started looking all the layers
involved and finally come to the conclusion that application is
getting slow because the response time of the queries were
significantly slow over new 64 Bit server. The test we conducted were
simple, we executed sqlplus on both old 32 Bit and new 64 Bit Servers.
The query takes 0.88 seconds on windows 2003 and 4.45 seconds on
windows 2008 64 Bit server. This help us isolating the layer. We
Googled and have found similar problem reported over windows 2008
Server. We take following remedial steps.
4:- netsh int tcp set global RSS=disabled
5:- netsh int tcp set global Chimney=disabled
6:- netsh int tcp set global Autotuninglevel=Highlyrestricted also by
disabled
7:- disabled IPV4 Checksum offload from network card.
8:- disabled IPv4 Large Send Offload from network card.
9:- disabled IPv6 Checksum Offload from network card.
10:- disabled IPv6 Large Send Offload from network card.
11:- disabled TCP Connection Offload (IPv4).
12:- disabled TCP Connection Offload (IPv6).
13:- Disabled the SMB2 from registry.
14:- By disabled the IPv6 from network card also from registry.
15:- HKLM\System\CurrentControlSet\Services\TCPIP\Parameter
EnableTCPA (Enable 1 and disable
16:- Upgraded 64 Bit Oracle Client
But this still did not solve the problem, the query still taking too
much time on 64 Bit server then 32 Bit Server.
Kindly advice ways to resolve the issue
Regards,
Asif
We are a large financial institution having IT solutions over diverse
platforms. Coming to the point we have a set of ASP.Net applications
that were running on Dell Power Edge 1950, Windows 2003 32 Bit
Standard Edition Service Pack 2 . The applications performance were
fine.
Later Management has decided to migrate the applications over Dell
R910 Server, Windows 2008 R2 64 Bit Server Standard with service pack
1. The migration steps were just to install all the software
components, no change has been made in the applications, the
applications were simply copy pasted to the new environment.
Since the migration the users start raising issues regarding
application performance. We have started looking all the layers
involved and finally come to the conclusion that application is
getting slow because the response time of the queries were
significantly slow over new 64 Bit server. The test we conducted were
simple, we executed sqlplus on both old 32 Bit and new 64 Bit Servers.
The query takes 0.88 seconds on windows 2003 and 4.45 seconds on
windows 2008 64 Bit server. This help us isolating the layer. We
Googled and have found similar problem reported over windows 2008
Server. We take following remedial steps.
4:- netsh int tcp set global RSS=disabled
5:- netsh int tcp set global Chimney=disabled
6:- netsh int tcp set global Autotuninglevel=Highlyrestricted also by
disabled
7:- disabled IPV4 Checksum offload from network card.
8:- disabled IPv4 Large Send Offload from network card.
9:- disabled IPv6 Checksum Offload from network card.
10:- disabled IPv6 Large Send Offload from network card.
11:- disabled TCP Connection Offload (IPv4).
12:- disabled TCP Connection Offload (IPv6).
13:- Disabled the SMB2 from registry.
14:- By disabled the IPv6 from network card also from registry.
15:- HKLM\System\CurrentControlSet\Services\TCPIP\Parameter
EnableTCPA (Enable 1 and disable
16:- Upgraded 64 Bit Oracle Client
But this still did not solve the problem, the query still taking too
much time on 64 Bit server then 32 Bit Server.
Kindly advice ways to resolve the issue
Regards,
Asif