没有任何 SQL Server 的应用程序结构
我的 VPS 内存有限,并且我的 WCF 服务是使用 AppFabric 托管的。
由于内存有限,并且除了 AppFabric 先决条件之外,我没有将 SQL Server 用于任何其他用途,因此我正在考虑卸载 SQL Server。 (实例有时最多可以占用 200MB 内存)。我没有使用 AppFabric 的任何与数据库相关的功能,例如仪表板或缓存。然而,我喜欢 IIS 扩展和 WCF 服务操作的简单性,并且我认为这些实际上并不需要 Sql Server。
我无法尝试一下,所以想知道是否有人有这样的经验,或者可以预测在 appfabric 行为上卸载 SQL Server 的结果。
I got VPS with limited memory and my WCF service is hosted using AppFabric.
Since memory is limited and I am not using SQL server for anything other than AppFabric prerequisite im thinking about uninstalling SQL Server. (instance can eat up to 200mb memory at times). I am not using any DB related features of AppFabric like dashboard or caching. I like IIS extensions and simplicity for WCF service manipulations however, and I am thinking those do not require Sql Server actually.
I am unable to just try it out so wonder if someone has such experience, or can predict result of uninstalling SQL server on appfabric behaviour.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(2)
您无需卸载 SQL Server,只需停止 SQL Server 进程即可。将进程设置为手动启动。
这样,如果您将来需要 SQL Server,您只需启动该过程即可。
Instead of uninstalling SQL Server you could just stop the SQL Server process. Set the process to manual startup.
That way if you need SQL Server in the future you can just start the process.
正如 @Shiraz Bhajiji 所暗示的,如果您使用 SQLServer 作为配置存储,您将需要重新配置它以使用基于文件的配置,听起来您只使用单个 AppFabric 实例,但如果您是或需要使用多个实例配置文件需要可供所有实例访问。
同样,它不一定与您相关,但如果您有多个应用程序结构实例,则 sql server 配置选项是一种更可靠的方法。使用基于文件的方法,如果配置不正确,一个应用程序结构节点关闭可能会导致整个集群关闭。 SQLServer 方法确实存在单点故障,但是,如果您使用集群等,则可以轻松缓解此问题。我再次感谢我在这里有点偏离主题。
As @Shiraz Bhajiji illudes to if you are using SQLServer as the configuration store, you will need to reconfigure it to use file based configuration instead, it sounds like you are only using a single AppFabric instance, but if you are or needed to use multiple instances the config file would need to be accessible to all instances.
Again it isn't necessarily relevant to you, but if you have multiple app fabric instances, the sql server configuration option is a much more robust approach. With the file based approach, if you configure things incorrectly one app fabric node going down can take down the entire cluster. The SQLServer approach does represent a single point of failure however, if you are using clustering etc you can easily mitigate this. Again I appreciate I'm getting a little off topic here.