My SQL server 2016 database had 100% CPU Utilization issue at 06:30. Now I want to check which query or user caused this issue. I searched some articles online. They are all showing how to check it when the query is running. But what I want is to check history at 06:30. The database is fine now. So if I check the performance now, I can't find any query/job are running now. How do I check the history to identify the cause?
from ssms, run the activity monitor for the server and look at recent expensive queries.