SQL Server 2014 Question

Question

SQL Server 2014 Question

Viewing 4 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: 90350 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: 9172 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 Default port Points: 1423 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: 399330 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