Log Files

• Hussam-246110

  Newbie

  Points: 2

  More actions

  November 23, 2005 at 1:22 am

  #102949

  Dear All,

  Please I want a detailed process to read a SQL server 2000 log file to retrieve the data about executed queries such as CPU, time to execute ... And if there is any free softwares to download that facilitates this process.

  Thanks a lot

• Paul Randal

  One Orange Chip

  Points: 29544

  More actions

  November 24, 2005 at 10:28 am

  #605734

  Are you talking about the transaction log? That info isn't stored in the transaction log. Have a look at Profiler in BOL.

  Thanks

  Paul Randal
  CEO, SQLskills.com: Check out SQLskills online training!
  Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
  SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
  Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005