Forum Discussion
HDale17
Jun 29, 2023Copper Contributor
SQL Monitoring Question
How do I see all queries run between 2:00 am and 2:30 am on a SQL Server? Am I also able to see the query text that was used?
- olafhelperBronze Contributor
HDale17 , if you haven't implemented a query audit, then it's not really possible to get queries afterwards.
In newer SQL Server version you can enable the "Query Store" feature, see
Monitor performance by using the Query Store - SQL Server | Microsoft Learn