SQL Server Performance

Transaction log explorer

Discussion in 'Third Party Tools' started by zoom14151, Jul 10, 2003.

  1. zoom14151 New Member

    Does anyone know of any free transaction log explorer to read the logs.
  2. barozai New Member

    Log_Explorer by Lumigent Technologies is the best tool to explore transaction logs.
    You can download its free demo form www.lumigent.com.

    Aman
    DBA
    Chenab Ltd.
  3. preethi Member

    Log Explorer trial edition will work only on Northwind, pubs and there own database.
    As far as I know It won't work with other databases.

    Is there any way of checking it for our database?

    G.R. Preethiviraj Kulasingham
  4. satya Moderator

  5. Luis Martin Moderator

    There is no free tool as far I konw.

    Luis
  6. barozai New Member

    Here is a 14 days evaluation key by which you can explore your own DBs.
    "xxxxx" [Deleted by Moderator]
    It will work with Ver 3.00.

    Aman
    DBA
    Chenab Ltd.
  7. satya Moderator

    Aman, make sure you comply with T&C by Lumigent.
    I appreciate your help but never ever reveal product keys or licence keys in a newsgroup, its for your safety too.

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com
  8. Luis Martin Moderator

    Indeed.

    Luis Martin
  9. blockwood New Member

  10. Jelly0228 New Member

    I guess Microsoft must provide some API or functions to Lumigent to access the sql server log.and I think maybe we can write a applcation to read the log with any tools/program language that such as C,VB,Java,Delphi...

    I hope we can discuss that how to do it.



    Jelly.
  11. satya Moderator

    You could get more information from Brian with regard to log navigator application which is under testing on other forum, check it out or contact Brian Lockwood at ApexSQL.

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com
  12. FrankKalis Moderator

    You can use something like


    DBCC LOG (<your_db>,-1)
    However, when you are not used to do your every day life in hexadecimal, I would spent this money for a third-party tool.

    I haven't tried yet, but did you have a look athttp://www.sourceforge.net ?
    I know there are plenty of open SQL Server projects around there. Maybe even one for this purpose.

    Frank
    http://www.insidesql.de
    http://www.familienzirkus.de
  13. satya Moderator

    Frank

    Do you agree the output from DBCC LOG is anyway readable/understandable, unless you're expert in hexadecimal computations its no easy task.

    Longback, I left my wish (read Tlog without using third-party tools) to MS to add this facility atleast in YUKON, wait and see.

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com
  14. FrankKalis Moderator

    <blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><br />Do you agree the output from DBCC LOG is anyway readable/understandable, unless you're expert in hexadecimal computations its no easy task.<br /><hr height="1" noshade id="quote"></blockquote id="quote"></font id="quote"><br />I definitely do agree !!!!<br /><br />I know one thing or two about hexadecimal, but there are more interesting things in life to cope with. That's what I wanted to point out. Hope nobody got me wrong. [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />So in clear words:<br />Save time, money and mental health and use a third party tool. Stay away from doing this on your own.<br /><br />Frank<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br /<a target="_blank" href=http://www.familienzirkus.de>http://www.familienzirkus.de</a>
  15. Jelly0228 New Member

    I had a look at ApexSQL,There is a good tool to view SQL Server Log.But it has no any information that about how to access SQL Server Log.
    as Staya said,DBCC LOG isn't easy task.I want to know how to read the new/old record when I update a record?Lumigent Log Explorer can do this but how to do with other Language??Any suggeustion?

    Jelly.
  16. satya Moderator

    Well if interested can talk directly to Brian for more understanding about his product or lastly may take help from MS Support which is unlikely will workout.

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com

Share This Page