Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

MSSQL database making system crash

Options
  • 17-11-2008 4:10pm
    #1
    Ben Kane
    Closed Accounts Posts: 4 ✭


    Hi All,

    Does anyone know how much RAM a PC/Laptop should have to run an MSSQL database? The MSSQL database seems to be causing the system to crash intermittently according to the application and system log on the machine. It has a CAD program on the machine, which the guy whose laptop it is wants to keep. I assume that the MSSQL database is linked to the autocad in some way. I've heard that MSSQL databases require a lot of RAM to run, otherwise they cause system problems. Is this likely to be the problem, as 512Mb RAM isn't a lot. Would I be better trying to reinstall MSSQL? I/he doesn't have the reinstall disks for his CAD package. Any thoughts would be appreciated.

    Cheers,
    Ben


Comments

  • Options
    #2
    ttcomet
    Registered Users Posts: 469 ✭✭ttcomet


    Can you post the error? Is there a dump file for SQL? TBH I doubt 1/2 a gig is enough for sql (which version btw) but if I remember correctly you can tell it to only use a certain amount.


  • Options
    #3
    Ben Kane
    Closed Accounts Posts: 4 ✭Ben Kane


    Hi Sorry for the long error logs I've just pasted, but I think all the information is in there somewhere. I originally thought that the SQL database was being used by the AutoCAD 2004 application he is running, but I noticed that the application error report says that

    "The description for Event ID ( 19011 ) in Source ( MSSQL$MICROSOFTBCM ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer"

    Which seems to imply that it's trying to connect to a remote SQL server somewhere and it is a client that is running on his machine. Does this make sense, or have I misunderstood the message? Or could the remote machine be referring to the laptop itself which is hosting the SQL database for the CAD application?

    Many thanks for your help!

    Event Type: Error
    Event Source: System Error
    Event Category: (102)
    Event ID: 1003
    Date: 11/11/2008
    Time: 12:41:29
    User: N/A
    Computer: DGFGF01J
    Description:
    Error code 1000000a, parameter1 f8ada330, parameter2 00000002, parameter3 00000001, parameter4 804d9b68.

    For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
    Data:
    0000: 53 79 73 74 65 6d 20 45 System E
    0008: 72 72 6f 72 20 20 45 72 rror Er
    0010: 72 6f 72 20 63 6f 64 65 ror code
    0018: 20 31 30 30 30 30 30 30 1000000
    0020: 61 20 20 50 61 72 61 6d a Param
    0028: 65 74 65 72 73 20 66 38 eters f8
    0030: 61 64 61 33 33 30 2c 20 ada330,
    0038: 30 30 30 30 30 30 30 32 00000002
    0040: 2c 20 30 30 30 30 30 30 , 000000
    0048: 30 31 2c 20 38 30 34 64 01, 804d
    0050: 39 62 36 38 9b68



    Event Type: Error
    Event Source: Application Hang
    Event Category: (101)
    Event ID: 1002
    Date: 17/11/2008
    Time: 14:51:10
    User: N/A
    Computer: DGFGF01J
    Description:
    Hanging application mshta.exe, version 7.0.5730.11, hang module hungapp, version 0.0.0.0, hang address 0x00000000.

    For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
    Data:
    0000: 41 70 70 6c 69 63 61 74 Applicat
    0008: 69 6f 6e 20 48 61 6e 67 ion Hang
    0010: 20 20 6d 73 68 74 61 2e mshta.
    0018: 65 78 65 20 37 2e 30 2e exe 7.0.
    0020: 35 37 33 30 2e 31 31 20 5730.11
    0028: 69 6e 20 68 75 6e 67 61 in hunga
    0030: 70 70 20 30 2e 30 2e 30 pp 0.0.0
    0038: 2e 30 20 61 74 20 6f 66 .0 at of
    0040: 66 73 65 74 20 30 30 30 fset 000
    0048: 30 30 30 30 30 00000


    Event Type: Warning
    Event Source: MSSQL$MICROSOFTBCM
    Event Category: (8)
    Event ID: 19011
    Date: 17/11/2008
    Time: 15:59:38
    User: N/A
    Computer: DGFGF01J
    Description:
    The description for Event ID ( 19011 ) in Source ( MSSQL$MICROSOFTBCM ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: (SpnRegister) : Error 1355.


  • Options
    #4
    ttcomet
    Registered Users Posts: 469 ✭✭ttcomet


    The first error is: no idea :). But try run this to see if you have any driver issues. You will definitely have to find the dump file to get more information for it as well.

    The second one is to do with Microsoft help files, was he looking at the help for sql when it hung or?

    The third one may be related to this article on the MS knowledge base? Try that and see if it helps.


Advertisement