SQL Server Performance Forum – Threads Archive
Question about SQL Profiler
I have a question for all of you. While I was tracing in sql profileran 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 : http://www.sql-server-performance.com/bl_asp_ado.asp Cheers
Shaun World Domination Through Superior Software
]]>