Go to Top

Are you having performance issues with SQL Server?

Lately I’ve been getting calls from people suffering from performance issues with SQL Server, in particular with the 2012 version.

My first question these days is: “Which SQL Server client are you using?”

ADVERTISING
ACCESS SAFETY AND TRAINING DATABASE

A good Access developer would know the answer to that question, but if you don’t, open control panel, Administrative Tools, ODBC Sources, either 32 or 64 bit and look at your DSN, (if you don’t use DSNs my hat off to you, just click on the Add button and look at the bottom of the list).

Here is what you should see:

ODBC32

Most people who have issues may be using the standard SQL Server driver that comes with Windows, which is a mistake, since you would be hampering your program’s performance.

Instead you want to install the newest SQL Server Native Client 11. The only drawback is that you would need to install the driver on all computers running your program. You will need to download the 64 or 32 bit version based on the version of Windows, NOT the version of Office. Here are the download links:

o   32 Bit: http://go.microsoft.com/fwlink/?LinkID=239647&clcid=0x409

o   64 Bit: http://go.microsoft.com/fwlink/?LinkID=239648&clcid=0x409

 

About Juan Soto

Juan Soto is a Senior Access Developer at IT Impact Inc. and a Microsoft Access MVP. He specializes in Access with SQL Server databases. His passion for Access has led him to helping a wide range of businesses in helping them establish a secure, stable and efficient environment with SQL Server. He's a frequent speaker at Access user groups nationwide and recently spoke at the Orange County SQL Saturday # 73. If you wish to have Juan speak at your next group meeting you can contact him here.

2 Responses to "Are you having performance issues with SQL Server?"

  • John Schuste
    August 30, 2014 - 9:37 pm Reply

    When writing applications using SQL Server as the back end do you prefer ODBC or OLEDB?

  • George Hepworth
    August 9, 2014 - 11:36 pm Reply

    Juan, I certainly agree it is preferred, but perhaps it’s not all that simple to accomplish in all cases. Depending on the size of the company and their IT policies, installing SNCL 11.0 on everyone’s desktop may or may not be a big deal.

    I have a question about the Microsoft ODBC Driver 11 for SQL Server. Where does it fit in your organization’s development efforts?

Leave a Reply

Your email address will not be published. Required fields are marked *

 

Contact Us
[gravityform id="16" title="false" description="false"]