title: How to view history of queries (all OR over a long period) performed on database which is hosted on Azure?
body: <p>For a database hosted on Azure, i can view the recent history of the queries performed on it. This is through the <strong>Azure portal > Database > Manage > Administration > Query Performance</strong>.</p>
  
  <p>Unfortunately, the history found there, only covers a small time frame (few minutes). I intend to create non-clustered indexes on my database and for that, need to get a log of the real queries run on the data on a typical day, as opposed to the past few minutes.</p>
  
  <p>Currently, i have to keep refreshing the page many times and record all the queries for each refresh, Even then, the log which i obtain after this arduous process, only reflects a small subset of the queries performed. Is there any option to view histories for longer periods?</p>
  
  <p>Thanks.</p>