none
关于系统日志的请教 RRS feed

  • 问题

  • 各位好,我一台windows 2008 R2 上跑sql server 2008 R2

    在安装完数据库后,系统没有什么问题。

    但是跑起我们自己的数据库后系统出现以下错误:

     

    日志名称: System
    来源: Microsoft-Windows-WHEA-Logger
    日期: 2011/12/7 8:12:57
    事件 ID: 47
    任务类别: 无
    级别: 警告
    关键字:
    用户: LOCAL SERVICE
    计算机: DB-01
    描述:
    出现已更正的硬件错误。

    组件: 内存
    错误源: 已更正的计算机检查

    该项的详细信息视图包含进一步的信息。
    事件 Xml:
    <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
    <System>
    <Provider Name="Microsoft-Windows-WHEA-Logger" Guid="{C26C4F3C-3F66-4E99-8F8A-39405CFED220}" />
    <EventID>47</EventID>
    <Version>0</Version>
    <Level>3</Level>
    <Task>0</Task>
    <Opcode>0</Opcode>
    <Keywords>0x8000000000000000</Keywords>
    <TimeCreated SystemTime="2011-12-07T00:12:57.453125000Z" />
    <EventRecordID>3003</EventRecordID>
    <Correlation ActivityID="{E1E75B46-A40C-4281-A774-84B79B37CF4B}" />
    <Execution ProcessID="1132" ThreadID="10120" />
    <Channel>System</Channel>
    <Computer>DB-01</Computer>
    <Security UserID="S-1-5-19" />
    </System>
    <EventData>
    <Data Name="ErrorSource">1</Data>
    <Data Name="FRUId">{00000000-0000-0000-0000-000000000000}</Data>
    <Data Name="FRUText">
    </Data>
    <Data Name="ValidBits">0x0</Data>
    <Data Name="ErrorStatus">0x0</Data>
    <Data Name="PhysicalAddress">0x0</Data>
    <Data Name="PhysicalAddressMask">0x0</Data>
    <Data Name="Node">0x0</Data>
    <Data Name="Card">0x0</Data>
    <Data Name="Module">0x0</Data>
    <Data Name="Bank">0x0</Data>
    <Data Name="Device">0x0</Data>
    <Data Name="Row">0x0</Data>
    <Data Name="Column">0x0</Data>
    <Data Name="BitPosition">0x0</Data>
    <Data Name="RequesterId">0x0</Data>
    <Data Name="ResponderId">0x0</Data>
    <Data Name="TargetId">0x0</Data>
    <Data Name="ErrorType">0</Data>
    <Data Name="Length">873</Data>
    <Data Name="RawData">435045521002FFFFFFFF0300020000000200000069030000390C0000070C0B140000000000000000000000000000000000000000000000000000000000000000BDC407CF89B7184EB3C41F732CB57131B18BCE2DD7BD0E45B9AD9CF4EBD4F890BE41B20234B4CC01000000004552000000000000000000000000000000000000580100004900000001020000010000001411BCA5646FDE4EB8633E83ED7C83B100000000000000000000000000000000020000000000000000000000000000000000000000000000A1010000C00000000102000000000000ADCC7698B447DB4BB65E16F193C4F3DB0000000000000000000000000000000002000000000000000000000000000000000000000000000061020000080100000102000000000000011D1E8AF94257459C33565E5CC3F7E8000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000057010000000000000002000000000000F2060200000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000250000000000000000000000000000000000000000000000000000000000000000000000000000000100000001000000F0C201F974B4CC010B00000000000000000000000000000000000000090000008F00090040000090000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000</Data>
    </EventData>
    </Event>

     

    请教一下具体是什么原因。网上查询了一下,定位到内存,但是具体是内存什么错误?由什么引起的?数据库服务器的那些问题可能会引起这些错误。

    另还有就是这台服务器是4物理核心64个虚拟核心,不知道是否存在兼容问题,跑起数据库来十分的慢,有什么方法可以查到瓶颈所在?是否会存在内存

    溢出等问题?

    谢谢!

     

     

    2011年12月7日 9:15

答案

  • What I'll do on this machine:

    1. install sql2k8 r2 sp1.

    2. set max memory to 28gb.

    3. set maxdop to 7.

    4. reconfigure disks to 3 raid1 arrays, that way you can seperate data from log.

    5. set proper reindex/update stats schedule.

    2011年12月8日 3:47

全部回复

  • Need more info: is it 64-bit machine? Installed 64-bit sql2k8 r2? How much memory does it have? How much allocated to sql? Is it dedicated sql server? What's disk config? What's total db size? ...
    2011年12月7日 15:05
  • Yes, Is a 64bit machine 

    CPU:  Intel E7-4820 18M Cache 2.0Ghz 5.86 Gt/s intel QPI  (Cores 8 / Threads 16) X 4

    Memory 32GB and Unlimited to Sql and Yes it dedicated sql server (Only Sql Server on it)

    6 x 600G SAS15000RPM with 2 Raid 5

    Db Size is up to 38GB(Without Log)

    Thanks!

     

     

     

     

     

    2011年12月8日 1:12
  • What I'll do on this machine:

    1. install sql2k8 r2 sp1.

    2. set max memory to 28gb.

    3. set maxdop to 7.

    4. reconfigure disks to 3 raid1 arrays, that way you can seperate data from log.

    5. set proper reindex/update stats schedule.

    2011年12月8日 3:47