Enabling MDA Tables
Go Up to Sybase ASE Performance Analyst Statistics
In ASE 12.5.0.3, a new feature called "MDA tables" was introduced. These proxy tables are mapped to RPCs which provide access to low-level monitoring information about the server. Refer to Sybase documentation for details on MDA tables. For assistance, see Accessing Third Party Documentation.
DBArtisan’s Performance Analyst for Sybase ASE requires these tables be installed to enable several statistics, for example the Top SQL view.
Please follow the instructions below to install and configure these tables.
- 1. Ensure the ‘enable cis” configuration parameter is set to 1.
- sp_configure 'enable cis'
- go
- 2. Add the ‘loopback’ server name alias.
- if not exists (select 1 from master..sysservers where srvname = "loopback")
- BEGIN
- exec sp_addserver "loopback", null, <enter your server name>
- END
- 3. Install the MDA tables.
- The script can be found in the following location:
- $SYBASE/$SYBASE_ASE/scripts/installmontables.
- 4. Assign the ‘mon_role’ to logins allowed MDA access.
- Note: The ‘sa’ login requires this grant as well.
- use master
- go
- grant role mon_role to sa
- go
- 5. Enable the following configuration parameters.
- exec sp_configure "enable monitoring", 1
- exec sp_configure "sql text pipe active", 1
- exec sp_configure "sql text pipe max messages", 2000
- exec sp_configure "plan text pipe active", 1
- exec sp_configure "plan text pipe max messages", 2000
- exec sp_configure "statement pipe active", 1
- exec sp_configure "statement pipe max messages", 2000
- exec sp_configure "errorlog pipe active", 1
- exec sp_configure "errorlog pipe max messages", 2000
- exec sp_configure "deadlock pipe active", 1
- exec sp_configure "deadlock pipe max messages", 2000
- exec sp_configure "wait event timing", 1
- exec sp_configure "process wait events", 1
- exec sp_configure "object lockwait timing", 1
- exec sp_configure "SQL batch capture", 1
- exec sp_configure "statement statistics active", 1
- exec sp_configure "per object statistics active", 1
- exec sp_configure "max SQL text monitored", 2000