



» Title: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool.
» Posted: July 31st, 2008
» Author: dedi
» Filed Under: Celoteh Harian, Reviews.
» There are 2 responses.
» Read comments, respond or follow responses via RSS.
» Trackback this entry.


















The opinions expressed herein are my own personal opinions and do not represent anyone else's view in any way, including those of my employer.
© Copyright 2008





wow…. a few days ago, i had this problems, some doman on server have some error like this,
first, i think this is just because some sql service still stuck, i don’t know why…but then after i check on event viewer, i have this error messages “Starting up database ‘ReportServer$SQLExpressTempDB’.”
wolaaa… akirnya dengan terus berusaha mencari beberapa keterangan referensi dari om GooGle[dot]CoM ada beberapa penjelasan yang pada akhirnya cukup menjadi bukti bahwa hal tersebut bukan dikarenakan service mssql yg stuck…Hal tersebut dikarenakan adanya pool koneksi yg berlebih, dimana yang seharusnya tidak boleh terjadi, karena membuka koneksi persisten secara terus menerus, side effect nya pool koneksi jadi penuh sehingga website tersebut tidak bisa diakses dan muncul keterangan error seperti pada judul di atas yaitu “Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool.
This may have occurred because all pooled connections were in use and max pool size was reached.”
-HosH- Finally, resolution is only to closing connection object, thats it.
Fix connection string and destroy the connection object conn.Dispose();
that’s it
or you can follow this link to see how it works….and will help you more to know….
blog msdn how to avoid max pool reached
or this link using connection pool with sql server
hehe…ini kejadian beberapa hari yang lalu…semoga dapat membantu anda smua…akhirnya..setelah diperbaiki, website berjalan dengan normal… tidak ada gangguan apapun..
Regards

Tags: asp .NET, connection string, MSSQL, mssql database server, ODBC, plesk, pool connection, SQL Server 2005, windows, windows 2003 server
More Options ...

Categories
Tag Cloud
Blog RSS
Comments RSS


Void (Default)
Life
Earth
Wind
Water
Fire
Lightweight

5:48 am - August 6th, 2008
haeuhuaheuiaheuiah euiaheui aheuh auiehuia ehuiaehuiaheiahe .. aku cuman ngguyu fotomu sing narsis :p
12:20 pm - August 17th, 2008
widih bisa aja nih… suka merendah gitu..
wehehe..
=D