SQL Monitoring Question

Copper Contributor

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? 

1 Reply

@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