近日公司服务器频频出现由于内存不足而引起的IIS工作不正常的情况，通过观察，服务器的大部分内存都被SQL SERVER所占用。要想让SQL SERVER释放掉占用的内存，只能通过重新启动MSSQLSERVER服务来实现，SQL SERVER 2000自身并未提供类似的功能。
我联想到可以将停止与启动MSSQLSERVER服务的命令行做成批处理文件，同时结合Windows的“任务计划”功能，来实现定时自动释放SQL SERVER占用内存的方法，做法如下：
搜索
文章分类
最新文章
- [11/16]pfx证书文件生成
- [10/06]事务日志已满,原因为“LOG_BACKUP”。
- [08/19]php环境调试总结
- [08/14]记录一次winserver2012 IIS劫持处理操作过程
- [07/19]服务器内存条别乱插
- [05/28]win10 thinkpad T14s 型号笔记本突然找不到麦克风了
- [05/09]数据库文件无法移动时 用下面的bat命令
- [05/08]hyper-v虚拟机里无法安装SQL的问题
- [05/08]windows系统安装经验总结
- [05/08]SQL SERVE复制需要有实际的服务器名称才能连接到服务器
- [04/21]打开谷歌浏览器 弹出新的hao.360.com的处理方法
- [04/08]Cls_Page_html.asp
- [03/15]MSSQL无法启动
- [02/18]PC站自动跳转到WAP站对应的页面（HTML5+JS）
- [10/16]高版本的SQLServer2016 还原到低版本的SQL Server2012
文章归档
- 2024 November (1)
- 2024 October (1)
- 2024 August (2)
- 2024 July (1)
- 2024 May (5)
- 2024 April (2)
- 2024 March (1)
- 2024 February (1)
- 2023 October (3)
- 2023 August (2)
- 2023 June (1)
- 2023 May (1)
- 2023 March (1)
- 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)
最新评论