Is there any way we can get these info like server/program/user/session id for historical queries with the help of query store or DMV's? I know dmv's store session info for currently fired queries but not getting from where we can get session info for historical data.
When will you add Query Store to Azure Data Studio? :)) As a DBA, I still can't use ADS because it's more designed for developers and not DBAs. This is very sad.
"Is your DBA Here?" CALLED OUT. YES.
Query Store is nice. The only thing I miss there is the information about server_name/program_name that query executed from
Is there any way we can get these info like server/program/user/session id for historical queries?
Is there any way we can get these info like server/program/user/session id for historical queries with the help of query store or DMV's?
I know dmv's store session info for currently fired queries but not getting from where we can get session info for historical data.
When will you add Query Store to Azure Data Studio? :)) As a DBA, I still can't use ADS because it's more designed for developers and not DBAs. This is very sad.