limit on sp's through an odbc connection

To all the gurus,
Is there a limit on the number of queries that can be run through an
odbc connection to another SQL server?
The primary server is running abinitio to query a sql server.
When we run the set of sps that is needed the server essetially grind to
a halt...
thanx
Bill
*** Sent via Developersdex http://www.codecomments.com ***ok how about this one,
is there a limit on the number of threads that can be used on one odbc
source?
Bill
*** Sent via Developersdex http://www.codecomments.com ***|||Does this article from MSoft help you at all...
http://msdn2.microsoft.com/en-us/library/ms187024.aspx
Should help you get the Maximum out of worker threads.
thanks,
/*
Warren Brunk - MCITP - SQL 2005, MCDBA
www.techintsolutions.com
*/
"Bill" <nospam@.devdex.com> wrote in message
news:ustGql01GHA.4924@.TK2MSFTNGP05.phx.gbl...
> ok how about this one,
> is there a limit on the number of threads that can be used on one odbc
> source?
>
> Bill
>
> *** Sent via Developersdex http://www.codecomments.com ***|||Bill,
Regarding this:
>When we run the set of sps that is needed the server essetially grind to
>a halt...
My question is what diagnostics, monitoring were done to
determine that this was related to some type of limits on
connections? That would really be the starting point -
monitoring where the bottlenecks are, monitoring for
locking/blocking issues, what's going on in SQL Server when
these are run, etc. Were those done?
-Sue
On Wed, 13 Sep 2006 07:29:56 -0700, Bill <nospam@.devdex.com>
wrote:

>To all the gurus,
>Is there a limit on the number of queries that can be run through an
>odbc connection to another SQL server?
>The primary server is running abinitio to query a sql server.
>When we run the set of sps that is needed the server essetially grind to
>a halt...
>
>thanx
>Bill
>
>*** Sent via Developersdex http://www.codecomments.com ***|||Mr. Brunk,
thank you very much
this answered my question totally
BillO
*** Sent via Developersdex http://www.codecomments.com ***