SQL Server Performance

View Transaction Log Content

Discussion in 'Performance Tuning for DBAs' started by VeraJordao, Sep 8, 2005.

  1. VeraJordao New Member

    Is it possible to view transaction log content?
    VeraJordao, Sep 8, 2005
    #2

  2. Luis Martin Moderator

    Whitout 3rd party tools, is no easy.
    Take a look of ours sponsors.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    One of the symptoms of an approaching nervous breakdown is the belief that one's work is terribly important
    Bertrand Russell


    All postings are provided “AS IS” with no warranties for accuracy.



    Luis Martin, Sep 8, 2005
    #2

  3. satya Moderator

    You can use DBCC log to view the log but it is not easy to understand and as Luis referred using third party tools like Log Explorer or Log Navigator you can accompish the task.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
    satya, Sep 9, 2005
    #2

  4. Akthar New Member

    Hi,

    if you go for third party , i would suggest LOG EXPLORER fromhttp://www.lumigent.com

    AKTHAR DILMOHAMUD
    65 BENARES ST
    PORT LOUIS
    MAURITIUS
    Akthar, Sep 9, 2005
    #2

  5. satya Moderator

    It is expensive and Log Navigator is better in price and few snippets.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
    satya, Sep 9, 2005
    #2

  6. FrankKalis Moderator

    FrankKalis, Sep 9, 2005
    #2

  7. dineshasanka Moderator

    dineshasanka, Sep 9, 2005
    #2

  8. VeraJordao New Member

    Well, I'm asking this because every sunday the Transaction Log is full and there isn't anyone in my company, except for the asp app. This occurs only on Sundays and I'd like to view the content of this log to know what is going on.
    VeraJordao, Sep 9, 2005
    #2

  9. FrankKalis Moderator

    I see. In that case you need to look at third party tools. The build-in DBCC LOG command is more than cryptic.

    Am I reading you right, that the T-LOG is full and SQL Server therefore stops? If so, you might want to search the forum here. You shold find numerous similar threads.

    --
    Frank Kalis
    Microsoft SQL Server MVP
    http://www.insidesql.de
    Ich unterstütze PASS Deutschland e.V. http://www.sqlpass.de)
    FrankKalis, Sep 9, 2005
    #2

  10. satya Moderator

    Check if any jobs are scheduled on sundays, such as optimization jobs or any bulk inserts.
    If not PROFILER will be a good one to monitor the events, before handing it to the third party tool.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
    satya, Sep 9, 2005
    #2

  11. FrankKalis Moderator

    <blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><br />If not PROFILER will be a good one to monitor the events, before handing it to the third party tool<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br />...and in case you don't want to spend each Sunday for some time at your company, you might be better off using a server side trace and probably schedule this while you enjoy your weekend. [<img src='/community/emoticons/emotion-2.gif' alt=':D' />]<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Ich unterstütze PASS Deutschland e.V. <a target="_blank" href=http://www.sqlpass.de>http://www.sqlpass.de</a>) <br />
    FrankKalis, Sep 9, 2005
    #2

  12. satya Moderator

    satya, Sep 9, 2005
    #2

  13. FrankKalis Moderator

    http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlmag01/html/TrackingDownEventClues.asp [<img src='/community/emoticons/emotion-4.gif' alt=':p' />]<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Ich unterstütze PASS Deutschland e.V. <a target="_blank" href=http://www.sqlpass.de>http://www.sqlpass.de</a>) <br />
    FrankKalis, Sep 9, 2005
    #2

  14. VeraJordao New Member

    There was a index optimization scheduled for sundays and, because there's no activity in the company, there's no T-Log Backup routine scheduled....
    I don't know which one to blame, or none....
    But thanks for all the suggestions....I'm going to take a look into server side tracing...
    VeraJordao, Sep 9, 2005
    #2

Share This Page