SQL Performance Issue

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
{
}
}