SQL Server Performance

Log Files

Discussion in 'Performance Tuning for DBAs' started by Sri316, Apr 26, 2005.

  1. Sri316 New Member

    Hi all
    What does server log files mean?? Is it the data files n transaction log files? How to see the contents of the log files? Kindly tr8 this as urgent n help me out


    Regards
    Srikkanth
  2. dineshasanka Moderator

    go to transaction logs, overview of BOL

    SQL Server uses the transaction log of each database to recover transactions. The transaction log is a serial record of all modifications that have occurred in the database as well as the transaction that performed each modification. The transaction log records the start of each transaction
    You can read more from there

    quote:Originally posted by Sri316

    Hi all
    What does server log files mean?? Is it the data files n transaction log files? How to see the contents of the log files? Kindly tr8 this as urgent n help me out


    Regards
    Srikkanth
  3. satya Moderator

    There is no easy way to read Transaction logs using SQL statement DBCC LOGINFO and you need third party tools liks Log Explorer from Lumigent or Log Navigator from APEX SQL.

    You cannot delete the Transaction log file as it is used by the database and in order to keep the size in manageable state you can deploy SIMPLE RECOVERY Model.

    As suggested books online is your best bet.

    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.
  4. mmarovic Active Member

    ... or maybe you asked about MSSQL Server log, not database transaction log?

    Db transaction log keeps record of transaction made for roll forward/back purpose and to be able to recover to the specific point of time (if you use full transaction log).

    MSSQL Server log is event log - completely different purpose. You can see its content from enterprise manager.

Share This Page