Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

Posted on 2013-12-11
12
Medium Priority
?
283 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 20

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 18

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
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

 
LVL 18

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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

636 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