AGS S1 E5 HD - Object Explorer
Have you ever tried to calculate the total size of a database when you have several in the same instance? This is one of many mysteries unlocked in AGS. Just click on an object at any level, and all the information that you are likely to need is immediately available, together with the ability to create/modify/drop objects (depending on permissions). At the instance level, view profile data, logical logs, configuration (comparing startup, current and default values) and the message log: no more obscure “onstat” commands! Want to know which tables have the most extents? Click on the table node and sort by the extents column. This presentation also includes an introduction to the session explorer and explains how to examine user level activity and control user sessions.