Different rows returned when using same user on different jump server

WisonHii 81 Reputation points
2023-10-31T01:03:57.5266667+00:00

Here is one production database, so we only need to access it on anyone of 2 jump servers.

But when we use same user on different jump servers to run "select * from sys.dm_exec_sessions", the rows returned is different.

on Jump Server A, it only returns background sessions+the sessions issued by the user

on Jump Server B, it can return all the sessions in this database.

Actually, the user has VIEW DATABASE PERFORMANCE STATE and VIEW DATABASE STATE permission.

My question is: why it has different rows returned on different jump servers?

Azure SQL Database
{count} votes