June 1, 2022 at 11:04 am
Intercept the connections to get a glimpse of who connects from where and when.
You can start reading my little article "Logon monitoring in SQL Server and Azure Managed Instances - Adopting Extended Events" ( works the same for on-prem sqlserver )
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
June 1, 2022 at 12:37 pm
You can also do a query against the DMVs to see what's currently in cache in terms of queries against the databases. It won't show the kind of detailed activity Johan is suggesting (correctly, I might add), but it'll give you a ballpark on activity. Start with sys.dm_exec_query_stats.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 1, 2022 at 1:36 pm
"AppVManagement"Â & "AppVReporting" appear to be for Microsoft Application Virtualization: https://docs.microsoft.com/en-us/windows/application-management/app-v/appv-for-windows, https://docs.microsoft.com/en-us/windows/application-management/app-v/appv-deploy-appv-databases-with-sql-scripts
ReportServer &Â ReportServerTempDB are for SQL Server Reporting Services.
Note: This appears identical to a question that was asked on reddit in November 2021 & here on April 2 this year (removed as spam).
Viewing 3 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply