.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Windows 7 SP1 x86, ODBC, and SQL Native Client Performance

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :

Good Morning Everyone,

**Reposting to SQL Board. I have this question with Windows 7 Performance as well.**

Since applying SP1 to select Windows 7 Ent machines (testing before mass install), I have found that one of our applications that uses the SQL Native Client for an ODBC connection is awfully slow. It takes 5 minutes for the application to load and come back with initial data load/presentation. I have tried every other SQLCLI install available, including 2005, 2008, and 2008 R2. This was the case when I first tested the application with Windows 7 about 6 months ago until I found driver version 2007.100.2531.0 SQL Server Native Client 10.0, which seemed to resolve the slowness issue. Now, after applying SP1, it has reverted in being slow.

Is there anything I can look for or modify that might be causing this issue? What part of SP1 touched the ODBC or SQL driver?




View Complete Post

More Related Resource Links

Should I move ODBC Apps from the SQL Server driviver to SQL Server Native Client 10.0

I have a suite of applications written for SQL Server 2000 in Access 2000 and Access 2007 and running under Access 2007 (12.0.6423,1000 SP2 MSO 12.0.6425.1000) via ODBC with the SQL Server ODBC driver (2000.85.1132.00) under Windows XP Professional (2002 SP3).  I have maintained all the data modules in Access 2000 format so that they can be accessed by SQL Server 2008 if required and am gradully upgrading the data modules to SQL Server.  The server they are connected to is Microsoft SQL Server Standard Edition (10.0.2531.0 running on a 32-bit Wndows Server 2008 Standard (SP2).  As a security improvement I intend to move a number of the applications to the server itself.  My choice of driver for ODBC is between SQL Server (6.00.6002.18005) and SQL Server Native Client 10.0 (2007.100.2531.00).  I have yet to discover any differences in application behavior or performance between the two interfaces My assumption is that I will have have fewer problems if I configure the ODBC links using the SQL Server driver.  However, I was wondering if there is a reason to gradually move them over to the SQL Server Native Client 10.0 driver. Thanks, Harry

ODBC from Windows 7 client to SQL 2008 R2 server


I get an intermittent error when trying to connect to the SQL backend.  I am using the SQL Server Native Client 10.0 for my connection and it was created with no problems.  I am using it to access Dynamics GP 2010 data on the SQL backend.  SOMETIMES when logging into GP I will get a message (after about 5 minutes) stating that my login info could not be verified.  Other times I get in just fine.  When I try to troubleshoot this by "configuring" my DSN, I sometimes get stopped when trying to obtain default setting (or testing the connections) - other times it flies right thru without errors.  I am able to use the same ODBC connection (except that it is the SQL Native Client) from Windows 2008 servers, workstations running XP; but not reliably from my 32-bit Windows 7 machine. 

Any ideas?  Thanks in advance.

Hal Steinkopf.

Windows with C++: Exploring High-Performance Algorithms


See how you can gain efficiency in surprising ways by looking closely at your algorithms, the data they operate on, and the hardware you're designing for.

Kenny Kerr

MSDN Magazine October 2008

GUI Library: Bring the Simplicity of Windows Forms to Native Apps


In this article, author John Torjo presents a guide to his C++ GUI library called eGUI++ and explains how it makes user interface programming easier.

John Torjo

MSDN Magazine June 2008

Winning Forms: Practical Tips For Boosting The Performance Of Windows Forms Apps


This article discusses techniques you can use to ensure that Windows Forms-based apps provide optimal performance to match the rich UI responsiveness they're known to provide.

Milena Salman

MSDN Magazine March 2006

Web-Aware Apps: Build Hyperlinks into Your Client App with the Windows Forms LinkLabel Control


LinkLabels are Windows Forms controls that enable a user to hyperlink to a URL that points to either the Web or the local directory system. While the SDK documentation discusses the control, it does not demonstrate how linking is accomplished, nor does it outline the power and flexibility the control provides. This article fills those gaps, showing how to link using the LinkLabel control. It also shows the flexibility of this control for the programmer using the .NET Framework. In addition, the author covers the large number of properties that allow you to customize your controls and accurately place them. Their built-in behaviors are also discussed, along with their use in both Visual Basic .NET and C#.

Dan Hurwitz

MSDN Magazine February 2003

WinInet: Enable HTTP Communication in Windows-Based Client Applications


The Internet provides the infrastructure for applications to communicate, and that can include non-UI communication between Win32-based applications. If you think beyond the standard browser usage of HTTP, you can use this protocol to retrieve information from Win32-based applications and save it to a Web server. After explaining how HTTP can be used in this way, this article shows how to use Microsoft SQL Server, ASP, IIS, WinInet, and Visual Basic to implement two examples. The first reports usage data-how often an application is used and by whom. The second monitors application errors and reports error details for use by helpdesk staff or engineers in the debugging process.

Todd Meister

MSDN Magazine June 2001

COM+ and Windows 2000: Ten Tips and Tricks for Maximizing COM+ Performance


There are many tricks to getting the most out of COM+, and this article offers the author's top 10. The tips cover the importance of transaction processing, the use of the COM+ catalog, and the design of three-tier distributed systems. Writing components using the correct threading model, knowing when to use compensating transactions, and the importance of stress testing early in the process also make the list. Other indespensible suggestions emphasize the importance of recognizing where an object's state is located, choosing appropriate authentication levels for COM+ applications, using Queued Components correctly, and implementing object pooling.

David S. Platt

MSDN Magazine December 2000

Windows Client Developer Roundup 036 for 8/9/2010

This is Windows Client Developer roundup #36. The Windows Client Developer Roundup aggregates information of interest to Windows Client Developers, including WPF , Silverlight , Visual C++, XNA , Expression Blend , Surface , Windows 7, Windows Forms, Windows Phone and Visual Studio, WCF RIA Services , sometimes even a little jQuery and HTML5. If you have something interesting you've done or have run across, or you blog regularly on the topics included here, please send me the URL and brief description via the contact link on my blog. WPF and Silverlight General WCF RIA Services Part 4 - MVVM (Brian Noyes) WPF: Introducing the MVVM pattern for VB2010 developers - part 7 (Alessandro Del Sole) Unit Testing XAML Data Bindings in Silverlight...(read more)

Video: The Access Show: Client Performance Improvements against SharePoint Lists

Today's guest is DJ Cole, architect and primary developer of SharePoint connectivity performance improvements on the Access development team. DJ dropped by to talk about how Access 2010 connects to SharePoint, and to discuss the work necessary for improving client-side performance. (Length: 13:05)

Wickedly Strange .Net WPF Performance Problem Dissapeers with Windows 7 Performance Monitor Open

Hello Everyone, I have been developing one large and complex WPF application for 13 months now, all is going well and especially tonight as I now have some sort of clue or hint to what I have been seing now for quite some time.  Here is the rundown. 1) Running on i5 processor with 4GB RAM and Windows 7 2) The application was developed all in .Net 4.0, WPF C#. 3) It is heavily GUI intensive and also uses Entity Framework Detached for Database Access. 4) Is multi-threaded / multi-tasking. I am a nutcase when it comes to testing.  Since my graphical application heavily depends upon performance and determinsm (please somebody don't start with the C++ vs .Net on here) and has been performing great FOR THE MOST PART.  Every once in a while, I see that the application runs into the weeds for 5 or 6 seconds and the interface is unresponsive.  I have this thing tuned finely too.  Well now toward the end of development I have finally had to face that bug so to speak.  I can force it by clicking spastically on my buttons causing an event storm and making the system update the GUI.  SO!  Great start, I can now cause the problem on a regular basis (for you youngsters that is actually a good thing)!  Alright, so I start with the easiest investigative tool, CNTRL - ALT - DEL into Windows 7 Performance Monitor.  As you can tell from

Install SQL Server2005 Error:[Native Client]Encryption not supported on the client

Product: Microsoft SQL Server 2005 -- Error 29515. SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]Encryption not supported on the client. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.

WCF Client (netTcpBinding) does not connect to remote DNS on Vista and Windows 7

Hi, WCF Client (netTcpBinding) does not connect to remote DNS on Vista and Windows 7. With other OS like XP and Windows 2003, client connects to remote DNS properly. I got the following exception. Same client works in Vista and Windows 7 if service is available in local network. Following are the exceptions: <Exception> <ExceptionType>System.ServiceModel.EndpointNotFoundException, System.ServiceModel, Version=, Culture=neutral, PublicKeyToken=b77a5c561934e089</ExceptionType> <Message>No DNS entries exist for host icelive.theice.com.</Message> <StackTrace> at System.ServiceModel.Channels.DnsCache.Resolve(String hostName) at System.ServiceModel.Channels.SocketConnectionInitiator.GetIPAddresses(Uri uri) at System.ServiceModel.Channels.SocketConnectionInitiator.Connect(Uri uri, TimeSpan timeout) at System.ServiceModel.Channels.BufferedConnectionInitiator.Connect(Uri uri, TimeSpan timeout) at System.ServiceModel.Channels.TracingConnectionInitiator.Connect(Uri uri, TimeSpan timeout) at System.ServiceModel.Channels.ConnectionPoolHelper.EstablishConnection(TimeSpan timeout) at System.ServiceModel.Channels.ClientFramingDuplexSessionChannel.OnOpen(TimeSpan timeout) at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout) at System.ServiceModel.Channels.ServiceChannel.OnOpen(TimeSpan timeout) at System.ServiceModel.Channels.Comm

SQL Server allowing access with NATIVE CLIENT Protocols are disabled.

I have disabled all client protocols from SQL Server Configuration Manager -> Sql Native Client configuration -> Client Protocols.Still I am able to access sql server with all client protocols disabled. Why ?Also I stopped the SQL Server Services and restarted it again. Then also the system is allowing me to connect with all the client protocol disabled.

SQL server client tool installation on windows XP?

Hi My desktop is Windows XP sp3 and have office 2010, sql express 2005 management studio and Visual studeio 2008 sp1 installed.  We have a SQL R2 server installed last week.  I was able to use sql 2005 management studio to connect to the new sql 2008 R2.  Question is when i try to install 2008 R2's client tool using the 2008R2 iso image.  It look for windows installer 4.5 as prerequisite.  It fail in installing windows installer 4.5 with msg saying I am not the administrator and it require administrator right.  But I am logging in as administrator on local pc.  I also confirmed with our IT/Server guys and they confirmed that I have the admin right.  Then, I tried the following steps: a) reboot, log in as administrator locally b) checked eventviewer, no error/warning msg that stand out to me c) turn off symantec antivirus d) download windows installer 4.5 (WindowsXP-KB942288-v3-x86.exe   - install it locally   - run as administrator to install All the above steps seems not working, I am kind of out of idea.  Could some on please kindly help out.  All I need is the 2008 management studio and profiler install on my PC.  thank you, Ted.  
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend