title: Azure SQL Server: How to check which queries and how much resources they have used?
body: <p>I have a SQL server DB (on Azure SQL Elastic pool). I want to optimize my queries so the best approach for me would be to check how many times a query has been ran and how much resources (CPU, IO, etc.) they have used. How can I do it?</p>
  
  <p>I wonder if it is possible to do something like what we have on Application Insights.</p>