<Database name="NOG_APP">
   <Locks>
      <Lock request_mode="S" request_status="GRANT" request_count="1" />
   </Locks>
</Database>

USE NOG_APP;
GO
BEGIN TRAN;
GO

sp_WhoIsActive @get_locks = 1;