Hello everyone.

I am having the error message when i am trying to open a sertan page from my web application:
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
It happance only when i am running something from the query window or a lot of users using the web application. Is there are the way to improve performance of the SQL server so it will be capable to process any critical sytuations or tell me please how to get read of this message.

Here is the actual message:

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

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
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.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.]
System.Data.SqlClient.SqlCommand.ExecuteReader(Com mandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +723
System.Data.SqlClient.SqlCommand.ExecuteReader(Com mandBehavior behavior) +45
System.Data.SqlClient.SqlCommand.System.Data.IDbCo mmand.ExecuteReader(CommandBehavior behavior) +5
System.Data.Common.DbDataAdapter.FillFromCommand(O bject data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +304
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) +38
GMI.DataAccessLayer.SQLCommandAndDataSet.ExecuteAn dFill(Boolean a_bPreserveCommandObject) +136
GMI.DataAccessLayer.DataAccessLayer.GetFirstAnalys ts() +72
GMI.Intranet.DataEntry.AnalystProgress.Page_Load(O bject sender, EventArgs e) +318
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +731




Thank you wery much in advence.

Greg