Click here to Skip to main content
14,872,699 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Hello all,

I am having one big issue in our production server.
From last 3 days our application is not working correctly, server is behaving too badly.

Let me expalain in detail

Production Server Details.
Actual Ram 28 GB
64 bit
2.26GHZ 2 Processors

Usage History
Physical Memory utilized 21.8 gB
CPu Uasage 20 to 50%

Total Databases Running
Nearly 5

Our client is saying only your application is not working other than that whatever is there its working.
Our system is live and its been 1 year.
After 1 year we are facing this issue.

Sometimes users are not able to perform complex queries.

Last time we restarted server everything started working but again after 6 hours we had similar issue.

Somebody please help.
I will answer all your question.

Regards,
SUNIL MALI.
Posted

1 solution

We can't even begin to answer that from that: we have absolutely no idea what you are doing.
Especially when you say "Total Databases Running: Nearly 5" which is plain silly.

You need to look at what you code is doing, what queries it is running, where it is running. If it is running on the same server as the database, then it could be that it is just hoggin memory because you aren't releasing things, or you could be not Disposing on scarce resources just as Graphics contexts and Database Command objects - we can't tell without looking in good detail at your application.

I'd start by running it in your development environment and duplicating the problem - because until then you can't be sure you'd fixed it anyway!
   
Comments
sunil mali 24-Mar-14 2:29am
   
Hi Sir,

Sorry for Wrong Statement Its Total Server Running 5 databases.
Below that i gave my server configruation to check if something wrong with server.

I get timeout error whenever there is complex query gets executed.
My App server and DB Server is seprate.

internal static DataSet ExecuteDataSet(string CommandText, CommandType CommandType, SqlParameter[] SqlParam)
{
try
{
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString))
{
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter();
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.CommandText = CommandText;
cmd.CommandType = CommandType;
//cmd.Transaction = trans;

if (CommandType == System.Data.CommandType.StoredProcedure)
{
if (SqlParam != null)
{
foreach (SqlParameter param in SqlParam)
{
cmd.Parameters.Add(param);
}
}

}

da.SelectCommand = cmd;
da.Fill(ds);
}

return ds;
}

}
catch (Exception ex)
{
ex.Message.ToString();
return null;
}
finally
{
}
}
sunil mali 24-Mar-14 2:30am
   
Is there somethng i need to do with this.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900