none
安装完WSS之后SQL server文件夹急速增大问题 RRS feed

  • 问题

  •   大家好,本人现在做一个项目用到了microsoft sharepoint,安装完wss之后生成以下文件夹C:\WINDOWS\SYSMSI\SSEE\MSSQL.2005\MSSQL\LOG。可是安装完之后出现一个致命的错误,即在log文件夹下面大量的生成了很多类型为.txt .log .mdmp的文件,每次同时生成3个(SQLDumpNNNN.txt,SQLDumpNNNN.log,SQLDumpNNNN.mdmp),而且体积很大,我40g的硬盘一天就没空间了。大家告诉我怎么办啊!我为了不让他们继续增大,我只能在管理工具的service里面将sql的服务停止。谢谢大家了!我这里并没有安装sql,好像是装wss是提供了sql的一个服务。

    错误日志的部分内容如下:

    9/01/08 15:42:50, ERROR , SQLDUMPER_UNKNOWN_APP.EXE, AdjustTokenPrivileges () failed (00000514)
    09/01/08 15:42:50, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied
    09/01/08 15:42:50, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     ProcessID = 4076
    09/01/08 15:42:50, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     ThreadId = 0
    09/01/08 15:42:50, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     Flags = 0x0
    09/01/08 15:42:50, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     MiniDumpFlags = 0x0
    09/01/08 15:42:50, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     SqlInfoPtr = 0x02A03570
    09/01/08 15:42:50, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     DumpDir = <NULL>
    09/01/08 15:42:50, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     ExceptionRecordPtr = 0x00000000
    09/01/08 15:42:50, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     ContextPtr = 0x00000000
    09/01/08 15:42:50, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     ExtraFile = <NULL>
    09/01/08 15:42:50, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     InstanceName = <NULL>
    09/01/08 15:42:50, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     ServiceName = <NULL>
    09/01/08 15:42:50, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Dump is associated with file C:\WINDOWS\SYSMSI\SSEE\MSSQL.2005\MSSQL\LOG\SQLDump0001.txt
    09/01/08 15:42:50, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 11 not used
    09/01/08 15:42:50, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used
    09/01/08 15:42:50, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed: C:\WINDOWS\SYSMSI\SSEE\MSSQL.2005\MSSQL\LOG\SQLDump0001.mdmp
    09/01/08 15:42:50, ACTION,              sqlservr.exe, Watson Invoke: No

     

    .txt文件内的部分内容如下:

    =====================================================================                                           
           BugCheck Dump                                                                                            
    =====================================================================                                           
                                                                                                                    
    This file is generated by Microsoft SQL Server                                                                  
    version 9.00.2047.00                                                                                            
    upon detection of fatal unexpected error. Please return this file,                                              
    the query or program that produced the bugcheck, the database and                                               
    the error log, and any other pertinent information with a Service Request.                                      
                                                                                                                    
                                                                                                                    
    Computer type is AT/AT COMPATIBLE.                                                                              
    Bios Version is DELL   - 1                                                                                      
    Phoenix ROM BIOS PLUS Version 1.10 A04                                                                          
    Current time is 10:02:41 09/02/08.                                                                              
    2 Intel x86 level 6, 2133 Mhz processor (s).                                                                    
    Windows NT 5.2 Build 3790 CSD Service Pack 1.                                                                   
                                        
    Memory                              
    MemoryLoad = 32%                    
    Total Physical = 2047 MB            
    Available Physical = 1390 MB        
    Total Page File = 3943 MB           
    Available Page File = 3341 MB       
    Total Virtual = 2047 MB             
    Available Virtual = 351 MB          

    ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
                                                      
    Begin transaction log dump for database 'WSS_Search_SPNAT-PI03'; for Index maintenance - filter on ObjId.
         
                       Current LSN = 00001243:00000060:0011                                                         
                         Operation = LOP_INSERT_ROWS                                                                
                           Context = LCX_INDEX_LEAF                                                                 
                    Transaction ID = 0000:0012448a                                                                  
                          Tag Bits = 0000                                                                           
           Log Record Fixed Length = 62                                                                             
                 Log Record Length = 124                                                                            
                      Previous LSN = 00001243:00000060:000f                                                         
                         Flag Bits = 0200                                                                           
                       AllocUnitId = 72057594048872448                                                              
                     AllocUnitName = dbo.MSSCrawlURL.IX_MSSCrawlURL_ErrorId                                         
                           Page ID = 0001:0000022a                                                                  
                           Slot ID = 51                                                                             
                 Previous Page LSN = 00001243:00000060:000f                                                         
                   Number of Locks = 3                                                                              
                  Lock Information = ACQUIRE_LOCK_IX OBJECT: 7:1061578820:0 ;ACQUIRE_LOCK_IX PAGE: 7:1:554;ACQUIRE_LO
    CK_X KEY: 7:72057594043629568 (0e00618088ca)                                                                    
                       Description =                                                                                
                        Log Record = 00003e0043120000600000000f0002008a441200000002032a02000001003300a700000043120000
    600000000f00000100005700000000010000010000000300150000001a000000060000000000000000010000000abb0000030000000000000
    101000c00004468463f0000010200040204000a0e00618088ca3e00  

     

    .log文件内的部分内容如下:

    :26.75 spid59      *        Edi: 6262EFF0:  00167BA8  01003DA0  12A185F8  00000020  62623B6D  12A18000 
    2008-09-02 10:02:26.75 spid59      *        Esi: 00000000: 
    2008-09-02 10:02:26.75 spid59      *        Eax: 6262E188:  000042AC  00000000  00000000  77E55DEA  00000000  7C821B34 
    2008-09-02 10:02:26.75 spid59      *        Ebx: 0000003F: 
    2008-09-02 10:02:26.75 spid59      *        Ecx: 6262E7F8:  00000000  00010007  0000002E  6262E360  7813FAE2  0000002E 
    2008-09-02 10:02:26.75 spid59      *        Edx: 0000003D: 
    2008-09-02 10:02:26.75 spid59      *        Eip: 77E55DEA:  10C2C95E  90909000  A1649090  00000018  C334408B  891C428B 
    2008-09-02 10:02:26.75 spid59      *        Ebp: 6262E1D8:  6262E21C  02187744  000042AC  00000000  00000000  00000000 
    2008-09-02 10:02:26.75 spid59      *      SegCs: 0000001B: 
    2008-09-02 10:02:26.75 spid59      *     EFlags: 00000246: 
    2008-09-02 10:02:26.75 spid59      *        Esp: 6262E184:  110EB360  000042AC  00000000  00000000  77E55DEA  00000000 
    2008-09-02 10:02:26.75 spid59      *      SegSs: 78130023:  00000000  00000000  00000000  00000000  00000000  00000000 
    2008-09-02 10:02:26.75 spid59      * *******************************************************************************
    2008-09-02 10:02:26.75 spid59      * -------------------------------------------------------------------------------
    2008-09-02 10:02:26.75 spid59      * Short Stack Dump
    2008-09-02 10:02:26.75 spid59      77E55DEA Module(kernel32+00015DEA)
    2008-09-02 10:02:26.75 spid59      02187744 Module(sqlservr+01187744)
    2008-09-02 10:02:26.75 spid59      0218B600 Module(sqlservr+0118B600)
    2008-09-02 10:02:26.75 spid59      01E39396 Module(sqlservr+00E39396)
    2008-09-02 10:02:26.75 spid59      014D782D Module(sqlservr+004D782D)
    2008-09-02 10:02:26.75 spid59      01042FDE Module(sqlservr+00042FDE)
    2008-09-02 10:02:26.75 spid59      0104FD14 Module(sqlservr+0004FD14)
    2008-09-02 10:02:26.75 spid59      0103761A Module(sqlservr+0003761A)
    2008-09-02 10:02:26.75 spid59      010346A7 Module(sqlservr+000346A7)
    2008-09-02 10:02:26.75 spid59      010345B8 Module(sqlservr+000345B8)
    2008-09-02 10:02:26.75 spid59      010655FA Module(sqlservr+000655FA)
    2008-09-02 10:02:26.75 spid59      01065474 Module(sqlservr+00065474)
    2008-09-02 10:02:26.75 spid59      010251BC Module(sqlservr+000251BC)
    2008-09-02 10:02:26.75 spid59      01025741 Module(sqlservr+00025741)
    2008-09-02 10:02:26.75 spid59      01023E34 Module(sqlservr+00023E34)
    2008-09-02 10:02:26.75 spid59      01041DD5 Module(sqlservr+00041DD5)
    2008-09-02 10:02:26.75 spid59      0103DFD4 Module(sqlservr+0003DFD4)
    2008-09-02 10:02:26.75 spid59      01006A96 Module(sqlservr+00006A96)
    2008-09-02 10:02:26.75 spid59      01006BBC Module(sqlservr+00006BBC)
    2008-09-02 10:02:26.75 spid59      01006DAB Module(sqlservr+00006DAB)
    2008-09-02 10:02:26.75 spid59      01447562 Module(sqlservr+00447562)
    2008-09-02 10:02:26.75 spid59      0144859B Module(sqlservr+0044859B)
    2008-09-02 10:02:26.75 spid59      0144789A Module(sqlservr+0044789A)
    2008-09-02 10:02:26.75 spid59      01447720 Module(sqlservr+00447720)
    2008-09-02 10:02:26.75 spid59      781329B9 Module(MSVCR80+000029B9)
    2008-09-02 10:02:26.76 spid59      78132A45 Module(MSVCR80+00002A45)
    2008-09-02 10:02:26.76 spid59      Stack Signature for the dump is 0xD80DEA1B
    2008-09-02 10:02:26.95 spid59      External dump process return code 0x20000001.
    External dump process returned no errors.

    2008-09-02 10:02:42.01 spid59      Using 'dbghelp.dll' version '4.0.5'
    2008-09-02 10:02:42.01 spid59      **Dump thread - spid = 59, PSS = 0x110EB360, EC = 0x110EB368
    2008-09-02 10:02:42.01 spid59      ***Stack Dump being sent to C:\WINDOWS\SYSMSI\SSEE\MSSQL.2005\MSSQL\LOG\SQLDump0140.txt

    2008年9月17日 1:11

答案

  •  

    可能由于你安装步骤不完全正确,引起了一些错误,系统自动记录这些错误的日志,你可以在SharePoint的管理中心中禁用诊断日志来节省磁盘空间,方法:SharePoint管理中心|操作|日志报告|诊断日志 中,错误报告部分选择“忽略错误和收集信息”。
    2008年10月17日 7:58

全部回复

  • 有人帮忙给答复一下吗

    2008年9月28日 7:34
  • 看你的错误信息应该是WSS里面签入的那个SQL Server 2005 嵌入版的问题。

    我们这个版估计无能为力,要不去SQL版问问?

     

    2008年10月12日 14:46
    版主
  •  

    可能由于你安装步骤不完全正确,引起了一些错误,系统自动记录这些错误的日志,你可以在SharePoint的管理中心中禁用诊断日志来节省磁盘空间,方法:SharePoint管理中心|操作|日志报告|诊断日志 中,错误报告部分选择“忽略错误和收集信息”。
    2008年10月17日 7:58