Re: Sql Server connection timeout problem

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Thanks alot..the article is very helpful..

"William Vaughn" wrote:

This question has been asked and answered a thousand times so there are lots
of other sources to draw upon.
I also answered it so often I wrote a whitepaper on the subject and included
it in my book. See
http://betav.com/blog/billva/2007/05/managing_and_monitoring_net_co.html

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

"ads" <ads@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:65247081-B0BD-476E-B717-DF5F2BC02BA3@xxxxxxxxxxxxxxxx
im experiencing connection timeout in SQLSERVER2000 when using my web
application. It seems the database connection pool has been reached. Im
using
microsoft application block sqlhelper to connect to the database. A
temporary
solution is to increase the connection timeout and/or increase the
database
pool but i want to understand the root of the problem. This problem maybe
due
to many sql connection not being closed in the web app or there is an
error
in the sql query.

Is it true that sqlhelper.executereader doesnt close sql connection?

What about sqlhelper.executescalar ,executenonquery,executedataset?

Whenever i insert this code: SqlConnection conn = new
SqlConnection(System.Configuration.ConfigurationManager.AppSettings["connectionString"])
to pages which need to connect to database, does this add a connection to
the
database pool whenever the page load is executed?

i want to keep sql connection object minimum as possible so the database
pool will not be reached.

Please point me to the right direction.

Thanks,
Ads


.

Relevant Pages

  • Re: Sql Server connection timeout problem
    ... and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) ... It seems the database connection pool has been reached. ... Is it true that sqlhelper.executereader doesnt close sql connection? ...
    (microsoft.public.sqlserver.connect)
  • RE: Restored to New server and cannot logon to STS_Config
    ... > The Application Pools user is "Network Services" ... > the database access tab. ... you must first determine the application pool identity. ... Right-click the virtual server that is running Windows SharePoint ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Access Databases & IIS 6.0
    ... PID to Application Pool." ... You don't need to reboot the server. ... I administer a Windows Server 2003 running IIS 6. ... Unable to establish connection to database. ...
    (microsoft.public.inetserver.iis.security)
  • Re: Oracle Performance -- Possible Disk Bottleneck
    ... have a disk bottleneck here. ... The DBA was aware of a problem with a particular ... unnecessary thrashing in the default pool due to those objects. ... application and database schema design problems. ...
    (comp.databases.oracle.server)
  • Re: Ive about had it with WSS!
    ... Sharepoint went down on our main server, I fought with that for 2 days ... "Unable to connect to database. ... Make sure the account for the application pool has appropriate ...
    (microsoft.public.sharepoint.windowsservices)