Warning during setup of Analytics portal
Is this something that I need to worry about?
Davis_Mathai Member Adept IT Monkey ✭✭Hi Tomi, I'm not an expert in SQL but you can use the command 'EXEC sp_who' (https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-who-transact-sql)against the master database to check what commands are running against each database on the instance and the session ID. EXEC sp_lock will give you any session IDs and their lock states (https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-lock-transact-sql). Hope that helps...5
When you ran the upgrade did you also upgrade the Database or did you turn that off as part of the installer?
After the install has finished does it say it was successful?
Does the portal load?
Do you have the new administration items that allow you to set retention settings?
Is there any SQL command I could run to determine if there are locked tables?