sql server odbc: 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

ok how about this one,
is there a limit on the number of threads that can be used on one odbc
source?


Bill

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
*/


[quoted text, click to view]

Mr. Brunk,
thank you very much
this answered my question totally


BillO

Bill,
Regarding this:
[quoted text, click to view]
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>
[quoted text, click to view]