Solved

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

Posted on 2013-12-11
12
267 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
 
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
Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

 

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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
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 extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
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.

863 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now