Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2012
    Posts
    9

    Unanswered: How to retrieve historical user queries

    Hi,

    Can anyone help me with the following requirements please.

    I have DWH where users query on regular basis. I wanted to know what queries they run and which user fired the queries for the last one month or 6 months.

    Please let me know how to achive this.

    Thanks,
    Sri.

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    If you're not already recording this data then you can't get it!

    One option to log this information is to use SQL Profiler and run a trace however you must note that this will affect your server performance.

    As for logging who is performing the queries; that really depends on how they are accessing your data: Windows or SQL authentication.
    George
    Home | Blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •