Page 1 of 2 12 LastLast
Results 1 to 15 of 17
  1. #1
    Join Date
    Nov 2003
    Location
    SF Bay Area
    Posts
    18

    Unanswered: Examining event logs hangs Enterprise Manager

    Anyone know a reason why trying to read the event logs hangs Enterprise Manager?

    Do I have to read them threw Enterprise Manager?

    Thanks,

    Bryan Hughes

  2. #2
    Join Date
    Dec 2002
    Posts
    63
    Check to see how large your logs are. If they are too big, it may just be taking a while for them to open up. You can also open them up in notepad.

  3. #3
    Join Date
    Nov 2003
    Location
    SF Bay Area
    Posts
    18
    Originally posted by Pigeon
    Check to see how large your logs are. If they are too big, it may just be taking a while for them to open up. You can also open them up in notepad.
    Now for the $60,000 question, where do I find the SQL Server event logs...

  4. #4
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Probably the best thing to do is to start a new event log. This should allow your old log to open more quickly, or you can open and edit it through another application.

    Normally a new event log is started only when you stop and restart SQL Server, but there is an SQL command that will do it as well. I make the command part of my weekly maintenance so that the log never grows to big.

    No, I can't remember the command right now, but if you can't find it and nobody else posts it I'll look it up at my office tomorrow.

    blindman

  5. #5
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    Originally posted by blindman
    Probably the best thing to do is to start a new event log. This should allow your old log to open more quickly, or you can open and edit it through another application.

    Normally a new event log is started only when you stop and restart SQL Server, but there is an SQL command that will do it as well. I make the command part of my weekly maintenance so that the log never grows to big.

    No, I can't remember the command right now, but if you can't find it and nobody else posts it I'll look it up at my office tomorrow.

    blindman
    The command is : sp_cycle_errorlog

    Default path where you would find the logs is the Logs directory in your MS SQL installation folder
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

  6. #6
    Join Date
    Feb 2002
    Posts
    2,232
    Were you talking about the event logs or the sql server logs ? If your sql server log is really big then will experience the "hang". If you don't know the location, just do a quick search on ERRORLOG.

  7. #7
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Thanks Enigma. Did you consult the Holy Book?

    blindman

  8. #8
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    Nope .. but did see the code for sp_cycle_errorlog.
    And found out an undocumented dbcc command (not there in the Holy Book)

    Code:
    dbcc errorlog
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

  9. #9
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Well, what does it do?

    ...and dude, I gotta tell ya... your Icon is FREAKIN ME OUT!

    blindman

  10. #10
    Join Date
    Feb 2002
    Posts
    2,232
    Both cycle the log.

  11. #11
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    Originally posted by blindman
    Well, what does it do?

    ...and dude, I gotta tell ya... your Icon is FREAKIN ME OUT!

    blindman
    Well .. the code for the stored proc sp_cycle_errorlog is :
    Code:
    create procedure sp_cycle_errorlog  --- 1997/06/24
    as
    if (not (is_srvrolemember('sysadmin') = 1))  -- Make sure that it is the SA executing this.
            begin
                    raiserror(15247,-1,-1)
                    return(1)
            end
    
    dbcc errorlog
    return (0)
    So ultimately its dbcc errorlog that is recycling the logs
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

  12. #12
    Join Date
    Nov 2003
    Location
    SF Bay Area
    Posts
    18
    Thanks for the help! You guys rock...

  13. #13
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Originally posted by blindman
    Well, what does it do?

    ...and dude, I gotta tell ya... your Icon is FREAKIN ME OUT!

    blindman
    How can you see it if you're a blindman?

    I thought you were answer questions from a brail monitor or something...

    and DUDE...where's the dark planet?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  14. #14
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    My seeing eye dog translates text from the screen into a series of binary woofs indicating the ASCII codes of the characters. And ever since Enigma changed his Icon, Fido keeps trying to bury my monitor in the back yard.

    Bad DOG!

    blindman

  15. #15
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    The Dark Planet is a dark corner of the Milky Way Galaxy.

    LOL :GRIN:

    BTW if you want to know where I am from ... I am from Mumbai , India
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •