[freetds] latest FreeTDS on Centos 6.4 and latest SQL Server DB

[Nunzio Luigi Puleio]

Hello everyone!

I have CentOS 6.4 64bit webserver and a SQL Server 2008 DB.
I communicate with SQL Server with unixODBC but looks like it's not really
performant.
So I tried to set in odbc.ini TDS_Version = 9.0 and it started to be a bit
more performant.
BUT since doing tsql -C I see TDS Version as 4.2 so I guess it isn't really
performant so I am here asking you if to be more performant shall I have to
do makefile with latest freetds sources with patrameter --with-tdsver=
*VER *settled as 7.2 ?

Thanks in advance.
Cheers,
Luigi

[Frediano Ziglio]

Post by Nunzio Luigi Puleio
Hello everyone!
I have CentOS 6.4 64bit webserver and a SQL Server 2008 DB.
I communicate with SQL Server with unixODBC but looks like it's not really
performant.
So I tried to set in odbc.ini TDS_Version = 9.0 and it started to be a bit
more performant.

9.0 ?? See http://www.freetds.org/userguide/choosingtdsprotocol.htm, you
are using really old documentation.
Performant doing what? Do you have many connection? Usually is the problem
of web servers. Many web servers have support for connection caching. See
unixODBC documentation too.

Post by Nunzio Luigi Puleio
BUT since doing tsql -C I see TDS Version as 4.2 so I guess it isn't really
performant so I am here asking you if to be more performant shall I have to
do makefile with latest freetds sources with patrameter --with-tdsver=
*VER *settled as 7.2 ?

There are many way to override default protocol version. For ODBC you can
use connection string, if you are using a DSN configuration set the right
attribute.

Post by Nunzio Luigi Puleio
Thanks in advance.
Cheers,
Luigi

Frediano

[Nunzio Luigi Puleio]

Hello Frediano,

thanks for your answer.
Well, first I have Centos 6.4 Final x86_64, Freetds x86_64 installed
version 0.91-2.el6, unixODBC 2.2.14-12.el6_3, php 5.3.3 and settled for my
purpose:

in freetds.conf

[global]
tds version = 9.0

[MSSQLDBGateway]
host = X.X.X.X
port = 1433
tds version = 9.0

and in odbc.ini

[MSSQLDBGateway]
Driver = FreeTDS
#Server = X.X.X.X
Servername = MSSQLDBGateway
Port = 1433
Database = xxxx
TDS_Version = 9.0

and in odbcinst.ini this:

[FreeTDS]
Description = ODBC for SQL Server
Driver = /usr/lib64/libtdsodbc.so.0
Setup = /usr/lib64/libtdsS.so.0
UsageCount = 1
FileUsage = 1

when I settled tds version 7.2 or 8.0, performance with SQL Server 2008
communication was poor then I tried to set 9.0 as it said here:

TDS 7.2 Microsoft, *was* 9.0

Introduced for SQL Server 2005. Includes support for varchar(max),
varbinary(max), xml datatypes and MARS.
then it improved a bit.
Maybe I missed something?

Thanks
Cheers
Luigi

Post by Nunzio Luigi Puleio

Post by Nunzio Luigi Puleio
Hello everyone!
I have CentOS 6.4 64bit webserver and a SQL Server 2008 DB.
I communicate with SQL Server with unixODBC but looks like it's not

really

Post by Nunzio Luigi Puleio
performant.
So I tried to set in odbc.ini TDS_Version = 9.0 and it started to be a

bit

Post by Nunzio Luigi Puleio
more performant.

9.0 ?? See http://www.freetds.org/userguide/choosingtdsprotocol.htm, you
are using really old documentation.
Performant doing what? Do you have many connection? Usually is the problem
of web servers. Many web servers have support for connection caching. See
unixODBC documentation too.

Post by Nunzio Luigi Puleio
BUT since doing tsql -C I see TDS Version as 4.2 so I guess it isn't

really

Post by Nunzio Luigi Puleio
performant so I am here asking you if to be more performant shall I have

to

Post by Nunzio Luigi Puleio
do makefile with latest freetds sources with patrameter --with-tdsver=
*VER *settled as 7.2 ?

There are many way to override default protocol version. For ODBC you can
use connection string, if you are using a DSN configuration set the right
attribute.

Post by Nunzio Luigi Puleio
Thanks in advance.
Cheers,
Luigi

Frediano
_______________________________________________
FreeTDS mailing list
FreeTDS at lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds

[James K. Lowden]

On Mon, 18 Aug 2014 12:09:37 +0200

Post by Nunzio Luigi Puleio
when I settled tds version 7.2 or 8.0, performance with SQL Server

I suspect any performance changes you observed by changing the version
of the TDS protocol were by chance.

As Frediano mentioned, you can use TDSVER to control what version is
used, http://www.freetds.org/userguide/envvar.htm. No need to
recompile.

--jkl

[Nunzio Luigi Puleio]

hello everyone!

TDSVER was ok settled as 8.0. At the end we've found the problem: corrupted
network card drivers which made bottlenecks during packet trasmission and
receiving and now the problem disappeared with a new virtual machine with
latest network card drivers compiled and installed.
Thanks anyway to all!

Cheers,
Luigi



On Tue, Aug 19, 2014 at 1:53 PM, James K. Lowden <jklowden at freetds.org>

Post by James K. Lowden
On Mon, 18 Aug 2014 12:09:37 +0200

Post by Nunzio Luigi Puleio
when I settled tds version 7.2 or 8.0, performance with SQL Server

I suspect any performance changes you observed by changing the version
of the TDS protocol were by chance.
As Frediano mentioned, you can use TDSVER to control what version is
used, http://www.freetds.org/userguide/envvar.htm. No need to
recompile.
--jkl
_______________________________________________
FreeTDS mailing list
FreeTDS at lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds