Solved

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

Posted on 2013-12-11
12
278 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
MIM Survival Guide for Service Desk Managers

Major incidents can send mastered service desk processes into disorder. Systems and tools produce the data needed to resolve these incidents, but your challenge is getting that information to the right people fast. Check out the Survival Guide and begin bringing order to chaos.

 
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

Edgartown IT Case Study

Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!

Question has a verified solution.

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

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

728 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