I enabled Performance Insights on an existing SQL Server database (Express, if it matters) in AWS RDS. If I look at the database load graph and table I do not see any of the queries I am doing in real time. I see some queries that appear to be done by Amazon itself, such as selecting from rdsadmin.dbo.log_backup_manifest.

If I change the range to the past 24 hours, I see what appears to be a couple non-system queries on our actual data by another user. But I can't get any new queries to appear. I show up as a Host on the Hosts tab and as a User on the Users tab. The dashboard shows "0 sessions" even when I have SSMS open and connected to it, though.

Is there some condition I need to meet in order to have my query get recorded in Performance Insights? What's the criteria? How can I troubleshoot this?

  • 1
    same problem here Commented Aug 27, 2019 at 9:19


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.