log data

• Hussam-246110

  Newbie

  Points: 2

  More actions

  November 25, 2005 at 4:52 am

  #89971

  hello all,

  Thanks Mr. Randal, But I want to retrieve the data about executed queries such as CPU, time to execute... and if there is any command that these data are saved in the log files so that I can retrieve...

  Thanks again

• Phil Parkin

  SSC Guru

  Points: 247180

  More actions

  November 25, 2005 at 5:08 am

  #605836

  This appears to be a reply to a non-existent message

  ---

• Paul Randal

  One Orange Chip

  Points: 29544

  More actions

  November 25, 2005 at 9:31 am

  #605873

  Hussam - please don't start a new thread to reply. As I've already explained - this data isn't captured in a log file anywhere. Look up 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