[Asp.Net 질문] Timeout expired 관련 에러[긴급]

[멋쥔넘]

잘 모르는 부분의 에러 라서여..고수님들 부탁 드립니다.
Timeout expired 관련 해서 아래와 같은 에러가 발생하였습니다.

에러 형성 시간대는 오전 새벽녁에 5~9시 사이에 는 거의 안되는거 같구요

그외에는 낮시간대에는 아무 이상없는듯 합니다.

가끔 아래와 같은 메세지가 나타 나구요..

원이 분석이 안되어 답답할 따름입니다.

고수님들 해결 방법을 아시는 분은 리플 부탁 드리겠습니다.

ㅠ.ㅜ. DB 관련 에러인지.요... 부탁 부탁...


==========================================================================

Server Error in '/web' Application.
--------------------------------------------------------------------------------

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.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidOperationException: 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.

Source Error:


Line 363: // Create and fill a DataSet.
Line 364: DataSet ds = new DataSet();
Line 365: objAdapter.Fill(ds,"M_CATEGORY_S");
Line 366:
Line 367: DataList1.DataSource = ds.Tables["M_CATEGORY_S"];


Source File: C:\Inetpub\wwwroot\S_web\page1.aspx.cs Line: 365

Stack Trace:


[InvalidOperationException: 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.]
System.Data.SqlClient.SqlConnection.Open() +761
System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState) +44
System.Data.Common.DbDataAdapter.Fill(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +98
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +77
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +36
New_skt.WebForm1.Set_Cate() in C:\Inetpub\wwwroot\S_web\page1.aspx.cs:365
New_skt.WebForm1.Page_Load(Object sender, EventArgs e) in C:\Inetpub\wwwroot\S_web\page1.aspx.cs:210
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +29
System.Web.UI.Page.ProcessRequestMain() +724

[박진언]

일단 의심나는 건 connection을 close 및 dispose 를 꼭 해줘야 한다는 것이구여 물론 .net pool 오바로링을 하지만 꼭 close 혹은 dispose를 해주는게 좋습니다.