近日公司服务器频频出现由于内存不足而引起的IIS工作不正常的情况，通过观察，服务器的大部分内存都被SQL SERVER所占用。要想让SQL SERVER释放掉占用的内存，只能通过重新启动MSSQLSERVER服务来实现，SQL SERVER 2000自身并未提供类似的功能。
我联想到可以将停止与启动MSSQLSERVER服务的命令行做成批处理文件，同时结合Windows的“任务计划”功能，来实现定时自动释放SQL SERVER占用内存的方法，做法如下：
搜索
文章分类
最新文章
- [02/02]mssql 自动回收内存
- [01/30]js 提交按钮
- [01/28]批量搜索文件
- [01/27]服务器定时重启
- [10/17]提交安全过滤
- [10/15]sql 设置 数据不允许重复
- [10/14]全国省市区街道数据--官方
- [10/12]Sql 中Collate用法
- [10/12]Windows事件日志ID汇总
- [10/12]Windows事件日志ID汇总
- [10/09]SQL2016数据库改端口
- [10/09]SQL 2012 错误 0x80090331，状态代码 0x80
- [09/23]IIS8.5配置导入导出
- [09/20]WINDOWS 2012 安装SQL2016步骤
- [06/07]查看数据库连接数
文章归档
- 2023 February (1)
- 2023 January (3)
- 2022 October (8)
- 2022 September (2)
- 2022 June (1)
- 2022 May (1)
- 2022 March (2)
- 2022 January (3)
- 2021 September (1)
- 2021 January (2)
- 2020 May (1)
- 2020 March (2)
- 2020 February (1)
- 2020 January (7)
- 2019 December (4)
- 2019 August (2)
- 2019 July (4)
- 2019 June (4)
- 2019 January (1)
- 2018 December (1)
- 2018 September (1)
- 2018 August (1)
- 2018 April (2)
- 2018 February (1)
- 2018 January (1)
- 2017 November (1)
- 2017 August (2)
- 2017 April (1)
- 2017 March (5)
- 2017 January (1)
- 2016 December (1)
- 2016 September (1)
- 2016 August (1)
- 2016 July (1)
- 2016 April (1)
- 2016 March (6)
- 2016 January (5)
- 2015 November (1)
- 2015 October (3)
- 2015 September (7)
- 2015 July (8)
- 2015 June (8)
- 2015 May (6)
- 2015 April (5)
- 2015 March (1)
- 2015 January (1)
- 2014 December (3)
- 2014 October (2)
- 2014 September (3)
- 2014 August (3)
- 2014 June (1)
- 2014 May (1)
- 2014 April (1)
- 2014 March (3)
- 2014 February (5)
- 2014 January (4)
- 2013 September (2)
- 2013 July (6)
- 2013 June (8)
- 2013 May (6)
- 2013 April (5)
- 2013 March (3)
- 2013 February (1)
- 2013 January (6)
- 2012 December (3)
- 2012 November (3)
- 2012 October (2)
- 2012 September (1)
- 2012 July (5)
- 2012 June (2)
- 2012 May (1)
- 2012 April (3)
- 2012 March (3)
- 2012 February (2)
- 2012 January (1)
- 2011 December (4)
- 2011 October (2)
- 2011 September (3)
- 2011 August (5)
- 2011 July (3)
- 2011 June (7)
- 2011 May (6)
- 2011 April (7)
- 2011 March (11)
- 2011 February (7)
- 2011 January (5)
- 2010 December (11)
最新评论