SQL Server Performance

Capturing Queries to log files

Discussion in 'Analysis Services/Data Warehousing' started by california6, Oct 22, 2007.

  1. california6 New Member

    Is there a way, i could capture the queries ran against my OLAP box and log's them to a log file for later analysis? If I go to the OLAP Server properties - Logging, It say's to "Write to log once per ---- Queries. I have put "1" here in this box. But dont know, where are these queries written too? Any suggestions?
  2. techbabu303 New Member

    Iam not sure on OLAP based database, but normally I do run SQL profiler for logging queries and later sit on it for analysis.
  3. satya Moderator

  4. california6 New Member

    Thank you Satya for the answer.

Share This Page