我安装的是SQL SERVER 2008R2 的数据库,现在的问题是每天SQL都会占用服务器内存几百兆无法被释放直到完全占用服务器内存导致服务器死机。我服务器内存一共16G,我设置的SQL最高占用内存8G也不管用,还是会把服务器的内存占完导致死机。请帮我解决这个问题,谢谢!
昨天我从官网下载了SP1的补丁安装,但是安装失败。错误日志:
Overall summary:
Final result: 修补程序的安装程序无法更新以下实例: MSSQLSERVER。若要确定失败的原因,请查看日志文件。
Exit code (Decimal): -2068052297
Exit facility code: 1212
Exit error code: 1719
Exit message: 修补程序的安装程序无法更新以下实例: MSSQLSERVER。若要确定失败的原因,请查看日志文件。
Start time: 2012-01-11 15:32:37
End time: 2012-01-11 15:35:16
Requested action: Patch
Instance MSSQLSERVER overall summary:
Final result: 修补程序的安装程序无法更新共享功能。若要确定失败的原因,请查看日志文件。
Exit code (Decimal): -2068052297
Exit facility code: 1212
Exit error code: 1719
Exit message: 修补程序的安装程序无法更新共享功能。若要确定失败的原因,请查看日志文件。
Start time: 2012-01-11 15:33:58
End time: 2012-01-11 15:35:10
Requested action: Patch
Log with failure: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120111_153235\MSSQLSERVER\sql_engine_core_inst_Cpu64_1.log
Exception help link:
http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=10.50.2500.0
Machine Properties:
Machine name: WIN-DNE2KO3SNDA
Machine processor count: 16
OS version: Windows Server 2008
OS service pack: Service Pack 1
OS region: 中华人民共和国
OS language: 中文(中华人民共和国)
OS architecture: x64
Process architecture: 64 位
OS clustered: 否
Product features discovered:
Product Instance Instance ID
Feature Language
Edition Version Clustered
Sql Server 2008 R2 MSSQLSERVER MSSQL10_50.MSSQLSERVER 数据库引擎服务
1033 Enterprise Edition 10.50.1600.1 否
Sql Server 2008 R2 MSSQLSERVER MSSQL10_50.MSSQLSERVER 数据库引擎服务
2052 Enterprise Edition 10.50.1600.1 否
Sql Server 2008 R2 MSSQLSERVER MSSQL10_50.MSSQLSERVER SQL Server 复制
1033 Enterprise Edition 10.50.1600.1 否
Sql Server 2008 R2 MSSQLSERVER MSSQL10_50.MSSQLSERVER SQL Server 复制
2052 Enterprise Edition 10.50.1600.1 否
Sql Server 2008 R2 MSSQLSERVER MSSQL10_50.MSSQLSERVER 全文搜索
1033 Enterprise Edition 10.50.1600.1 否
Sql Server 2008 R2
管理工具 - 基本 2052
Enterprise Edition 10.51.2500.0 否
Sql Server 2008 R2
管理工具 - 完整 2052
Enterprise Edition 10.50.1600.1 否
Sql Server 2008 R2
客户端工具连接 2052
Enterprise Edition 10.50.1600.1 否
Sql Server 2008 R2
客户端工具向后兼容性 2052
Enterprise Edition 10.50.1600.1 否
Sql Server 2008 R2
客户端工具 SDK 2052
Enterprise Edition 10.50.1600.1 否
Package properties:
Description: SQL Server Database Services 2008 R2
ProductName: SQL2008
Type: RTM
Version: 10
SPLevel: 1
KBArticle: KB2528583
KBArticleHyperlink:
http://support.microsoft.com/?kbid=2528583
PatchType: SP
AssociateHotfixBuild: 0
Platform: x64
PatchLevel: 10.51.2500.0
ProductVersion: 10.50.1600.1
GDRReservedRange: 10.0.1000.0:10.0.1099.0;10.0.3000.0:10.0.3099.0
PackageName: SQLServer2008-KB2528583-x64.exe
Installation location: d:\42a45fd80b81624c8ec891\x64\setup\
Updated product edition:
Instance Edition
MSSQLSERVER ENTERPRISE
用户输入设置:
ACTION: Patch
ALLINSTANCES: False
CLUSTERPASSIVE: False
CONFIGURATIONFILE:
ENU: False
FARMACCOUNT:
FARMADMINPORT: 0
FARMPASSWORD: *****
HELP: False
INDICATEPROGRESS: False
INSTANCEID:
INSTANCENAME:
PASSPHRASE: *****
QUIET: False
QUIETSIMPLE: False
UIMODE: Normal
X86: False
Rules with failures:
Global rules:
There are no scenario-specific rules.
Rules report file: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120111_153235\SystemConfigurationCheck_Report.htm
无法完全安装补丁,请帮我解决。谢谢!