Multi-Threading issue with SQL Server

classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Multi-Threading issue with SQL Server

Roger Bellegarde
Hello all,

Having an issue where queries sent to a Microsoft SQL server appear to be single threaded.
When using a previous ODBC manager (progress odbc)  the queries were processing 
multi-threaded

My setup is as follows:

UNIXODBC 
Oracle DG4ODBC Gateway
Microsoft SQL Server for Linux

Are there any switches/options at the UNIXODBC Layer that control this behavior?

thanks in advance


_______________________________________________
unixODBC-support mailing list
[hidden email]
http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Multi-Threading issue with SQL Server

Nick Gorham-2
On 10/01/15 12:57, Roger Bellegarde wrote:
Hello all,

Having an issue where queries sent to a Microsoft SQL server appear to be single threaded.
When using a previous ODBC manager (progress odbc)  the queries were processing 
multi-threaded

My setup is as follows:

UNIXODBC 
Oracle DG4ODBC Gateway
Microsoft SQL Server for Linux

Are there any switches/options at the UNIXODBC Layer that control this behavior?

thanks in advance

Depends on the version of unixODBC. Many years ago it would single thread the calls, but the defaut has been not to do that for some time.

Are you sure the change is not caused by the driver instead of the driver manager?

--
Nick





_______________________________________________
unixODBC-support mailing list
[hidden email]
http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support


_______________________________________________
unixODBC-support mailing list
[hidden email]
http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Multi-Threading issue with SQL Server

Roger Bellegarde
That's just what I was wondering but I cannot find any good info on the Microsoft SQL Linux driver as far as what switches I can put in the odbc.ini.....do you have any experience with that? Is there a parallel=yes option?   

Here is what I have in the odbcinst.ini

[SQL Server Native Client 11.0]
Description=Microsoft SQL Server ODBC Driver V1.0 for Linux
Driver=/opt/microsoft/sqlncli/lib64/libsqlncli-11.0.so.1790.0
Threading=0
UsageCount=1 



From: Nick Gorham <[hidden email]>
To: [hidden email]
Sent: Sunday, January 11, 2015 6:18 AM
Subject: Re: [unixODBC-support] Multi-Threading issue with SQL Server



On 10/01/15 12:57, Roger Bellegarde wrote:
Hello all,

Having an issue where queries sent to a Microsoft SQL server appear to be single threaded.
When using a previous ODBC manager (progress odbc)  the queries were processing 
multi-threaded

My setup is as follows:

UNIXODBC 
Oracle DG4ODBC Gateway
Microsoft SQL Server for Linux

Are there any switches/options at the UNIXODBC Layer that control this behavior?

thanks in advance

Depends on the version of unixODBC. Many years ago it would single thread the calls, but the defaut has been not to do that for some time.

Are you sure the change is not caused by the driver instead of the driver manager?

--
Nick





_______________________________________________
unixODBC-support mailing list
[hidden email]
http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support


_______________________________________________
unixODBC-support mailing list
[hidden email]
http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support



_______________________________________________
unixODBC-support mailing list
[hidden email]
http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Multi-Threading issue with SQL Server

Nick Gorham-2
On 11/01/15 14:17, Roger Bellegarde wrote:
That's just what I was wondering but I cannot find any good info on the Microsoft SQL Linux driver as far as what switches I can put in the odbc.ini.....do you have any experience with that? Is there a parallel=yes option?   

Here is what I have in the odbcinst.ini

[SQL Server Native Client 11.0]
Description=Microsoft SQL Server ODBC Driver V1.0 for Linux
Driver=/opt/microsoft/sqlncli/lib64/libsqlncli-11.0.so.1790.0
Threading=0
UsageCount=1

I can't say. I dont know of any. That ini setup should certainly not add any serialisttion in the driver manager. It is worth noting that the TDS protocol that SQL Server uses is at its simplistic not parallel, only one active statement is allowed at once. The Easysoft driver allows MARS (Multiple active results sets) to be enabled in the same was a the MS driver on windows does. I dont know if the MS driver on linux does this or not.

--
Nick

_______________________________________________
unixODBC-support mailing list
[hidden email]
http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Multi-Threading issue with SQL Server

Mike

Quoting Nick Gorham <[hidden email]>:

> On 11/01/15 14:17, Roger Bellegarde wrote:
>> That's just what I was wondering but I cannot find any good info on  
>> the Microsoft SQL Linux driver as far as what switches I can put in  
>> the odbc.ini.....do you have any experience with that? Is there a  
>> parallel=yes option?
>>
>> Here is what I have in the odbcinst.ini
>>
>> [SQL Server Native Client 11.0]
>> Description=Microsoft SQL Server ODBC Driver V1.0 for Linux
>> Driver=/opt/microsoft/sqlncli/lib64/libsqlncli-11.0.so.1790.0
>> Threading=0
>> UsageCount=1
>
> I can't say. I dont know of any. That ini setup should certainly not  
> add any serialisttion in the driver manager. It is worth noting that  
> the TDS protocol that SQL Server uses is at its simplistic not  
> parallel, only one active statement is allowed at once. The Easysoft  
> driver allows MARS (Multiple active results sets) to be enabled in  
> the same was a the MS driver on windows does. I dont know if the MS  
> driver on linux does this or not.


This implies that it can do that:

http://technet.microsoft.com/en-us/library/hh568445%28v=sql.110%29.aspx

Here is another reference.

https://blog.afoolishmanifesto.com/posts/install-and-configure-the-ms-odbc-driver-on-debian/

Hopefully that will get you moving in the rigt direction.

Please report back what you find.

Mike B.
_______________________________________________
unixODBC-support mailing list
[hidden email]
http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support
Loading...