If you ever need to see if there’s any activity on your TFS Server in the past few minutes (maybe you are planning to take down the server or you are just troubleshooting a connectivity issue), you can run this query in SQL Server, on your collection database:
SELECT IdentityName, StartTime, [Application], Command
FROM tbl_Command with (nolock)
where StartTime > DATEADD(MINUTE, -10, GETUTCDATE())
The table tbl_Command has a few interesting pieces of data. This query brings back all the commands that were executed in the past 10 minutes. Remember that TFS keeps saves data in UTC time.
