Top Ten ASE MDA Tables

Some mon table  which help in finding the performance of server or query currently running.

1)   monProcessObject

Description

Provides statistical information regarding objects currently being accessed by processes.

2) monProcessStatement

Description

Provides information about the statement currently executing.

3) monProcess

Description

Provides detailed statistics about processes that are currently executing or waiting.

4) monProcessWaits

Description

Provides a list of all wait events for which current processes on the server are waiting. Returns only wait events whose Waits value is greater than zero.

5) monTableColumns

Description

Describes all the columns for each monitoring table. monTableColumns helps determine what columns are in the monitoring tables. You can join monTableColumns with monTables to report columns and column attributes for the monitoring tables.

6) monTables

Description

Provides a description of all monitoring tables. You can join monTables with monTableColumns for a description of each monitoring table and the columns it contains

Top Ten ASE MDA Tables

• monEngine

•monDataCache & monCachePool

•monCachedObject

•monProcedureCacheMemoryUsage & monProcedureCacheModuleUsage

•MonCachedProcedures

•monDeviceIO & monIOQueue

•monProcessActivity

•monSysWaits

•monOpenObjectActivity

•monSysStatement

For example monErrorLog is likely polled frequently

monCachedObject…which admittedly is fairly handy

monDeviceIO/monIOQueue frequently used for diagnosing device waits….used more frequently than…