June 1, 2022 at 10:13 am
So I have inherited an older SQL 2014 Server and have been working on understanding what I need to migrate or can shutdown without affecting our current applications. There is only one DB i know for a fact that relates to a digital faxing server we use
I have a collection of 6 Databases with the following names.
AppVManagement
AppVReporting
DB_service
ReportServer
ReportServerTempDB
XM_service
I've tried to find some detail about some of them but came up empty handed on most of them except the ReportServer DB's. Does anyone know or have details about what these databases may refer too?
Thanks for any help provided!
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/code to get the best help[/url]
- 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).
June 21, 2022 at 1:46 pm
This was removed by the editor as SPAM
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply