How to monitor TFS version upgrades through backend Data Tier Servers

At times, TFS upgrades may take longer time than expected and you might have to handover the activity to somebody else in your team. But the challenge is that, your colleague may not be able to monitor the upgrade via TFS Admin Console GUI so, the turnaround is to connect the backend data tier server --> connect to tfs_configuration database and run below sql query to get detailed information on the status of TFS upgrade.

Use TFS_configuration 

Go 

Select SJD.HostID, SH.Name, SJD.JobStatus, SJD.StartTime, SJD.EndTime, SJD.CompletedStepCount, SJD.TotalStepCount

FROM tbl_ServicingJobDetail SJD

Join tbl_ServiceHost SH on SH.HostID = SJD.HostID

Order By StartTime desc

Select top 10 * from dbo.tbl_ServicingStepDetail 

Order By DetailTime desc