server is too busy 是什么原因啊 急死了 ~~

[程序漫步]

server is too busy 是什么原因啊 急死了 ~~

是程序问题，，还是 服务器问题~

[zyug]

把应用程序池设置一下吧
cpu占用多少的时候回收一下，然后再检测一下代码问题，通常都能找到某一段.

[程序漫步]

程序池 怎么设置


cpu占用多少的时候回收一下 怎么讲 给个实现的方式~~~

[jasondct]

就是 服务器忙啊 。
是你的 写入 内存 或连接池的 连接 没有关闭。 或者是反复读取数据而有死锁

[程序漫步]

顶器·~~~~

[程序漫步]

我发些代码给大家看，，，好多天，我没办法，，希望大家能给些建议

/*自动生成类
 *生成日期：2009-5-12
 */
using System;
using System.Data;
using System.Data.SqlClient;

namespace Data
{
	public class DeputyLog:CSBase.DataRead.DataBase
	{
		public DeputyLog()
		{
		}
		public int DelDeputyLog(int deputyLogId)
		{
			int rowsAffected;
			SqlParameter[] parameters=
			{
				new SqlParameter("@DeputyLogId",SqlDbType.Int,4),
			};
			parameters[0].Value = deputyLogId;
			return RunProcedure("how_delDeputyLog",parameters,out rowsAffected);
		}
		public int InsDeputyLog(string memberNo,string addMoney,string byMoney,string inputer,string content,DateTime sendTime)
		{
			int rowsAffected;
			SqlParameter[] parameters=
			{
				new SqlParameter("@MemberNo",SqlDbType.VarChar,50),
				new SqlParameter("@AddMoney",SqlDbType.VarChar,100),
				new SqlParameter("@ByMoney",SqlDbType.VarChar,100),
				new SqlParameter("@Inputer",SqlDbType.VarChar,50),
				new SqlParameter("@Content",SqlDbType.VarChar,500),
				new SqlParameter("@SendTime",SqlDbType.DateTime,8),
			};
			parameters[0].Value = memberNo;
			parameters[1].Value = addMoney;
			parameters[2].Value = byMoney;
			parameters[3].Value = inputer;
			parameters[4].Value = content;
			parameters[5].Value = sendTime;
			return RunProcedure("how_insDeputyLog",parameters,out rowsAffected);
		}
		public int InsDeputyLogByAdd(string memberNo,string addMoney,string byMoney,string inputer,string content)
		{
			int rowsAffected;
			SqlParameter[] parameters=
			{
				new SqlParameter("@MemberNo",SqlDbType.VarChar,50),
				new SqlParameter("@AddMoney",SqlDbType.VarChar,100),
				new SqlParameter("@ByMoney",SqlDbType.VarChar,100),
				new SqlParameter("@Inputer",SqlDbType.VarChar,50),
				new SqlParameter("@Content",SqlDbType.VarChar,500),
			};
			parameters[0].Value = memberNo;
			parameters[1].Value = addMoney;
			parameters[2].Value = byMoney;
			parameters[3].Value = inputer;
			parameters[4].Value = content;
			return RunProcedure("how_insDeputyLogByAdd",parameters,out rowsAffected);
		}
		public DataTable SelDeputyLogByAll()
		{
			SqlParameter[] parameters=
			{
			};
			return RunProcedure("how_selDeputyLogByAll",parameters);
		}
		public DataTable SelDeputyLogByDeputyLogId(int deputyLogId)
		{
			SqlParameter[] parameters=
			{
				new SqlParameter("@DeputyLogId",SqlDbType.Int,4),
			};
			parameters[0].Value = deputyLogId;
			return RunProcedure("how_selDeputyLogByDeputyLogId",parameters);
		}
		public DataTable SelDeputyLogByMemberNoPageSize(string memberNo,int cureId,int pageSize,int pageIndex)
		{
			SqlParameter[] parameters=
			{
				new SqlParameter("@MemberNo",SqlDbType.VarChar,50),
				new SqlParameter("@CureId",SqlDbType.Int,4),
				new SqlParameter("@PageSize",SqlDbType.Int,4),
				new SqlParameter("@PageIndex",SqlDbType.Int,4),
			};
			parameters[0].Value = memberNo;
			parameters[1].Value = cureId;
			parameters[2].Value = pageSize;
			parameters[3].Value = pageIndex;
			return RunProcedure("how_selDeputyLogByMemberNoPageSize",parameters);
		}
		public DataTable SelDeputyLogByMemberNoPageSizeCount(string memberNo)
		{
			SqlParameter[] parameters=
			{
				new SqlParameter("@MemberNo",SqlDbType.VarChar,50),
			};
			parameters[0].Value = memberNo;
			return RunProcedure("how_selDeputyLogByMemberNoPageSizeCount",parameters);
		}
		public DataTable SelDeputyLogByMemberNoPageSizePageIndex(string memberNo,int pageSize,int pageIndex)
		{
			SqlParameter[] parameters=
			{
				new SqlParameter("@MemberNo",SqlDbType.VarChar,25),
				new SqlParameter("@PageSize",SqlDbType.Int,4),
				new SqlParameter("@PageIndex",SqlDbType.Int,4),
			};
			parameters[0].Value = memberNo;
			parameters[1].Value = pageSize;
			parameters[2].Value = pageIndex;
			return RunProcedure("how_selDeputyLogByMemberNoPageSizePageIndex",parameters);
		}
		public int UpdDeputyLog(int deputyLogId,string memberNo,string addMoney,string byMoney,string inputer,string content,DateTime sendTime)
		{
			int rowsAffected;
			SqlParameter[] parameters=
			{
				new SqlParameter("@DeputyLogId",SqlDbType.Int,4),
				new SqlParameter("@MemberNo",SqlDbType.VarChar,50),
				new SqlParameter("@AddMoney",SqlDbType.VarChar,100),
				new SqlParameter("@ByMoney",SqlDbType.VarChar,100),
				new SqlParameter("@Inputer",SqlDbType.VarChar,50),
				new SqlParameter("@Content",SqlDbType.VarChar,500),
				new SqlParameter("@SendTime",SqlDbType.DateTime,8),
			};
			parameters[0].Value = deputyLogId;
			parameters[1].Value = memberNo;
			parameters[2].Value = addMoney;
			parameters[3].Value = byMoney;
			parameters[4].Value = inputer;
			parameters[5].Value = content;
			parameters[6].Value = sendTime;
			return RunProcedure("how_updDeputyLog",parameters,out rowsAffected);
		}
	}
}

[程序漫步]

using System;
using System.Data;
using System.Data.SqlClient;
using System.IO;
using System.Configuration;

namespace CSBase.DataRead
{
	/// <summary>
	/// 数据层的基类
	/// </summary>
	public class DataBase
	{
		protected SqlConnection connection;
		private static string connectionString;
		private static Decimal lastAutoKey;

		public static string ConnectionString
		{
			get
			{
				return connectionString;
			}
			set
			{
				connectionString = value;
			}
		}
		public static Decimal LastAutoKey
		{
			get
			{
				return lastAutoKey;
			}
		}

		public DataBase()
		{
			//			connectionString = "server=(local);database=EEMCS_DB;uid=sa;pwd=etgate;";
			//connection = new SqlConnection(connectionString);
			//connection = new SqlConnection();
			connection = new SqlConnection();
			ConnectionString =  ConfigurationSettings.AppSettings["ConnectionString"];
		}

		public bool TestConnect()
		{
			try
			{
				connection.Open();
				connection.Close();
				return true;
			}
			catch
			{
				return false;
			}
		}

		private SqlCommand BuildIntCommand(string storedProcName, IDataParameter[] parameters)
		{
			SqlCommand command = BuildQueryCommand( storedProcName, parameters );			

			command.Parameters.Add( new SqlParameter ( "ReturnValue",
				SqlDbType.Int,
				4, /* Size */
				ParameterDirection.ReturnValue,
				false, /* is nullable */
				0, /* byte precision */
				0, /* byte scale */
				string.Empty,
				DataRowVersion.Default,
				null ));

			return command;
		}

		private SqlCommand BuildQueryCommand(string storedProcName, IDataParameter[] parameters)
		{
			SqlCommand command = new SqlCommand( storedProcName, connection );
			command.CommandType = CommandType.StoredProcedure;

			foreach (SqlParameter parameter in parameters)
			{
				command.Parameters.Add( parameter );
			}

			return command;
		}




		protected int RunProcedure(string storedProcName, IDataParameter[] parameters, out int rowsAffected )
		{
			try
			{
				connection.ConnectionString = connectionString;
				if (connection.State != ConnectionState.Closed)connection.Close();
				connection.Open();
				SqlCommand command = BuildIntCommand( storedProcName, parameters );
				rowsAffected = command.ExecuteNonQuery();
				lastAutoKey = Convert.ToDecimal(command.Parameters["ReturnValue"].Value);
				return rowsAffected;
			}
			catch (Exception e)
			{
				ErrorMessage.Message = e.Message;
				return rowsAffected= -1;
			}
			finally
			{
				if (connection.State == ConnectionState.Open)
					connection.Close();
			}
		}
		protected int RunProcedureScalar(string storedProcName, IDataParameter[] parameters)
		{
			try
			{
				int result;
				connection.ConnectionString = connectionString;
				connection.Open();
				SqlCommand command = BuildIntCommand( storedProcName, parameters );
				result = (int)command.ExecuteScalar();
				return result;
			}
			catch (Exception e)
			{
				ErrorMessage.Message = e.Message;
				return (int)DBOperateError.DBException;
			}
			finally
			{
				if (connection.State == ConnectionState.Open)
					connection.Close();
                     connection.Dispose();
			}
		}
		
		protected decimal RunProcedureRetrunValue(string storedProcName, IDataParameter[] parameters)
		{
			try
			{
				connection.ConnectionString = connectionString;
				connection.Open();
				SqlCommand command = BuildIntCommand( storedProcName, parameters );
				command.ExecuteNonQuery();
				lastAutoKey = Convert.ToDecimal(command.Parameters["ReturnValue"].Value);
				return lastAutoKey;
			}
			catch (Exception e)
			{			
				ErrorMessage.Message = e.Message;
				return (int)DBOperateError.DBException;
			}
			finally
			{
				if (connection.State == ConnectionState.Open)
					connection.Close();
			}
		}

        /// <summary>
        /// 执行增删改
        /// </summary>
        /// <param name="sqlString"></param>
        /// <param name="rowsAffected"></param>
        /// <returns></returns>
		private int RunProcedure(string sqlString,out int rowsAffected)
		{
			try
			{
				connection.ConnectionString = connectionString;
				connection.Open();
				SqlCommand command = new SqlCommand(sqlString,connection);
				rowsAffected = command.ExecuteNonQuery();
				return rowsAffected;
			}
			catch (Exception e)
			{
				ErrorMessage.Message = e.Message;
				return rowsAffected = -1;
			}
			finally
			{
				if (connection.State == ConnectionState.Open)
					connection.Close();
			}
		}


        /// <summary>
        /// SQL语句增删该
        /// </summary>
        /// <param name="sqlString"></param>
        /// <param name="rowsAffected"></param>
        /// <returns></returns>
        public static int Sql_Execute(string sqlString, params  SqlParameter [] pams)
        {
            SqlConnection connection = null;
            int i = 0;
            try
            {

                 connection = new SqlConnection(connectionString);
           
                connection.Open();
                SqlCommand command = new SqlCommand(sqlString, connection);
                if (pams != null)
                {
                    foreach (SqlParameter p in pams)
                    {
                        command.Parameters.Add(p);
                    }
                }
                
                 i=command.ExecuteNonQuery();
               
            }
            catch (Exception e)
            {
                ErrorMessage.Message = e.Message;
                i = -1;
               
            }
            finally
            {

                if (connection.State == ConnectionState.Open)
                    connection.Close();
            }
            return i;
        }
        /// <summary>
        /// 带存储
        /// </summary>
        /// <param name="storedProcName"></param>
        /// <param name="parameters"></param>
        /// <returns></returns>
		protected SqlDataReader RunProcedure_ReturnDataReader(string storedProcName, IDataParameter[] parameters )
		{
			try
			{
				SqlDataReader returnReader;
				connection.ConnectionString = connectionString;
				connection.Open();
				SqlCommand command = BuildQueryCommand( storedProcName, parameters );
				command.CommandType = CommandType.StoredProcedure;
				returnReader = command.ExecuteReader();
				return returnReader;
			}
			catch (Exception e)
			{
				ErrorMessage.Message = e.Message;
				return null;
			}
			finally
			{
				if (connection.State == ConnectionState.Open)
					connection.Close();
			}
		}





		protected DataSet RunProcedure(string storedProcName, IDataParameter[] parameters, string tableName )
		{
			try
			{
				DataSet dataSet = new DataSet();
				connection.ConnectionString = connectionString;
				connection.Open();
				SqlDataAdapter sqlDA = new SqlDataAdapter();
				sqlDA.SelectCommand = BuildQueryCommand( storedProcName, parameters );
				sqlDA.Fill( dataSet,tableName );
				return dataSet;
			}
			catch (Exception e)
			{
				ErrorMessage.Message = e.Message;
				return null;
			}
			finally
			{
				if (connection.State == ConnectionState.Open)
					connection.Close();
			}
		}