Websites were facing 503 error. Memory Leak Problem.

My websites were facing 503 error. It seems to be due to the overcrowding of the application pool.

{

public MyFunction()

{

//

// TODO: Add constructor logic here

//

}

public static string ConnectionString

{

get

{

try

{

return System.Configuration.ConfigurationManager.ConnectionStrings["MyConnection"].ConnectionString;

}

catch (Exception ex)

{

throw new ApplicationException("Unable to get Database Connection string from Web Config File");

}

}

}

public static string Execute(string query)

{

try

{

int ret = 0;

SqlConnection con = new SqlConnection(Database.ConnectionString);

con.Open();

SqlCommand cmd = new SqlCommand(query, con);

ret = cmd.ExecuteNonQuery();

con.Close();

return ret.ToString();

}

catch (Exception ex)

{

return ex.Message.ToString();

}

}

public static string GenerateOTP(int length, string is_alpha_numeric)

{

string otp = "";

try

{

string alphabets = "ABCDEFGHIJKLMNOPQRSTUVWXYZ";

string small_alphabets = "abcdefghijklmnopqrstuvwxyz";

string numbers = "1234567890";

string characters = numbers;

if (is_alpha_numeric == "1")

{

characters += alphabets + small_alphabets + numbers;

}

//int length = int.Parse(ddlLength.SelectedItem.Value);

otp = string.Empty;

for (int i = 0; i < length; i++)

{

string character = string.Empty;

do

{

int index = new Random().Next(0, characters.Length);

character = characters.ToCharArray()[index].ToString();

} while (otp.IndexOf(character) != -1);

otp += character;

}

}

catch (Exception ex)

{

}

return otp;

}

}