Question about SQL Profiler | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Question about SQL Profiler

I have a question for all of you. While I was tracing in sql profiler
an event class in green which is "Disconnect" , "ExistingConnection","Connect" appeared
but the time of duration is
too long like 100000 milli seconds or more and the
program is a data entry program that use like 30 people simultaneously making querys
every second to the same table but I am using Ado querys to make my querys
but what I don’t understand is that the event classes for disconnection are that
I don’t know if this is a network problem or if the sql server is the problem. What
should I check?
What you’re seeing is a lack of ADO connection pooling, you can read all about it and how to benefit from connection pooling in this article : Cheers
Shaun World Domination Through Superior Software