Sunday, August 16, 2009

SQL Server profiler simplest settings

Got this off the LINQ videos on ASP site. (BTW cool stuff LINQ!)

  • start the sql profiler
  • click new trace
  • connect to your database
  • click on event selection and uncheck all
  • still in event selection check show all events and also check show all columns
  • Now check SP:StmtCompleted in events.
  • Next check the TextData column for this event.
  • Click Run