有没有办法停止SQL Express 2008从Idling？ [英] Is there a way to stop SQL Express 2008 from Idling?

问题描述

我使用SQL Express 2008作为Web应用程序的后端，问题是Web应用程序在工作时间使用，因此有时在午餐或休息时间，当没有用户登录20分钟时间SQL Express将

I am using SQL Express 2008 as a backend for a web application, the problem is the web application is used during business hours so sometimes during lunch or break time when there is no users logged in for a 20 minute period SQL express will kick into idle mode and free its cache.

我知道这是因为它记录了如下内容：
服务器在空闲后恢复执行9709秒
或
在事件日志中启动数据库'xxxxxxx'

I am aware of this because it logs something like: Server resumed execution after being idle 9709 seconds or Starting up database 'xxxxxxx' in the event log

我想避免这种空闲行为，是否有配置SQL表示停止怠速或至少将时间窗加宽至超过20分钟。

I would like to avoid this idle behavior, is there anyway to configure SQL express to stop idling or at least widen the time window to longer than 20mins. Or is my only option to write a service that polls the db every 15mins to keep it spooled up ?

在阅读

After reading articles like this it doesn't look to promising but maybe there is a hack or registry setting someone knows about.

推荐答案

这种行为是不可配置。

您必须实现一个方法来经常轮询数据库。此外，像您链接到的文章一样，将AUTO CLOSE属性设置为false。

You do have to implement a method to poll the database every so often. Also, like the article you linked to said, set the AUTO CLOSE property to false.

这篇关于有没有办法停止SQL Express 2008从Idling？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！