Solved

After intalling windows server 2008 R2 on database server, dstabase connections are very slow

Posted on 2013-12-11
12
275 Views
Last Modified: 2013-12-23
Hi,

I upgraded my server from windows server 2003 to windows server 2008 R2. I have two application servers. Now applications on application servers are trying to execute queries but those are taking too long. It is very strange why it is happening.

Firewall rule is open for 1433 TCP and 1434 UDP.

Thanks in advance!

Thanks,
Sulabh
0
Comment
Question by:sulabhkaushal
  • 7
  • 2
  • 2
  • +1
12 Comments
 
LVL 19

Expert Comment

by:Peter Hutchison
ID: 39711337
Change the network connection driver properties for Speed and Duplex from Auto Negotiation to '100 Mbps Full Duplex' or '1000 Mbps Full Duplex' to maximise network performance.
0
 
LVL 17

Expert Comment

by:Emmanuel Adebayo
ID: 39711349
Check to ensure that TCP/IP chimney offloading is disable.

See the link below for more info about TCP/IP Chimney offloading

http://support.microsoft.com/kb/951037
0
 

Author Comment

by:sulabhkaushal
ID: 39711496
Following is the result for TCP Chimney:

C:\Users\Administrator>netsh int tcp show global
Querying active state...

TCP Global Parameters
----------------------------------------------
Receive-Side Scaling State          : enabled
Chimney Offload State               : automatic
NetDMA State                        : enabled
Direct Cache Acess (DCA)            : disabled
Receive Window Auto-Tuning Level    : normal
Add-On Congestion Control Provider  : ctcp
ECN Capability                      : disabled
RFC 1323 Timestamps                 : disabled

Thanks,
Sulabh K.
0
NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

 
LVL 17

Expert Comment

by:Emmanuel Adebayo
ID: 39711559
Set this to disabled

Chimney Offload State               : automatic
0
 

Author Comment

by:sulabhkaushal
ID: 39719587
After making Chimney Offload State problem not resolved.

My one server is able to executed queries successfully but other not. This happens when a big data need to be retrieved.

When my database server was installed on Windows Server 2003, it was making connection quickly and executing queries quickly.

Please help!

Thanks,
Sulabh
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 39720287
Have you updated stats/defraged indexes after you migrated your databases?
0
 

Author Comment

by:sulabhkaushal
ID: 39720350
Yes I updated stats and re-indexed tables.

I am able to execute query using SQL client on one server successfully but on other server it fetch 500 rows quickly but after that is keep showing running.

Thanks,
Sulabh K.
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 39720551
I am afraid I have no idea.
0
 

Author Comment

by:sulabhkaushal
ID: 39723099
Hi,

I executed one query on both servers with client stats and the result is as below:

Fast response server:
Fast server response
Slow server:
Slow server response
That might give you some idea if it could be network issue or not. If it is network issue, please help me finding that which tool I can use to check for network settings.

Thanks,
Sanjeev
0
 

Author Comment

by:sulabhkaushal
ID: 39724663
Any suggestion, how can I check if it is network issue or any utility available which can track the things where are slow.

Thanks for the help!
Sulabh
0
 

Accepted Solution

by:
sulabhkaushal earned 0 total points
ID: 39727954
Hey,

I got the resolution for this. The switch had hard set duplex setting for sql server's port. I've set it for auto negotiate and is working fine now.

Thanks,
Sanjeev
0
 

Author Closing Comment

by:sulabhkaushal
ID: 39735720
I selected it because, nobody on expert exchange resolved my issue. I had to do RND for my problem my self and got in contact with network peoples and talked with Microsoft support who gave me an idea regarding this. These two weeks were very struggle full for me and a bad and good both experience.
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

This is a fairly complicated script that will install the required prerequisites to install SCCM 2012 R2 on a server.  It was designed under the functional model in order to compartmentalize each step required, reducing the overall complexity.  The …
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

828 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