Memory gates checking failed because the free memory (485363712 bytes) is less than 5% of total memory.  As a result, the service will not be available for incoming requests.  To resolve this, either reduce the load on the machine or adjust the value of minFreeMemoryPercentageToActivateService on the serviceHostingEnvironment config element.
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.InsufficientMemoryException: Memory gates checking failed because the free memory (485363712 bytes) is less than 5% of total memory.  As a result, the service will not be available for incoming requests.  To resolve this, either reduce the load on the machine or adjust the value of minFreeMemoryPercentageToActivateService on the serviceHostingEnvironment config element.

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:


[InsufficientMemoryException: Memory gates checking failed because the free memory (485363712 bytes) is less than 5% of total memory.  As a result, the service will not be available for incoming requests.  To resolve this, either reduce the load on the machine or adjust the value of minFreeMemoryPercentageToActivateService on the serviceHostingEnvironment config element.]
   System.ServiceModel.Activation.ServiceMemoryGates.Check(Int32 minFreeMemoryPercentage, Boolean throwOnLowMemory, UInt64& availableMemoryBytes) +58980
   System.ServiceModel.HostingManager.CheckMemoryCloseIdleServices(EventTraceActivity eventTraceActivity) +95
   System.ServiceModel.HostingManager.EnsureServiceAvailable(String normalizedVirtualPath, EventTraceActivity eventTraceActivity) +584

[ServiceActivationException: The service '/MainService.svc' cannot be activated due to an exception during compilation.  The exception message is: Memory gates checking failed because the free memory (485363712 bytes) is less than 5% of total memory.  As a result, the service will not be available for incoming requests.  To resolve this, either reduce the load on the machine or adjust the value of minFreeMemoryPercentageToActivateService on the serviceHostingEnvironment config element..]
   System.Runtime.AsyncResult.End(IAsyncResult result) +495736
   System.ServiceModel.Activation.HostedHttpRequestAsyncResult.End(IAsyncResult result) +178
   System.ServiceModel.Activation.ServiceHttpModule.EndProcessRequest(IAsyncResult ar) +348782
   System.Web.AsyncEventExecutionStep.OnAsyncEventCompletion(IAsyncResult ar) +9663393

public List<GetAllUser> GetAllUsers(int id)
        {
            using (SqlConnection sqConn = new SqlConnection(ConfigurationManager.ConnectionStrings["VSMconnection"].ConnectionString))
            {
                List<GetAllUser> Data = new List<GetAllUser>();
                sqConn.Open();
                SqlCommand cmd = new SqlCommand();
                cmd.Connection = sqConn;
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.CommandText = "[Web].[GetAllPersons]";
                cmd.Parameters.AddWithValue("@Id", id);
                SqlDataReader sdr = null;
                sdr = cmd.ExecuteReader();

                while (sdr.Read())
                {
                    var GetData = new GetAllUser
                    {
                        UserLog = sdr["Email"].ToString(),
                        UserAllName = sdr["Name"].ToString()
                    };
                    Data.Add(GetData);
                }
                sdr.Close();
                sqConn.Close();
                return Data;
            }