AquaFold
HOME SCREENSHOTS DOWNLOAD DOCUMENTATION SUPPORT LICENSING CONTACT
 

Documentation: Aqua Data Studio 6.5 - New Features     HTML Documentation download, ZIP: ads-docs.zip (Size: 84.7MB) / ads-docs-no-shots.zip (Size: 1.2MB)
  Getting Started
  Installation
  JDBC Drivers
   Oracle 8i
   Oracle 9i
   Oracle 10g
   DB2 7.2
   DB2 8.1
   DB2 9.0
   SQL Server
   Sybase ASE
   Sybase Anywhere
   Sybase IQ
   Informix
   PostgreSQL
   MySQL
  Memory Configuration
  Character sets
  Registering Servers
   MSDE 2000
   SQL Express 2005
   PostgreSQL SSL
  Application
   Browser and Scripting
   Visual Editing
   SQL History and Archive
   Shortcut Toolbar
   Key Mappings
   Key Mapping Assistant
   Custom Keymap Profiles
   Options
   Settings
   New Frame Window
   Details View
   Command Line
  Query Window
   Basics
   Toolbar
   Server Side Comments
   SQL Automation
   Aqua Commands
   Morph to Delimited List
   Results
   Save Results
   Auto-completion
   Popup Menu
   SQL Formatter
   Permissions
   Parameterized
   Pivot Results (Grid and Chart)
   Grid Results (Grid and Chart)
  Editors
   SQL Editor
   Text Editor
   HTML Editor
   XML Editor
   Regular Expressions
  Image Viewer
  Visual Explain Plan
   Basics
   Explain Plan
   Explain Diagram
   Whiteboard
  Procedure/Package Editor
  SQL Debugger
   Sybase Debugger
   Oracle Debugger
  Tools
   Table Data Editor
   Schema Script Generator
   Server Script Generator
   ER Diagram
   Query Builder
   Import Tool
   Export Tool
   Execution Monitor
   Object Search
  Compare Tools
   Schema Compare
   Tab Compare
   Directory Compare
   File Compare
   Copy History Compare
   Results Compare
  Oracle DBA Tools
   Instance Manager
   Storage Manager
   Rollback Manager
   Log Manager
   Security Manager
   Session Manager
   SGA Manager
   Server Statistics
  SQL Server DBA Tools
   Instance Manager
   Storage Manager
   Security Manager
   Session Manager
   SQL Agent Manager
  Sybase DBA Tools
   Instance Manager
   Storage Manager
   Security Manager
   Session Manager
  Source Control
   Subversion
   CVS
MS SQL DBA Tools - Session Manager

Provides manageability of database sessions, including user and system locks. Allowing the user to kill/disconnect sessions, start traces and monitor open cursors and user queries with execution plans.
MS SQL DBA Tools - Session Manager


Toolbar Operations -

Refresh : Refresh all the tab results from the database
Refresh Seconds: The interval in which to refresh the tabs if "Auto Refresh" is enabled
Auto Refresh: Indicates whether to refresh the tab results automatically every X number of seconds determined by the "Refresh Seconds"
Kill Session: Allows to kill selected session
Group Sessions: Allows to group running sessions by User Name, Program Name, Database, Status, Hostname, Command, allowing to locate settions easier

Sessions Tab - Provides a list of sessions currently held by the MS SQL server, as a tree view

User: Server user name (login)
Process ID: Process ID
Context ID: Execution context ID used to uniquely identify the subthreads operating on behalf of a single process
Database: Database name
Status: Process status
Open Transactions: Number of open transactions for the process
Command: Command or process currently being executed
Application: Name of front-end module
Wait Time: Current wait time in milliseconds. 0 = Process is not waiting.
Wait Type: Reserved
Wait Resource: Textual representation of a lock resource
CPU: Cumulative CPU time for process in ticks
Physical IO: Number of disk reads and writes for current command
Memory Usage: Amount of memory allocated to process
Login Time: Time at which a client process logged into the server. For system processes, the time at which the SQL Server startup occurred is stored.
Last Batch: Last time a client process executed a remote stored procedure call or an EXECUTE statement. For system processes, the time at which the SQL Server startup occurred is stored.
Host: Name of host computer
Network Library: Column in which the client's network library is stored. Every client process comes in on a network connection. Network connections have a network library associated with them that enables them to make the connection.
Network Address: Assigned unique identifier for the network adapter on the workstation of each user. When a user logs in, this identifier is inserted in the net_address column.
Blocked By: Process ID of blocking process, if any
Blocking: Whether the process is blocking another process

MS SQL Session Manager Syntax Coloring
MS SQL DBA Tools - Session Manager - Syntax Coloring


MS SQL Session Manager
MS SQL DBA Tools - Session Manager - Sessions Tab
Sessions Tab - Session Detail - This tab provides detailed information on the currently selected session



MS SQL Session Details
MS SQL DBA Tools - Session Manager - Session Detail Tab

Sessions Stats Tab - Provides a list of sessions currently held by the MS SQL server

Process ID: Process ID
Context ID: Execution context ID used to uniquely identify the subthreads operating on behalf of a single process
User: Server user name (login)
Database: Database name
Status: Process status
Open Transactions: Number of open transactions for the process
Command: Command or process currently being executed
Application: Name of front-end module
Wait Time: Current wait time in milliseconds. 0 = Process is not waiting.
Wait Type: Reserved
Wait Resource: Textual representation of a lock resource
CPU: Cumulative CPU time for process in ticks
Physical IO: Number of disk reads and writes for current command
Memory Usage: Amount of memory allocated to process
Login Time: Time at which a client process logged into the server. For system processes, the time at which the SQL Server startup occurred is stored.
Last Batch: Last time a client process executed a remote stored procedure call or an EXECUTE statement. For system processes, the time at which the SQL Server startup occurred is stored.
Host: Name of host computer
Network Library: Column in which the client's network library is stored. Every client process comes in on a network connection. Network connections have a network library associated with them that enables them to make the connection.
Network Address: Assigned unique identifier for the network adapter on the workstation of each user. When a user logs in, this identifier is inserted in the net_address column.
Blocked By: Process ID of blocking process, if any
Blocking: Whether the process is blocking another process

MS SQL Session Manager - Session Stats
MS SQL DBA Tools - Session Manager - Session Statistics Tab

Locks Tab - Provides a list of Transaction, DML and PL/SQL locks currently held by the Sybase server, as a tree view

Session/Lock: Name of session or lock
Status: Process status
Type: Lock Type
Mode:
User: Server user name(login)
Session ID: Session ID
Database: Database name
Object: Object (table) name to be locked
FID: Process ID of the worker process' parent
Host Name: Name of host computer
Program: Name of front-end module
Blocking: Indicates if the session is blocking another one


MS SQL Session Manager - Locks
MS SQL DBA Tools - Session Manager - Locks Tab
Home Screenshots Downloads Documentation Support Licensing Contact Copyright© 2001-2007 AquaFold, Inc. All Rights Reserved