Biztalk 2004 & SQL

20 Jan 2006 7:30 AM

Johnson

I have some questions about how to determine if my Biztalk 2004 is using
connection pooling or not. Also, I would like to determine if the Microsoft
Biztalk 2004 application uses OLE DB, or ODBC for its connection to SQL
Server 2000.

Also, how can I trace the info or statistics?

Thanks for any suggestions!

20 Jan 2006 8:11 AM

John Bell

Hi

SQL Profiler will give you this, if this is not in the SQL Server program
group you can find it in the Tools\Binn\profiler.exe. Check for different
commands on the same SPID from different users.

John

Show quote

"Johnson" wrote:

> I have some questions about how to determine if my Biztalk 2004 is using
> connection pooling or not. Also, I would like to determine if the Microsoft
> Biztalk 2004 application uses OLE DB, or ODBC for its connection to SQL
> Server 2000.
>
> Also, how can I trace the info or statistics?
>
> Thanks for any suggestions!
>
>
>
>