title: sql server: how to know how many transactions were made per hour?
body: <p>I'm trying to find a way (maybe with sys DB) to retrieve information of all the queries executed per hour on the user databases.
  my client wants me to give him a daily report via SSRS of transaction per hour I would love to hear suggestions scanned the internet with no luck.</p>
  
  <p>edit: im trying to understand where to get this information from its not about how to filter results per hour 
  thanks</p>