由于以下异常，无法生成模型:(资源池“default”中没有足够的系统内存来运行此查询。） [英] Unable to generate the model because of the following exception: (There is insufficient system memory in resource pool 'default' to run this query.)
问题描述
当我尝试更新我的datacontext时，我得到了这个输出;
由于以下异常，无法生成模型：'System.Data。 Entity.Core.EntityCommandExecutionException：执行命令定义时发生错误。有关详细信息，请参阅内部异常---> System.Data.SqlClient.SqlException：资源池'default'中没有足够的系统内存来运行此查询。
在System.Data.SqlClient.SqlConnection.OnError（SqlException异常，Boolean breakConnection，Action `1 wrapCloseInAction）
在System.Data.SqlClient.SqlInternalConnection.OnError（SqlException异常，Boolean breakConnection，Action`1 wrapCloseInAction）
在System.Data.SqlClient.TdsParser .ThrowExceptionAndWarning（TdsParserStateObject stateObj，Boolean callerHasConnectionLock，Boolean asyncClose）
在System.Data.SqlClient.TdsParser.TryRun（RunBehavior runBehavior，SqlCommand cmdHandler，SqlDataReader dataStream，BulkCopySimpleResultSet bulkCopyHandler，TdsParserStateObject stateObj，Boolean& dataReady）
在System.Data.SqlClient.SqlDataReader.TryConsumeMetaData（）
at System.Data.SqlClient.SqlDataReader.get_MetaData（）
at System .Data.SqlClient.SqlCommand.FinishExecuteReade r（SqlDataReader ds，RunBehavior runBehavior，String resetOptionsString）
在System.Data.SqlClient.SqlCommand.RunExecuteReaderTds（CommandBehavior cmdBehavior，RunBehavior runBehavior，Boolean returnStream，Boolean async，Int32 timeout，Task&在System.Data.SqlClient.SqlCommand.RunExecuteReader（CommandBehavior cmdBehavior，RunBehavior runBehavior，Boolean returnStream，String方法，TaskCompletionSource`1完成，Int32超时，任务和任务）中的任务，布局asyncWrite，SqlDataReader ds）
，Boolean asyncWrite）
在System.Data.SqlClient.SqlCommand.RunExecuteReader（CommandBehavior cmdBehavior，RunBehavior runBehavior，Boolean returnStream，String method）
在System.Data.SqlClient。 SqlCommand.ExecuteReader（CommandBehavior behavior，String method）
at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader（CommandBehavior behavior）
at System.Data.Common.DbCommand.ExecuteReader （CommandBehavior行为）
at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher。<> c__DisplayClassb。< reader> b__8（）
at System.Data .Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch [TInterceptionContext，TResult]（Func`1 operat ion，TInterceptionContext interceptionContext，Action`1执行，Action`1执行）
在System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.Reader（DbCommand命令，DbCommandInterceptionContext interceptionContext）
at System.Data.Entity.Internal.InterceptableDbCommand.ExecuteDbDataReader（CommandBehavior behavior）
at System.Data.Common.DbCommand.ExecuteReader（CommandBehavior behavior）
at System .Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.ExecuteStoreCommands（EntityCommand entityCommand，CommandBehavior behavior）
---内部异常堆栈跟踪结束---
at System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.ExecuteStoreCommands（EntityCommand entityCommand，CommandBehavior behavior）
at System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.Execute（EntityCommand entityCommand， CommandBehavior行为）
Syst的
em.Data.Entity.Core.EntityClient.EntityCommand.ExecuteReader（CommandBehavior behavior）
at Microsoft.Data.Entity.Design.VersioningFacade.ReverseEngineerDb.SchemaDiscovery.EntityStoreSchemaGeneratorDatabaseSchemaLoader.LoadDataTable [T]（String sql， Func`2 orderByFunc，DataTable表，EntityStoreSchemaFilterObjectTypes queryTypes，IEnumerable`1 filters，String [] filterAliases）
at Microsoft.Data.Entity.Design.VersioningFacade.ReverseEngineerDb.SchemaDiscovery.EntityStoreSchemaGeneratorDatabaseSchemaLoader.LoadRelationships（IEnumerable` 1个过滤器）
at Microsoft.Data.Entity.Design.VersioningFacade.ReverseEngineerDb.SchemaDiscovery.EntityStoreSchemaGeneratorDatabaseSchemaLoader.LoadStoreSchemaDetails（IList`1过滤器）
at Microsoft.Data.Entity。 Design.VisualStudio.ModelWizard.Engine.ModelGenerator.GetStoreSchemaDetails（StoreSchemaConnectionFactory connectionFactory）
at Microsoft.Data.Entity.Design.VisualStudio.ModelWizard.Engine .ModelGenerator.CreateStoreModel（）
at Microsoft.Data.Entity.Design.VisualStudio.ModelWizard.Engine.ModelGenerator.GenerateModel（List`1 errors）
at Microsoft.Data .Entity.Design.VisualStudio.ModelWizard.Engine.ModelBuilderEngine.GenerateModels（String storeModelNamespace，List`1 errors）
at Microsoft.Data.Entity.Design.VisualStudio.ModelWizard.Engine.ModelBuilderEngine.GenerateModel（ EdmxHelper edmxHelper）'。
从数据库加载元数据花了00：00：01.8297726。
生成模型花了00：00：07.0937833。
b / b
但是我查了一下我的ram它有5GB的可用内存，服务器的内存有30GB的可用内存..
When i try to update my datacontext,i'm getting this output;
Unable to generate the model because of the following exception: 'System.Data.Entity.Core.EntityCommandExecutionException: An error occurred while executing the command definition. See the inner exception for details. ---> System.Data.SqlClient.SqlException: There is insufficient system memory in resource pool 'default' to run this query.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.<>c__DisplayClassb.<reader>b__8()
at System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch[TInterceptionContext,TResult](Func`1 operation, TInterceptionContext interceptionContext, Action`1 executing, Action`1 executed)
at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.Reader(DbCommand command, DbCommandInterceptionContext interceptionContext)
at System.Data.Entity.Internal.InterceptableDbCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)
--- End of inner exception stack trace ---
at System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)
at System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.Execute(EntityCommand entityCommand, CommandBehavior behavior)
at System.Data.Entity.Core.EntityClient.EntityCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.Data.Entity.Design.VersioningFacade.ReverseEngineerDb.SchemaDiscovery.EntityStoreSchemaGeneratorDatabaseSchemaLoader.LoadDataTable[T](String sql, Func`2 orderByFunc, DataTable table, EntityStoreSchemaFilterObjectTypes queryTypes, IEnumerable`1 filters, String[] filterAliases)
at Microsoft.Data.Entity.Design.VersioningFacade.ReverseEngineerDb.SchemaDiscovery.EntityStoreSchemaGeneratorDatabaseSchemaLoader.LoadRelationships(IEnumerable`1 filters)
at Microsoft.Data.Entity.Design.VersioningFacade.ReverseEngineerDb.SchemaDiscovery.EntityStoreSchemaGeneratorDatabaseSchemaLoader.LoadStoreSchemaDetails(IList`1 filters)
at Microsoft.Data.Entity.Design.VisualStudio.ModelWizard.Engine.ModelGenerator.GetStoreSchemaDetails(StoreSchemaConnectionFactory connectionFactory)
at Microsoft.Data.Entity.Design.VisualStudio.ModelWizard.Engine.ModelGenerator.CreateStoreModel()
at Microsoft.Data.Entity.Design.VisualStudio.ModelWizard.Engine.ModelGenerator.GenerateModel(List`1 errors)
at Microsoft.Data.Entity.Design.VisualStudio.ModelWizard.Engine.ModelBuilderEngine.GenerateModels(String storeModelNamespace, List`1 errors)
at Microsoft.Data.Entity.Design.VisualStudio.ModelWizard.Engine.ModelBuilderEngine.GenerateModel(EdmxHelper edmxHelper)'.
Loading metadata from the database took 00:00:01.8297726.
Generating the model took 00:00:07.0937833.
However i checked my ram it has got 5 gb available memory and the server's memory has got 30 gb available memory..
推荐答案
这不是代码问题，但技术问题。如果你谷歌确切的错误，你会看到很多可能的解决方案来解决这个问题。
我首先分析你的查询，看看如何改善它的问题性能。
浏览谷歌搜索结果，你会看到其他解决方法。
例如： http：//www.sqlserver- expert.com/2014/04/there-is-insufficient-system-memory-in.html [ ^ ]
This is not a code question but a technical issue. If you google the exact error you'll see lots of possible solutions for fixing this problem.
I'd start with analyzing your query to see how you can improve it's performance.
Go through the google search results and you'll see other ways of how to troubleshoot this.
For example: http://www.sqlserver-expert.com/2014/04/there-is-insufficient-system-memory-in.html[^]
这篇关于由于以下异常，无法生成模型:(资源池“default”中没有足够的系统内存来运行此查询。）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
