SQL Server 2014 Question

Question

SQL Server 2014 Question

kazana

Valued Member

Points: 63
More actions
July 4, 2022 at 11:47 am

#4058458

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!
August 6, 2022 at 10:10 am

This was removed by the editor as SPAM

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Jeffrey Williams SSC Guru Points: 90303 More actions · Answer 1

A quick google search shows that the AppVManagement and AppVReporting databases are part of Application Virtualization (https://docs.microsoft.com/en-us/microsoft-desktop-optimization-pack/appv-v5/).

Guessing here - but the db_service and xm_service database appear to be related to some automation software.

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll

How to post questions to get better answers faster
Managing Transaction Logs

DNA_DBA SSCrazy Eights Points: 9116 More actions · Answer 2

I've had this multiple times before, where a server turns up with unidentified databases on it and nobody seems to have ever heard of. Here's what I do:

Check for any current connections using the databases - check the servers where the connection come from to find the apps
check the database_principals - the account name might identify what it is/was for
check for a user or logins table (or similar) - the users might be able to help identify what it is/was
check for *log* tables - these might have connection information or server names in them
check for date columns in the sys.columns and then find the latest dates in the associated tables - these might show when it was last used and might identify logging/history tables etc
check for tables with lots of metadata in them - sometimes you can determine what the app is based on the contents here (error messages, comments, descriptions etc)

ratbak Ten Centuries Points: 1358 More actions · Answer 3

Given how many times this identical question has turned up both here and on reddit, this has the earmarks of spam.

"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) & again on June 1st .

Grant Fritchey SSC Guru Points: 398882 More actions · Answer 4

I like the answer from @DNA_DBA. That's a great approach. To that I would add, query the cache to see what kind of queries are being run on the system. Further, it'll tell if any queries are being run. However, some queries don't go into cache, so you could also/instead set up monitoring with Extended Events to see the activity on the system. Either of these approaches add to what @DNA_DBA suggested.

"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