?
Solved

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

Posted on 2013-12-11
12
Medium Priority
?
280 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
Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

 
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

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

777 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