MS SQL Server ODBC - Re: limit on sp's through an odbc connection

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Re: limit on sp's through an odbc connection

Sue Hoegemeier

2006-10-24, 6:40 pm

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.droptable.com ***

Sponsored Links