使用WCF运行对SQL Server查询时出现奇怪的错误 [英] Strange error occurring when using wcf to run query against sql server

问题描述

我建立一个asp.net应用程序，在Windows Server 2003（VPS主机）使用II6。
我面临着一个错误我没有收到我的开发机器上（Windows 7中，IIS 7.5，64位）。

I am building an asp.net application, using II6 on windows server 2003 (vps hosting). I am confronted with an error I didn't receive on my development machine (windows 7, iis 7.5, 64 bit).

在我的WCF服务试图发动我的查询针对本地的SQL Server运行这是我收到的错误：

When my wcf service tries launching my query running against a local sql server this is the error I receive:

内存门检查失败原因
  空闲内存（43732992字节）
  总存储器的不到5％。作为一个
  结果，服务将不
  可用于传入的请求。至
  解决这个问题，或者降低负荷
  在机器上或调节的值
  minFreeMemoryPercentageToActivateService
  在serviceHostingEnvironment
  config元素。

Memory gates checking failed because the free memory (43732992 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.

和想法？

推荐答案

有一件事你可以尝试在改变绝对的'墨西哥'的服务路径，如果它是不是已经。它的工作一次我。但是，这可能是由于该服务重新启动和释放一些内存。

One thing you could try is changing your 'mex' service path to absolute if it is not already. It worked for me once. But that could have been due to the service restarting and freeing some memory.

BrainSlug的回答有如何做到这一点的例子

BrainSlug's Answer has an example of how to do this

这篇关于使用WCF运行对SQL Server查询时出现奇怪的错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！