none
SQL SERVER 2008R2 暂用服务器内存直到服务器死机。

    问题

  • 我安装的是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

    无法完全安装补丁,请帮我解决。谢谢!

    2012年1月12日 8:23